General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Unless you create your primary key with FOR NOT Deleted(), you cannot enter a duplicate primary key even if the other one is deleted.
If you go with the FOR NOT Deleted() condition, dont forget to add a second regular index in the field that Rushmore could use (Rushmore will not use a filtered index). Dont forget to plan a recovery method in the case that a deleted record is recalled and a duplicate exist.
HTH
>Is it really like this?
>If I have a record with the ident (which is a unique index) = 1000, I deleted it, I cannot put 1000 anymore?
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