>
> Who did one auto-increment that insert record with deleted key ?
>
> Like:
>
> Key auto-increment
>
> 1
> 2
> 4
> 5
> 6
> 7
> 8
>
> The next insert use the record 3.

If it only was that easy :-)

http://www.ibobjects.com/TechInfo.html#ti_AuditableSeries

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com