>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?
First of all Sergey is RIGHT. If it is a purely technical question on vfp, you can add an flag column on cast(deleted() as I), increase the 1's for those to be recalled in your gui or in a browse, create scan the view recalling each record in the base table directly or via SP or other means. Again, if you use views as a path to easily upgrade to C/S, rethink your model as Sergey hinted.
HTH
thomas
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only