MyODBC and Visual Foxpro trouble

Hi all,

I'm having trouble with remote views in VFP 8/9 and MySQL over ODBC.

Every time I create a remote view, even with the option nodata, and do a
requery, MySQL always does a select * from "desired_table" and a select
keys from "desired_tables" before firing the originated query. This
leads to the fact that the whole table is transferred before the desired
query is done (not funny pulling 100's of MB over the net...).

Same thing on MSSQL server and SQLODBC works

Has anyone encountered the same issue and found a solution?

Regards,
Sebastian

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org