>>>>>Is there a way to create a temporary index on a permanent table (similar to a Cursor table)?
>>>>
>>>>do it the same way you'd do it to a cursor, except you'd want to use a different cdx name.
>>>
>>>Do you mean like,
>>>
>>>select mytable
>>>INDEX ON etc TAG etc OF temp.cdx
>>>
>>>This does create a "dissociated" index but it still is written to disk. Or is that what you meant?
>>
>>that's what i meant. i don't think you can have a memory only index w/ a regular table...
>
>I didn't think there was, but you never know. I guess I'll just continue creating "sneaky" indexes on users' C: drives, and then deleting when the app closes. I feel kind of intrusive doing it, though, and of course if the app aborts, the CDX doesn't get deleted. Oh well...worse things can happen.
Hi Bruce,
When you create a cdx tag on a cursor table created with create cursor -sql commands and the cdx is the same name as the cursor dbf foxpro will automatically delete the cdx file when the dbf is closed.
Or so says the manual.
Good luck!
Hugh