Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL ignores deleted()?
Message
From
01/09/2006 13:21:24
 
 
To
01/09/2006 07:28:06
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01150323
Message ID:
01150407
Views:
34
I support Jim's suggestion.

I feel that deleted records should never be used in any processing, i.e. DELETED should be set to ON in the main program and should not be changed anywhere in the program. (One has to be careful in Private datasession as the default for DELETED is OFF). If it is required to use the deleted records, those may be RECALLed, but not processed with SET DELETED OFF.

Another settings that may casuse problem is SET EXACT. I have seen that changing this settings in program may cause unexpected results. My preferred setting for both EXACT and DELETED is ON.
- Ravi Taxali
Visual FoxPro Made Simple An excellent book for beginners as well as experienced programmers
Never Forget Again. Setup Email Reminders.
Previous
Reply
Map
View

Click here to load this message in the networking platform