Auto-increment field


How can I set an auto-increment field in Base to start with 1 and not zero?



Please include basic information when posting. Database type can be critical. Here is for HSQLDB embedded to reset to any value an auto-increment field:

alter table TABLE_NAME alter FIELD_NAME restart with 1;

Run this from menu Tools->SQL on an empty table.

How can I do this with a brand new HSQLDB embedded database where I want to add an ID field?
Do I have to run this SQL before I start?

Has nothing to do with a new database This has to do with each individual table. Once a table is defined then simply run this SQL (with your field & table names).

Also as eluded to, this is used to set the next increment number to any starting point. For example if numbers are to start at ‘300’.