Search found 4 matches
- 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...
- 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...
- 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 ...
- 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 ...