>Hello All,
>
>I'm trying to write an app which will be querying Clipper tables. Since Clipper tables are .DBF files, I try to open the tables with the "USE" command to see if VFP will treat them as native tables.
>
>When I try the "USE" command, I get five consecutive "Alias 'FIELD' Not Found" error messages, and then the table opens.
>
>Obviously, I can't have the error messages pop up during the app's startup, so my question is this: Does anyone know if you can open and use Clipper tables in VFP without using an ODBC driver?
>
>Thanks in advance,
>
>Ben Holton
Hi Ben,
I beleive that you can open Clipper dbf files in VFP, using FOX2X clause, but VFP itself, won't update Clipper NTX indexes. Then take into consideration differences in how VFP and Clipper deal with MEMO fields and locking.
I had the same problem, trying access Clipper tables using Access. My solution is to use Codebase (
www.sequiter.com ), which provides extensive set of DLL based functions. BTW Codebase is very fast in accessing and updating data.
This is my two cents.
Igor
Igor Gelin
Database Developer