>>append from mycursor
>
>>For some reason when I attempt this I get and error...
>
>The reason is that append from ALWAYS looks for the table on the disk - in this case it looks for mycursor, which is NOT a table, but an alias. The name of the cursor table on the disk is dbf(mycursor), and you force the Select SQL to write a table to the disk with NOFILTER.
Hi Doru,
Thanks! So what's the advantage of writing to a cursor with NOFILTER rather than creating a table on disk? The maintenance? having VFP deal with the creation and removal of the cursor on disk? Since it writes to disk don't I loose the speed I was hoping to have using a cursor?
Jim Philippi
quando omni flunkus moritati