Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBF -> SQL, CursorAdapters, and indexes.
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
DBF -> SQL, CursorAdapters, and indexes.
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01133683
Message ID:
01133683
Views:
69
Hey all,

I recently began experimentation of using SQL Server as a back-end instead of DBFs. I am familliar with upsizing and the basic use of the CursorAdapter. I am comfortable generating simple, updatable data-sets as wel. What has me in a ringer is that I need to use these tables' existing indexes. Would someone please give me a general run-down on the best-practice of migrating indexes to SQL from a DBF, and their use in a CursorAdapter generated cursor?

Thank you,
-John
John MR Fitzgerald
Order Inc.
Next
Reply
Map
View

Click here to load this message in the networking platform