Index on Cursor

[Auguy]

I know I've read this somewhere before, but I can't seem to find it now. If I create a cursor with

Select...Into Cursor tmpUser NoFilter ReadWrite

and then index the cursor

Index On UserCode Tag UserCode

Does this create an actual file somwhere? Secondly, does the index file automatically get deleted when the cursor is released?

Auguy
Northwest Ohio

 

[mkrausnick]

Yes and yes. The file is created in your Windows temp folder with a system-generated name ending in '.TMP'. The CDX file has the same name with a '.CDX' extension. When you close the cursor, both files are deleted.

Mike Krausnick
Dublin, California

 

[Auguy]

Thanks Mike

Auguy
Northwest Ohio