Sequences in Firebird 3

[Weetch_Russell (Russell Weetch)]

I have an Aurelius model that I am using with Firebird 3. Every object has an Id and is mapped

[Sequence('SEQ_GEN')]
[Id('FId', TIdGenerator.IdentityOrSequence)]

so they all use the same Sequence.

Should Aurelius create that sequence in FB? I'm sure it did when I had a first look last year, but this doesn't seem to happen now. Each new record gets a unique value (within the table) but not it seems from the sequence, even when I manually create it.

Any comments on this? Thanks

[wlandgraf (Wagner Landgraf)]

If you are using FIREBIRD3 dialect, identity is used by default. You should explicitly tell Aurelius you want to use sequences in FB3.

uses Aurelius.Sql.Register, Aurelius.Sql.Firebird3;
{...}
(TSQLGeneratorRegister.GetInstance.GetGenerator('Firebird3') as TFirebird3SQLGenerator).UseIdentity := False;

More info here: https://download.tmssoftware.com/business/aurelius/doc/web/configuring_sql_dialects.html