auto-increment field
Hi,
How can I set an auto-increment field in Base to start with 1 and not zero?
Thanks
First time here? Check out the FAQ!
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'.
Asked: 2020-06-06 17:05:07 +0100
Seen: 91 times
Last updated: Jun 06 '20
arabic language support [closed]
Any way to speed up database search? [closed]
Installation on Fedora 14 system fails. [closed]
converting perfect works data files [closed]
Where can I find sample databases for Base?
compatibility with microsoft access97 [closed]
Is there a tool to manage bibliography? [closed]
How do you set up input for many-to-many intersections in Base? [closed]