Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select Statement appears to be filtering
Message
From
02/07/2006 14:25:56
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01132775
Message ID:
01133332
Views:
24
>>>>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!
Previous
Reply
Map
View

Click here to load this message in the networking platform