LONG datatype field in Oracle

Hello,

Does anyone know how to open a "LONG" field in Oracle into a text box? It works with all other datatypes. I use RDO engine to open a recordset.
Please, help!

Thanks,

Olga

Well, the method is the same as in ADO or in RDO. What problem are you haveing?
Try taking the field in a variable and then display that variable in the text box. In this way you will know that wheather or not the field is empty.

FWIW, MSDN Q104958 lists ODBC Oracle Driver versions 1.00.2816 and 1.00.3112 for a "known bug" to error on field names greater than 17 characters using an outer join. Their fix is to use names <= char(17).

It looks like if I have less then 90 records in the recordset, I'm able to retrieve a value of the field (strString=rdo.rdoColumns(0))
But, if I have more then 90 records, it doesn't work. My field contains 3-4kb of text. And, I have over 5 thousand records!
I'm using Oracle 8 drivers.

RDO cannot show values more than 100 records
For more rows, you have to use the
rdoRS.GetRows n
where n= no. of records.