Re: Fascinating DB Problem

"Jeff Davis" <jd_home@xxxxxxxxxx> wrote

>A query to a db returns a recordset. The first time the recordset is inspected SOME of the fields' data values are
>present. SOME aren't. I look at the table in the db monitor and ALL the fields have values. I insert a trace loop into
>the code. The trace loop reports ALL the fields have values. I remove the trace loop. The problem recurs. I change the
>trace loop to an assignment statement which I ignore. The problem is solved.
>
> What #1 Son refers to as a Heidegger's Cat Problem.

I had a similar problem trying to read an Excel spreadsheet in
VB. I don't remember what fixed it.

If you were accessing a complex stored procedure on SQL Server,
I would say "SET NOCOUNT ON".

If you are using an ADO recordset directly to the table, I would
make sure your recordset is not updatable, and maybe do rst.movelast
and rst.movefirst.

If you aren't using mickeysoft, congratulations.

--Tedward


.

Relevant Pages

  • Re: Recordset or Object is closed HELP PLEASE!
    ... this is the first time i'm doing VBA. ... how am i supposed to display the records found in the recordset onto the excel sheet? ... >> different query that is simpler. ... >> that this query Declares Variables and Sets those ...
    (microsoft.public.excel.programming)
  • Re: Pivot query
    ... engine cannot find the input table or query 'Stock'. ... But, then i try to open the recordset a secondtime, and it works fine! ... than in executing...the gist being that the first time gave it a "start" ...
    (microsoft.public.access.queries)
  • Re: Fascinating DB Problem
    ... >> A query to a db returns a recordset. ... The first time the recordset is ... >> insert a trace loop into the code. ... anywhere in the program would make it compile. ...
    (rec.sport.football.college)
  • Re: Fascinating DB Problem
    ... > A query to a db returns a recordset. ... The first time the recordset is ... The trace loop reports ALL the fields ... I used to get a similar problem under the old Fortran IV. ...
    (rec.sport.football.college)
  • Re: Fascinating DB Problem
    ... >>>A query to a db returns a recordset. ... The first time the recordset is ... >>>insert a trace loop into the code. ... industrial strength database product does exhibits ...
    (rec.sport.football.college)