IsCursor() wanted

[Walid]

Does any one knows a reliable way to tell if the alias that is open now (in a free tables environment no database objects at all) is a Cursor?
I did my homework before asking the question. DBF() doesn’t work, it doesn’t return a .tmp extension unless the cursor is read write, but not every cursor is read write!



Walid Magd
Engwam@Hotmail.com

 

[MarciaAkins]

Hi Wallid.

>> it doesn’t return a .tmp extension unless the cursor is read write <<

Actually, you are mistaken here. DBF() returns a .tmp extension when it has a disk presence (regardless of whether or not it is ReadWrite).

If the query is from from a single table and is fully optimizable, VFP takes a short cut and creates a filtered view of the dbf (in which case DBF() has an extension of .dbf

If you must ensure that you know the file is a temporary cursor, just use the keyword NOFILTER in all of your queries to force a disk presence.

Marcia G. Akins

http://www.TightlineComputers.com