Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Migrar VFP a MySQL
Message
From
19/03/2008 07:53:11
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01303120
Message ID:
01303274
Views:
12
>Good Afternoon
>
>How we can create index in a cursors of database MySQL into VFP because find records with LOCATE is very slow that use SEEK.
>
>Tank You

Hi Carlos,

If you have already got the data from MySQL and out it in a VFP cursor, then as Naomi says, just use the INDEX ON statement to create the index. You can do this on any cursor, provided the cursor is not in Table Buffered mode and the cursor is created READWRITE (which if you've used SPT it will be).

Hope that helps.
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform