RefreshSQL in detail table

The forum for ZeosLib 7.2 Report problems. Ask for help, post proposals for the new version and Zeoslib 7.2 features here. This is a forum that will be edited once the 7.2.x version goes into RC/stable!!

My personal intention for 7.2 is to speed up the internals as optimal a possible for all IDE's. Hope you can help?! Have fun with testing 7.2
Post Reply
docent83
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 31.05.2021, 10:26

RefreshSQL in detail table

Post by docent83 »

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 ZSequences connected to generators and ZQueries.

sql looks like for master:
select master_id, field1, field2 from master
refresh sql: select master_id, field1, field2 from master where master_id = :old_master_id (it works)

for detail:
select detail_id, master_id, field3, field4 from detail where master_id = :master_id (it works)
refresh sql: select detail_id, master_id, field3, field4 from detail where detail_id = :old_detail_id (fail)


Somebody, please give me some example.
Post Reply