General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
You could change the key field of the record immediately before deleting
REPLACE keyfield WITH a_meaningless_value
DELETE
That way your deleted records won't show when you use keymatch()
>Hi
>
>Thanks for your reply
>
>I am having difficulty with duplicate records probably for the very reason that deleted records are not removed from the index.
>
>Does this mean that if I want to reuse a key tag that I have to :-
>
>1) look for the tag
>2) then check to see if it was deleted and
>3) if so then recall it and replace the details.
>
>Is there not a way to force removal of a deleted record without having exclusive rights???
>
>Regards
>Geoff Scott
Previous
Next
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