Hello,
Restarting an auto increment value is done using SQL. The method you used for HSQL is awkward at best. Here is the SQL for Firebird:
alter table TABLE_NAM alter FIELD_NAME restart with NNNN;
where NNNN is the last valid number.
Run this from the menu Tools->SQL
main screen of the .odb