Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing using OleDb
Message
From
18/09/2006 15:13:04
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
18/09/2006 14:45:51
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:
01154852
Message ID:
01154872
Views:
7
>Has anyone found a way to create a tag on a VFP table by the use of the OleDb provider? I have a VB.NET application making use of the OleDb provider to talk to Visual FoxPro. I have all the data dictionary in place to reindex, in case a problem occurs with one of the tag. But, if I try to execute INDEX ON Something TAG Something, this is not supported. Anyone has found an approach to resolve the issue?

Michel,
OLEDB doesn't support neither DBC creation nor index. My not so smart solution was to keep copies of data with no records in it. They serve as a template with indexes and I copy them to a new folder, append data from working copy and replace files.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform