>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.

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