Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select Statement appears to be filtering
Message
 
 
To
01/07/2006 13:58:18
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:
01133283
Views:
21
>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
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform