Nico Speleers wrote:
> How can I reset an autoincrement field in firebird 3 ? I used
> identity to make an autoincrement field.
In your Fb 3 installation is the /doc/ directory, where you will find
the release notes in PDF form. IDENTITY is documented on page 69
(page 79 by the PDF numbering),
-support@yahoogroups.com
Subject: RE: [firebird-support] reset autoincrement field
I only use the property Identity to make an autoincrement field and I don't
make use of generators. Therefore 'How can I reset an autoincrement field in
firebird 3 ? I used identity to make an autoincrement
16 16:34
Aan: firebird-support@yahoogroups.com
Onderwerp: RE: [firebird-support] reset autoincrement field
To see current generator value
select gen_id(generator-name, 0) from rdb$database
To set generator value
set generator generator-name to value;
From: firebird-support@yahoogroups.com<mailto
How can I reset an autoincrement field in firebird 3 ? I used identity to make
an autoincrement field.
Thanks.
Nico Speleers
Analyst
Carfac bvba
Driving on experience
Rijksweg 53
9680 Maarkedal
Tel. +32 55 23 00 00
Fax +32 55 31 00 95
nico.spele...@carfac.com