MySQL through ODBC

ODBC Connectivity, ELFs , Windows API etc.

Moderators: Phil Winkler, Graham Smith, Pete Tabord

MySQL through ODBC

Postby pkpk » Thu Sep 04, 2008 4:28 pm

I am getting bizarre behavior while connecting to an MySQL 5 database through ODBC

Ffenics correctly reports 8579 records in the "truck" table on the bottom left of the screen in the Ffenics-generated form over truck. However if I "F3" through the table, Ffenics reports no more records at record 8. If I run the default Ffenics-generated report over truck, only seven records are produced.

For another table, "truck_pickup", Ffenics can will show only 4188 of 9802 records.
For another table, "trucker", Ffenics shows 0 of the 1355 records.

MS Access has no problem seeing all of the records in all of these tables through this same ODBC connection.

As an aside, Ffenics asks me for a name and password, which is unnecessary as
these are built into the ODBC connection.

Thanks for any help,
Peter Kopke
Posts: 5
Joined: Thu Jul 31, 2008 7:34 pm
Has thanked: 0 time
Been thanked: 0 time

Return to Advanced

Who is online

Users browsing this forum: No registered users and 1 guest