>Pretty much the only times I would use a table instead of a cursor is if:
>
>1) You need to keep the results of this query after the program closes (or datasession is closed)
>
>or
>
>2) Since "Select [fields] from [tables] into cursor [cursorName]" most often results in a read only set of records, I would use "into table [tableName]" instead if I intend to modify the data in any way post-select.
>
You just need to add at the end a READWRITE statement of your select and its already a writeable cursor..
sample: select [fields] from [tables] into cursor [cursorName] readwriteNote: no readwrite support from VFP6 and earlier versions, not so sure with vfp6 with SP4...
>In my experience, I'm just using cursors a VERY high percentage of the time rather than temporary tables.