Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing a table from OleDb
Message
From
23/09/2006 03:51:46
 
 
To
18/09/2006 13:40:18
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:
01156678
Views:
8
This message has been marked as the solution to the initial question of the thread.
>>No directly from VB (INDEX ON is unsupported command for OleDb), but you could create a StoredProcedure in DBC and call it (not tested).
>
>I will probably use the route of the CommandText by issuing a series of commands with the ExecuteNonQuery().

Hi Michel,

You can use EXECSCRIPT() function, VFPOLEDB supports it.

Thanks,
Aleksey.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform