Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Pamela,
Sorry for the delay,
>Thanks for the information. I am trying to make it work. When the user clicks the save button, 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. What do I need to do. This is new to me.
A recall, is just the same as an insert: The insert trigger is called, and it checks if the primary key already exists. I think that the record you're attempting to recall has a primary key value that already exists in that table.
Walter,
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only