The autoinc value gets incremented every time a record is inserted. It's never rolled back. You'll have to implement your own key generator if you want it to follow some other rules.
>
>This one might be simple, but I still have no clue.
>
>I have a table with a primary key field designed to be type integer(autoinc). My problem is that when a new record is appended, the autoinc also takes records marked for deletion into consideration and autoincrements those values also. I would like them to only include non-deleted records.
--sb--