General information
Category:
Coding, syntax & commands
>...I have two composite fields as my one PUBLIC KEY, so if I delete
>a record, I want it to be reusable straight away in case a user wants to add
>a new record, but this cannot be accomplished if the deleted record
>is not permanenly removed from the table in question.
Mick,
Primary keys should be generated automatically by the system and be used only to relate tables together. They shouldn't be re-used and shouldn't be entered by the user. Some apps never even show the PKs to the users.
What kind of data ins in the two field and why would anyone want to reuse the key straight away?
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