Reading Clob

jp · Post by jp » Tue 16 Jun 2009 09:43

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

Plash · Post by **Plash** » Wed 17 Jun 2009 09:15

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.

jp · Post by jp » Wed 17 Jun 2009 09:24

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

Plash · Post by **Plash** » Fri 19 Jun 2009 08:20

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

jp · Post by jp » Sun 28 Jun 2009 16:36

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

Plash · Post by **Plash** » Tue 30 Jun 2009 10:50

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?

jp · Post by jp » Tue 30 Jun 2009 15:37

Hi,

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

thanks,

jp

Plash · Post by **Plash** » Wed 01 Jul 2009 07:45

We have received your e-mail.

jp · Post by jp » Wed 01 Jul 2009 08:50

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

Plash · Post by **Plash** » Thu 02 Jul 2009 10:03

Please see my e-mail reply.

Devart Forums

Reading Clob

Reading Clob

Reading Clob

PostPosted: Wed Jun 17, 2009 9:24 am Post subject: Readin