Sequences in Firebird 3

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

[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

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:

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.