RefreshSQL in detail table
Posted: 04.08.2021, 22:36
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.
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.