Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select picking up a deleted record
Message
From
18/11/2004 09:42:47
Michael Vassallo
Efi, Inc.
Pittsburgh, Pennsylvania, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: SQL Select picking up a deleted record
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00962577
Message ID:
00962589
Views:
8
Sergey, I must be missing something here. From the Visual FoxPro Language Reference for SET DELETED:

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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform