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.../Q181/7/15.ASP

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

TIA

Emidio.

[er.vikasverma]

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.

Hi Glenn,
I am facing same issues, could you please help me how to get rid out from this?

Regards
Vikas

[er.vikasverma]

Hi Glenn,

I just found the answer of my problem in

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

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

TIA

Emidio.

Hi Emidio,
I am facing same issues and trying to click on above link which you mentioned in your post - 'I just found the answer of my problem in

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

the above link is not available.

could you please let me know what i need to do to get rid out of this?

Regards
Vikas

[Arnoutdv]

Did you notice that the post from Emidio is from the year 2000, that's almost 17 years ago!

[Shaggy Hiker]

Neither of the people you mentioned have been active in well over a decade. The thing to do is to forget about this thread and start a new thread asking the question you have. Aside from that, those posts were about RDO, which was a DB technology that had a really brief lifespan. You shouldn't be using it, as it was rapidly replaced by other, superior, alternatives.