Sometimes VFP will cheat and just put a filter on your table that matches your WHERE clause and repackage this as a cursor by the name you specified. What NOFILTER does is force VFP to select the matching records into a real cursor. So, for your error, VFP considered the filtered table-cursor a repackaged cursor. I would actually call it a table repackaged as a cursor.
>I put the NOFILTER on the end of the SQL that creates the crsAcctContDeleted cursor and it works. Thanks! But, why did it work?
>
>>What if you added NOFILTER to the end of the SELECT command? Is SAS70_Missing_Deleted_Transfers a table or a cursor? If a cursor, how was it created?
Mark McCasland
Midlothian, TX USA