Search found 4 matches

by docent83
04.08.2021, 22:36
Forum: ZeosLib 7.2 Forum
Topic: RefreshSQL in detail table
Replies: 0
Views: 725

RefreshSQL in detail table

I'm using master-detail mechanism, but I can't understand how to do refresh of one record in detail table. I'm getting error "refresh sql returned no results" when trying to insert to detail. Zeos: version 7.2. DB: firebird 2.5 I have master table and detail table with updatesqls. I have Z...
by docent83
02.06.2021, 21:31
Forum: ZeosLib 7.2 Forum
Topic: How to use TZSequence with firebird 3.0
Replies: 2
Views: 481

Re: How to use TZSequence with firebird 3.0

First of all, thanks for reply. Why do you use TZUpdateSQL with this simple table? It seems to be not necessary? I'm using data modifying from DBGrid, which is using refresh to reload data for edited record. All of this was my fault. I found an error - I made two equal databases, but one with genera...
by docent83
31.05.2021, 10:46
Forum: ZeosLib 7.2 Forum
Topic: How to use TZSequence with firebird 3.0
Replies: 2
Views: 481

How to use TZSequence with firebird 3.0

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 ...
by docent83
31.05.2021, 10:44
Forum: ZeosLib 7.2 Forum
Topic: How to use TZSequence with firebird 3.0
Replies: 1
Views: 296

How to use TZSequence with firebird 3.0

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 ...