Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select picking up a deleted record
Message
From
18/11/2004 10:05:29
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:
00962600
Views:
8
Sergey, with SET DELETED ON, I created a cursor and set the buffering to 5. I inserted two records into the cursor, then deleted one. With SET DELETED ON, is performed a SELECT * on that cursor, and the result set included both the deleted and non-deleted record.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform