oracle database

[Guest]

I am linking to an ORACLE 9i database and producing reports on the data by
using ODBC linking. On a field, which is defined in the linked table as a
memo field, the data is being cut to the last few characters over about 250
(it varies). Any ideas?

 

[Pieter Wijnen]

Try using the GetChunk method of a Recordset to retrieve & populate the
report's "memo" field instead of including the CLOB/VarChar2 field in the
query for the report

HTH

Pieter

 

[Pieter Wijnen]

Try using the GetChunk method of a Recordset to retrieve & populate the
report's "memo" field instead of including the CLOB/VarChar2 field in the
query for the report

HTH

Pieter

I am linking to an ORACLE 9i database and producing reports on the data by
using ODBC linking. On a field, which is defined in the linked table as a
memo field, the data is being cut to the last few characters over about
250
(it varies). Any ideas?

--