How to use TZSequence with firebird 3.0
Posted: 31.05.2021, 10:44
Good day! I have a problem trying to make refresh request with TZQuery and TUpdateSQL. I tried different variants but still getting errors (see attachment).
What I have done:
For simple table DEPS (DEP_ID - primary key (autoinc - generator + trigger), NAME varchar, DESCR varchar) generated requests for update sql.
RefreshSQL - select DEP_ID, NAME, DESCR from DEPS where DEP_ID = :OLD_DEP_ID
Connected TZSequence, sequence = GEN_DEP_ID
TZQuery.SequenceField = DEP_ID
DEP_ID.AutogenerateValue = arAutoInc.
What I'm doing wrong?
And other question. Is any way to use ZeosLib with primary key identity style, with no generator name.
What I have done:
For simple table DEPS (DEP_ID - primary key (autoinc - generator + trigger), NAME varchar, DESCR varchar) generated requests for update sql.
RefreshSQL - select DEP_ID, NAME, DESCR from DEPS where DEP_ID = :OLD_DEP_ID
Connected TZSequence, sequence = GEN_DEP_ID
TZQuery.SequenceField = DEP_ID
DEP_ID.AutogenerateValue = arAutoInc.
What I'm doing wrong?
And other question. Is any way to use ZeosLib with primary key identity style, with no generator name.