Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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 number to restart with.

Run this from the menu Tools->SQL main screen of the .odb

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 number to restart with.last valid number.

Run this from the menu Tools->SQL main screen of the .odb