Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
***Logical Delete Record
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00022604
Message ID:
00022609
Views:
29
>I have a Table with a key index field specified as 'Primary' type.
>I have 'SET DELETE ON'. When a record was deleted with
>the DELETE command, I wanted to append the same key
>into the Table, but it says "Uniqueness violated". Why is that so?
>Any advise please.....

Alvin

Delete does NOT remove the record from the table -- only PACK will do that. Just because you cannot see the record does not mean it still does not exist. You will either have to pack the table first or change the key value so it is unique.

HTH,
Tom
Tom
--------------------------------
Tom O'Hare
407-299-4268 -- tom@redtile.com -- http://www.redtile.com/
Independent Programmer Using Visual FoxPro, Visual Basic & more...
Operations Manager -- Virtual FoxPro User Group (VFUG)
http://www.vfug.org/ -- tom@vfug.org
President -- Central Florida FoxPro User Group (CFFUG)
http://www.redtile.com/foxpro/
Universal Thread Most Valued Professional (MVP)
http://www.transformation.com/foxpro/
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform