Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor's (temporary) index -- removal question
Message
From
08/04/2002 17:49:05
Spencer Redfield
Managed Healthcare Northwest, Inc.
Portland, Oregon, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Cursor's (temporary) index -- removal question
Miscellaneous
Thread ID:
00642400
Message ID:
00642400
Views:
46
I hope I am overlooking the obvious (VFP 7).

A form method processes records for a parameter passed cursor. Inside the method I need to temporarily create a .CDX on the cursor that may already have an existing or indexes. So far so good.

At the end of my method I would really like to just remove this one temporary .CDX but not disturb any of the cursor's index file or files that were originally there.

Question: Given that this is a cursor, is there a better way to selectively close a particular cursor's index file yet retain the original indexes than:

1) Save the value of SET( "PATH" ) and/or ATAGINFO()
2) Close indexes with SET INDEX TO
3) Recreate the original cursor indexes.

I'd appreciate any better ideas. Thank you!

Spencer Redfield
Next
Reply
Map
View

Click here to load this message in the networking platform