General information
Category:
Coding, syntax & commands
Since the record that you have deleted still exists you are violating the uniquness. Either skip over to 12 or reuse the deleted record.
>When I delete a record from my table, I am not able to enter in a new one. I get a unique index violation error. I have SET DELETED ON. I know it is scoped to the current data session, but that doesn't mean too much to me. When I browse the table exclusivly I can see that record, but is there a way to enter in a record that would receive the same ID as the one I deleted? The last record in my table has an ID of 11. I delete it. The next record I add in would receive the ID of 11, since it is autoincremented. But it can't because that other one is still in the table, its marked for deletion.
>
>Thanks,
>
>Tyler
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