Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Text datatype with forwardonly (VB6/VBA)

    When opening an ADO recordset using adOpenForwardOnly it seems to drop the data in text/memo type fields as soon it is accessed.

    Using debug I can see that it does get the data from the source, but as soon as I try to use it, the value disappears and null is returned.
    I suspect this has something to do with how ADO reads text type fields as when I use cast to convert it to a varchar it works fine! That is not a very good solution however as I believe varchar can't hold as much data as text.

    Can anyone confirm what is going on, i.e. why text type fields get dropped when accessed?

    Any help would be much appreciated.

  2. #2
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text datatype with forwardonly (VB6/VBA)

    Wow, i've never used a search on google groups before - very handy.

    Apparently my above problem is a bug with ADO and I read advise to use adOpenKeyset instead, which will have to do.

Posting Permissions

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