>>Now that I know what a cursor is ..... what are the tricks you were talking about? :) I would really love to know about them.
>>
>>Richard.
>
>Ok.. Cursor Tricks...
>
>If you do a simple select statement
>
>Select * from table into cursor fred
>
>The created cursor may not really exist, VFP will just give you the same table again (filtered if you use a where clause) in a different work area.
>You can use the NoFilter clause of the select statement to stop this.
>But even after a Nofilter, the cursor might not exist on disk
>
>You can check for this by looking at DBF() if there is a '.DBF' in the filename returned then the cursor has a presence on disk, it it's '.TMP' then it's in memory.

Actualy if there is a '.DBF' in dbf() than you have the original filtered table as a cursor. The cursor always has extension '.TMP'. You can use FILE(DBF()) to verify that it's not in a memory.

>
>You can also Use DBF() again in 0 Alias NewCursorName
>to re-open the cursor in read-write mode (But I think you need to to the
>above check first)
>
>VFP7 apparently has a clause added to SQL Select where you can create a writable cursor automatically (I Forget the name).
>
>HTH
>
>Will