Hi,
How can I set an auto-increment field in Base to start with 1 and not zero?
Thanks
Hello,
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’.