Dear All,
Greetings!
I have a database block with some non-db items on it. I use EXECUTE_QUERY to populate the db items and in post-query trigger of that block, I populate other non-db items with 'select .. into..' statement. There is COMMIT_FORM on a button on the form. After I populate the data, even if I don't change any single field on the form (db/non-db items), and hit the save button I am getting 'frm-40400: Transaction complete : 9 records applied and saved'. I am not understanding which records are getting inserted/updated. How can I know? The block status value is 'CHANGED' obviously because I am populated non-db items using some select statement. Is that the reason? Please assist.
Thanks,
RC