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
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.