Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select Statement appears to be filtering
Message
De
02/07/2006 14:25:56
Mike Yearwood
Toronto, Ontario, Canada
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01132775
Message ID:
01133332
Vues:
25
>>>>However, I'm of the opinion that an ounce of prevention is really worth pounds of cure. If I'm pulling a cursor that is not going to be updated I will not add rewrite. select * from table nofilter gives me a readonly cursor. select * from table nofilter readwrite gives me a non-readonly cursor.
>>>>
>>>>If I should happen to issue a replace command against the readonly cursor, I've saved my sanity because the data could not affected.
>>>
>>>The READWRITE is sufficien by itself (it includes NOFILTER).
select * from mytable readwrite
>>
>>No because it means all cursors will be readwrite, when only some need to be readwrite.
>
>Only cursors with READWRITE clause will be readwrite. The cursors with NOFILTER (w/o READWRITE ) will be read only.

Oh! I see what you meant. I don't need NOFILTER if I'm using READWRITE. Of course!
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform