Hi,

I have a table that has a identifier field starting at 1.

When an attempted write to the table fails the identifier column still
counts up even though there is no associated column. So i end up with
something like this
id--f1--f2
1---a---b
2---b---c
3---d---e
7---i---j

say i have done a hundred failed writes to the table the next id will be
107, is there a way to make the next id to be 8.
the only way that I can get the id to refresh is by doing a truncate table
but this deletes the content of the table.

thanks in advance

Silk