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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement