Re:Foxpro ODBC and all that
FoxPro 2.6 tables are directly supported by BDE using the native FoxPro
driver. Just select the native FoxPro driver - not the Visual FoxPro
driver, which is really an ms ODBC driver and provides less support than
does the BDE native driver. The first problem you are likely to run
into is the fact that BDE does not support VFP files - you need to save
your FoxPro files in the Fox2x format. Also, you will find that support
for FoxPro expression indices is limited - use GotoNearest for indexed
searches, other VCL functions either err or do sequential searches.
Finally you will find that localSQL has some serious performance
problems on FoxPro tables.
- Leo