I am using Visio Enterprise to design Visual FoxPro databases. Although it does a great job in reverse-engineering a VFP database, it cannot update it. The DDL commands generated are (according to Visio) not supported by VFP's ODBC.

I find commands like:

INSERT INTO (field1, field2, etc.) ;
SELECT a,b,c, FROM

which are not supported by VFP. Fields cannot be dropped from the VFP ODBC either. Does anyone know of any another ODBC I can download that may be more flexible?

Thank you,
Aristotle

Aristotle