Devart Forums

Hi,

I am trying to populate a memo component with the contents of a Clob field and I am only getting the first 4,000 characters.

memComments.Text := fieldbyname('email_text').Value;

Is there a setting anywhere I need to look at changing to retreive the rest of the data?

thanks,

jp

The Value property should return the full data for the CLOB field.

Please check the value in the database. Maybe it is stored truncated in the database.

Hi,

The data is written to the database with a java app so I will investigate how that does it - it can read the full data back. I think I am running on an older version of the odac library - would you know if there have been any fixes in this area?

thanks,

jp

There was some changes in code that works with LOBs. You can check the problem with the latest version of ODAC.

Hi,

I have updated to the latest ODAC 6.8 and my program now hangs when trying to read from the db with a query. If I set cachelobs to false for the query then i can read the record, but the program hangs if i try to assign the clob to a memo control. Is there anything special i need to do to read the clob - even if truncated. I am using a query, but could use a filtered table if necessary. If you have code example that would be a great help.

thanks,

jp

Nothing special is needed to read the CLOB. Please send to odac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.

Please specify the following: do you connect in the Direct mode? What is the character set of your database?

Hi,

I have e-mailed some example code - please could you confirm if this has been received.

thanks,

jp

We have received your e-mail.

Thanks for confirming - do you think you will have a chance to look at the problem today?

Please see my e-mail reply.