Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting Records
Message
From
27/08/2002 13:10:54
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Deleting Records
Miscellaneous
Thread ID:
00694122
Message ID:
00694122
Views:
46
What happens if I try to delete many records and the database engine discovers, while deleting, that a record is locked by a user? For example, a table contains many thousands of records and 1000 of them meet a certain condition. I want to delete those records so I issue the command DELETE FOR that condition. After having deleted 800 of those 1000 records, the database engine encounters a record that is locked by a user. Does it automatically RECALL the 800 deleted records or do they remain deleted even though the command could not be completed successfully?
James McIlwrath
Datasmith Ltd.
250 Webb Drive, Suite 1206
Mississauga, ON L5B 3Z4
Canada
Phone:(905) 566-0766
Fax:(905) 566-4547
E-mail: jmci@rogers.com
Next
Reply
Map
View

Click here to load this message in the networking platform