Problems to get large fields in RDO!!!

[Emidio]

Hy guys!

I have created a Stored Procedure to return to my front-end (VB) some fields and one nText datatype (Obs) don't can be seen by Resultset.

Occur this error:
'Client Cursor: 11 - No update tables are specified'

I try to convert (using CAST) to VARCHAR datatype, but I found a limit of 1024 character and I need 1500 characters in Obs field.

How can I do to get a large field with RDO?

Tkx

[Glenn]

What database are you using MS Sql Server or ?

If you are using MS SQL Server then what version 6.5, 7.0 ?

I've been able to read large text fields using the getchunk methods. It's kinda of complicated but it works. I've used it successfully with MS SQL Version 6.5

If you need an example of the code let me know.

:) :) :)

[Emidio]

Hi Glenn,

I just found the answer of my problem in

http://support.microsoft.com/support/kb/articles/Q181/7/15.ASP

BTW, I'm using VB5 + Tree Tier metod programming + Client Batch cursor in RDO metod + ODBC + MSSQL7.

TIA

Emidio.