General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks for the clarifications Christof.
>>1) INDEX ON MyField TO IDXFile doesn't need exclusive use
>
>But it will only work when the table is not opened with buffering in any datasession of the current VFP instance.
>
>>2) SELECT * FROM MyTable INTO CURSOR curTemp
>>INDEX ON MyField TAG MyField (VFP will delete the index at the same time the cursor is closed)
>
>Add a NOFILTER to the SELECT statement. Otherwise you likely end up with the original table used again by VFP and the INDEX command fails.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only