Get Schema("INDEXES");"Also when I execute "SELECT ORDER() FROM testfile.dbf" I get an emptystring back.I do not want to create any new indexes, just use the perfectly goodexisting ones! I havesuccessfully opened DBF files from C# using vfpoleddb driver (VFP 9.0)and SQL SELECT statements.It is also possible to open external databases directly from Microsoft Access Basic.When a table from another database is linked it behaves just like a native, local table.
I'm hoping to avoid the solution of informing out support team / developers not to update column X via SQL. And I also think that it works with CDX as well; the file would probably be incompatible with other DBF/CDX types of drivers since they may expect the limit to be 50. We are still on ADS 8 so the limitation might still be there.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
), hence the need for additional (non auto-open) index files.
When I perform updates to the table via my application, everything works correctly.
I havesuccessfully opened DBF files from C# using vfpoleddb driver (VFP 9.0)and SQL SELECT statements.