IBtransaction and Firebird for a multi-user program

Question

I have a multiuser delphi program which has Firebird database behind it.

And I want 2 user can insert 2 records same time but with given automated number for a field.

On the other hand I am not sure Firebird is eligible for this without one use commit and close the table. And the other one refreshing it...

I heard bad things about commitretaining and I don't now what to do now. Like:

• Which transaction setting is best for me?
• Wait or No-wait if I have to use commitretaining how can I do that safely?

Answer 1

Use GENERATORS. With GENERATORS you get always unique numbers. It doesn't matter how many transactions are active, they live outside the transaction control.

See Firebird Generator Guide