Row counts differ between VFP IDE and ODBC Code

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)
  • Re: Row counts differ between VFP IDE and ODBC Application
    ... You may be seeing deleted records in one instance, ... 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)
  • Re: execute() vs executeUpdate() on a prepared statement
    ... the bug quickly,thanks. ... Server 2005 JDBC Driver ... execute may attempt to create a cursor. ... As you can tell the most important part of the repro is the SQL used ...
    (microsoft.public.sqlserver.jdbcdriver)
  • 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)