Continuing my previous post, i'm making some test and see that seems
that when delete a record, firebird 'mantains' memory of the last
inserted Primary Key and if
BEFORE DELETE i have
1
2
3
4

AND then delete record with ID 2
AFTER DELETE, when insert a new record automagically firebird
assign
ID number 5
1
3
4
5


In my case FB database created on old access database seems not have
memory (obviously) of the old Primary Key and so i receive the error
described when try to insert a new record.

Is it correct ?
What should be a solution for that ?

Thanks
Adriano