Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
NOFILTER on SELECT is implicit ?
Message
De
17/07/2003 12:05:06
 
 
À
17/07/2003 11:34:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00811089
Message ID:
00811126
Vues:
14
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
Fil
Voir

Click here to load this message in the networking platform