Problems to get large fields in RDO!!!-VBForums
Results 1 to 7 of 7

Thread: Problems to get large fields in RDO!!!

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jan 1999
    Location
    Juiz de Fora, MG, Brazil
    Posts
    30

    Exclamation

    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
    Emidio do Nascimento
    --------------------
    Programmer, teacher and consultant.
    emidio@terra.com.br
    Juiz de Fora/MG
    BRAZIL

  2. #2
    Addicted Member
    Join Date
    Jan 2000
    Location
    Oshkosh, WI
    Posts
    163

    Lightbulb

    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.

    Glenn D
    Development/Analyst

  3. #3

    Thread Starter
    Junior Member
    Join Date
    Jan 1999
    Location
    Juiz de Fora, MG, Brazil
    Posts
    30

    Wink

    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.
    Emidio do Nascimento
    --------------------
    Programmer, teacher and consultant.
    emidio@terra.com.br
    Juiz de Fora/MG
    BRAZIL

  4. #4
    New Member
    Join Date
    Apr 2017
    Posts
    2

    Re: Problems to get large fields in RDO!!!

    Quote Originally Posted by Glenn View Post
    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

  5. #5
    New Member
    Join Date
    Apr 2017
    Posts
    2

    Re: Problems to get large fields in RDO!!!

    Quote Originally Posted by Emidio View Post
    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

  6. #6
    PowerPoster
    Join Date
    Oct 2013
    Posts
    2,843

    Re: Problems to get large fields in RDO!!!

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

  7. #7
    Super Moderator Shaggy Hiker's Avatar
    Join Date
    Aug 2002
    Location
    Idaho
    Posts
    30,823

    Re: Problems to get large fields in RDO!!!

    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.
    My usual boring signature: Nothing

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.