SELECT iid, ; fk_product, ; avail_day, ; editdatetime ; FROM specials ; WHERE editdatetime > THIS.dLastUpdate ; INTO CURSOR v_specialsThis includes the deleted records but seems to clear the deleted flag. Is there some keyword I'm missing? Is this even possible?
SELECT iid, ; fk_product, ; avail_day, ; editdatetime, ; DELETED() AS IsDeleted ; FROM specials ; WHERE editdatetime > THIS.dLastUpdate ; INTO CURSOR v_specialsBut for my own curiosity I'm still wondering if I can do it more directly.