Need to load a substring over devforce

 

Basically we defined the query for the entity in the model (rather than using table def) and the particular column was truncated in the query itself, then we created another entity with the records id and the full value and joined the two entities 1 to 1. Though these technically point to the same table in the database each entity had its particular data and we only retrieved the full data at one record at a time as necessary. It also allowed us to edit it easy enough.

 

I am not claiming this is a great solution but it worked in our situation.

 

In another more data intense scenario we ended up moving the lob to its own table but the model basically remained the same.

my problem is the following:

I have a field in a database table (the field is named "content"). During the loading of the table records, I don't want to extract the entire field value , but the x first characters.

Example:

Content = "Hello world , how are you ??"

what should be extracted = "Hello world"

I ask if there is a manner to make it directly in DevForce (cause of the huge amount of information to transport over the network).

Thanks a lot in advance