Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RECALL and parameterized view
Message
From
12/08/2009 08:21:12
 
 
To
12/08/2009 07:20:09
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01417479
Message ID:
01417493
Views:
66
>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
Map
View

Click here to load this message in the networking platform