Zeoslib Portal

I have changed as you write:
"if (new.id is null) then new.id = next value for gen_bookids;"
for secure, but I need no ZSequence in my program.

I will check to work with SEQUENCE from Firebird using
ZUpdateSQL. After the answers I have some idea
it could work with them.

With trigger inserted from me there is Zeos very good working. You can download my tutorial and see the index tab "Edit Table". Works fine with Firebird 4 and I have tested also with Firebird 3. For the Tutorial you must du nothing, because it comes with embedded Firebird 4. The SQL for cr...

All ok now. Thank you, Jan.

Programmed with: Lazarus 2.0.4, Zeos 7.3, Firebird 4 Beta 1 If I use the following SQL commands to create the tables ADDRESS and CONTACT with FOREIGN KEY and then create the data, this is executed without any problems with firebird 4: CREATE TABLE ADRESS ( /* --- IN FIREBIRD 3 und 4 should go ------...