Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
NOFILTER on SELECT is implicit ?
Message
From
17/07/2003 12:05:06
 
 
To
17/07/2003 11:34:11
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00811089
Message ID:
00811126
Views:
13
Thanks Jim,

SET DELETED ON implies NOFILTER on SELECT ?

but where is document this ?

ok, now i can to infer this by help Note on SET DELETED command:

>Note Calling SQL SELECT with SET DELETED OFF includes records fitting the specified criteria in the result set and sets those records as available for processing. That is, SET DELETED OFF is not set for the records in the result set.

with SET DELETED ON active, SELECT skip DELETED() record,
but can't uses one filtered cursor because if code SET DELETED OFF on a next
command, these record they will appear.

My comment:
this VFP SELECT trick it can be much dangerous one if an operator changes SET DELETED.

Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform