Re: ActualSize returns -1 for Text fields

Dan

Thanks for the response.

> Do you read that field multiple times?

No, not that I am aware of. As I said in my original post, I can get the
one query (that has the text field specified last) to work, but other
equivalent queries do not work. This seems to be the crux of the problem
(or bug). Have you seen this?

Has anyone out there have a table with more then one Text field? Seems to
me this problem would affect anyone with such a table that needed to run a
query that returned two or more of these fields.

> IIRC, using a server side cursor the
> first time you read the field ADO will then discard the underlying pointer
> to that text field, and all fields to the left of it in the recordset.
Then
> if you attempt to read the field or it's properties a second time it will
> appear as empty with a size of -1. I always read ADO recordsets from left
to
> write, and if I need to check the value of a field more than once then I
> read it into a variable, and use the variable for subsequent tests.

What exactly do you mean by "I always read ADO recordsets from left to
right"?

Thanks,
Rod


.

Relevant Pages

  • Re: ActualSize returns -1 for Text fields
    ... ActualSize of this ... Same is true if I use the query explicitly listing ... first time you read the field ADO will then discard the underlying pointer ... I always read ADO recordsets from left to ...
    (microsoft.public.data.ado)
  • DTS ActiveX task
    ... I have a task that I want to use a combination of ADO recordsets and TSQL. ... How do I, for instance perform a count query, and do some functionality ...
    (microsoft.public.sqlserver.dts)
  • Re: Query design using wildcards
    ... QM-101 etc. I'd like the query to get all the QP's. ... > And, if by some chance you're using ADO recordsets, the wildcard will be %, ... > Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.tablesdbdesign)