Not by VFP's internal. There is no equivalent of RECALL in SQL (View operation USE; REQUERY, TABLEUPDATE, ... is all SQL while RECALL is xBase)
but it should be posible to retrive the deleted records via
SELECT *, DELETED() AS lDel from SourceTable YourTable where ...
Then you can SCAN the View / Cursor and use
SCAN FOR lDel
...
RECALL FOR ... in SourceTable
ENDSCAN
You might also consider the use of SET RELATION here.
Agnes
>Hi,
>
>I have a cursor which is a parameterized view that conditionally loads a set of records from its underlying table while SET DELETED is OFF.
>
>I notice that if I SCAN throught the cursor, DELETED() function always returns .F. for all the loaded records even if some of them are actually deleted records in the underlying source table.
>
>How can I, or it is possible for me to load and RECALL deleted records of source table with a parameterized view?
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]