Home » Developer & Programmer » Forms » Issue while assigning summary calculated item to db item when-remove-record
Issue while assigning summary calculated item to db item when-remove-record [message #680640] Thu, 28 May 2020 01:16
venkatesh27gavini
Messages: 1
Registered: May 2020
Junior Member
We have Master and Detail Blocks

We are assigning summarized control item in the detail block to a database item in the Master block. Whe are assigning this
when validating detail block reocrd. The Master block item is getting changed when we insert/update in the detail block.

The issue is, master block item is not getting updated when i delete record in detail block. Then i used when-remove-record trigger
in the detail block, but this is also not assigning data.

below is the block of code pertaining to when-remove-record

begin

:pms_contracts_all.net_price := :pms_billing_types_all.total_net_amount;
:pms_contracts_all.tax_amount := :pms_billing_types_all.total_tax_amount;
:pms_contracts_all.total_amount := :pms_billing_types_all.total_tot_amount;

end;
Previous Topic: Saving an IMAGE of BLOB type from Oracle forms to the database
Next Topic: LOGON function
Goto Forum:
  


Current Time: Thu Jul 09 23:25:20 CDT 2020