>cuatmmast is a cursor exctracted from at SQL Server table and a_stores is a native VFP table.
>Having a blank storecode in curatmmast is a normal event. There are some records in a_stores with blank storecodes,
>but they are marked for deletion.
>The program begins with SET DELETED ON,, but this command finds the deleted records in a_stores.
>What should I be doing here to be sure that delted records in a_stores are ignored?
>
>
>SELECT curatmmast1->*,a_stores->store_name AS name,f_address AS street1, ;
>f_city AS city ;
>FROM curatmmast1 LEFT JOIN a_stores ON curatmmast1->storecode = a_stores->storecode ;
>INTO CURSOR curatmmast READWRITE
>
Bill,
SET DELETED ON setting ignores deleted records in VFP tables. Could it be that you use the form with private DS and you don't have SET DELETED ON set there?
The records deleted in SQL Server are physically gone from the tables unless you maintain your own deleted flag in these tables and mark them as deleted using this flag (don't use DELETE command in SQL Server).
If it's not broken, fix it until it is.
My Blog