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
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