Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Turns Deleted() Off
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00750048
Message ID:
00750338
Views:
20
Hi Yuri,

>set dele off
>1. select * from ... into cursor tmpcurs &&it must be the 'regular' cursor, >then it shows the deleted records as deleted.
>2. select * from ... into cursor tmpcurs NOFILT &&it will show all records >WITHOUt deleted mark. The same is with select .. into table.


Yes, it seems to me that "Create View" assumes the Nofilter behavior by default.

Ill probably just create a logical delete flag field in my table to get the result I want.


Todd
The day you take complete responsibly for yourself, the day you stop making any excuses, thats the day you start to the top. - O.J. Simpson

Great advice from a questionable source...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform