>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 deleted 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
>
If deleted records are included in the result than SET DELETED is OFF at the time when query is run.
What's VFP version?
--sb--