Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Index
Message
From
06/04/2001 16:14:35
 
 
To
06/04/2001 15:10:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00492553
Message ID:
00493045
Views:
23
Pamela:

> I set the filter to deleted() and search for the current entered record. If the record exist and has been marked for delete, I issue a RECALL for that record. For some reason this code is not being executed and it is attempting to do the default add and therefore, gets the uniqueness error.

Temporarily change the Deleted setting to off.
Attempt to locate a record having the same pk.
If found and deleted, recall it.
Restore the deleted setting.

It's a good idea to use the debugger to trace what is happening because you will want to examine the settings if deleted records are not found.

There is no nothing wrong about recalling deleted records, especially if the PK value means something and a deletion more or less indicates that the record is no longer used for data entry in the system (similar to an Active flag).

Daniel
Previous
Reply
Map
View

Click here to load this message in the networking platform