LONG datatype field in Oracle

[OlgaV]

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

[aamer]

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.

[Mongo]

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).

[OlgaV]

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.

[aamer]

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