Re: Row counts differ between VFP IDE and ODBC Application

You may be seeing deleted records in one instance, and not in the other.
SET DELETED ON/OFF can control this.

--
Fred
Microsoft Visual FoxPro MVP


<matsi.inc@xxxxxxxxx> wrote in message
news:1165622853.568205.191300@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am working with an older version of FoxPro and am having a problem
with the row counts not matching when I execute the same statement.
When I use the VFP IDE, and run the statement 'select * from inv', I
get a count of 13336 records. When I take the same statement and
execute it from my application using the VFP ODBC driver (Setup as a
DSN), I get 10846 records.

Not sure if it was the driver... I modified the statement to read
'select * from inv where sdate >= CTOD("11/01/2006")' and executed it
in the VFP IDE and got 5900 records. I then took the statement and
executed it in my application and got 5900 records... the same number.
(Which is what I would expect.)

I have tried a number of different drivers and all worked the same. I
have tried loading the data from my application into a DataTable using
an ODBCAdapeter, into an object collection using a DataReader, and even
returning the DataReader directly and counting the number of reads...
and still only get 10846 records.

I am at a loss now as where to go next. Any help would be greatly
appreciated as my client is breathing down my neck!



.

Relevant Pages

  • Re: Row counts differ between VFP IDE and ODBC Application
    ... Microsoft Visual FoxPro MVP ... with the row counts not matching when I execute the same statement. ... When I use the VFP IDE, and run the statement 'select * from inv', I ... Not sure if it was the driver... ...
    (microsoft.public.fox.programmer.exchange)
  • Row counts differ between VFP IDE and ODBC Code
    ... with the row counts not matching when I execute the same statement. ... When I use the VFP IDE, and run the statement 'select * from inv', I ... Not sure if it was the driver... ...
    (microsoft.public.data.odbc)
  • Row counts differ between VFP IDE and ODBC Application
    ... with the row counts not matching when I execute the same statement. ... When I use the VFP IDE, and run the statement 'select * from inv', I ... Not sure if it was the driver... ...
    (microsoft.public.fox.programmer.exchange)
  • Row counts differ between VFP IDE and ODBC Code
    ... with the row counts not matching when I execute the same statement. ... When I use the VFP IDE, and run the statement 'select * from inv', I ... Not sure if it was the driver... ...
    (microsoft.public.data.odbc)