>As I understand the ODBC docs for the VFP 5 & 6 drivers, you can use those to read Fox 2.x tables. Although the drivers are faster than the Fox 2.x ODBC, they did not return valid results. With a Fox 2.x table of employee data, i.e. SSN and names, the new drivers returned correct results for SSN queries but did not for last name searches. Has anyone experienced similar problems?
>
>The SSN and Last Name fields are both character. When I searched for last names of Zimmerman, the VFP ODBC returned nothing while Fox 2.x ODBC returned the correct results. However, searching by Mendenhall returned the correct results for both. I had similar problems with Smith and Jones for example--Fox 2.x was consistently correct. Any ideas besides creating a VFP COM object? Or should I accept Fox 2.x ODBC reliability over performance--dumb question?
>
>Thanks in advance...
>
>Regards,
>
>Jack Mendenhall
>RMI
Jack,
The way you write the query is important too. You have to use SQL syntax and for example replace the "=" by a "LIKE" and these sort of things.
José