Creating an auto incrementing column in Firebird
or in any database that supports triggers and generators (aka sequences)
The answer is well known however the question comes out quite often, be it in an Oracle, Firebird or PostgreSQL forum
or in any database that supports triggers and generators (aka sequences)
The answer is well known however the question comes out quite often, be it in an Oracle, Firebird or PostgreSQL forum
SEFIP is an application used by almost 1.5 millions of companies in Brazil to collect/pay social welfare tributes. It is distributed by Caixa Econômica Federal (a federal bank), and in its latest version (8.3) it replaced InterBase 6.0 with Firebird. With this change, Firebird embedded installed servers base in Brazil grow in some millions.
You can find the announcement here (in portuguese – self extract exe containing a PDF file).
Can I (Dean Harding)make a simple suggestion:
Do not use Firebird in Embedded mode in a website