General information
Category:
Coding, syntax & commands
>I've noticed that although a record has been deleted,
>when you enter the item again, Foxpro still complains
>that the item already exists when item is primarily key.
>
>I was wondering if there is a way to allow the
>re-entry of a primary key item that has deleted.
Yes, you can: filter your primary key index on NOT DELETED(), and deleted records won't bother you. However, this has a drawback; since filtered indices won't be used by Rushmore, you will need to add a regular index on the same expression, so your queries can be optimised.
HTH!
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