Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing a table from OleDb
Message
 
To
14/09/2006 23:48:32
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01153964
Message ID:
01153999
Views:
18
>Would it there be a way to index a table from the OleDb approach? I have a VB.NET application using VFP as the backend. I have everything needed from the Tag.dbf table to reindex a table. Is that possible by the use of the OleDb approach without having to build a VFP robot application just for that?

No directly from VB (INDEX ON is unsupported command for OleDb), but you could create a StoredProcedure in DBC and call it (not tested).
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform