FRM-40401
From: Pat Doran <stcpjd_at_micro.lucent.com>
Date: 1997/07/31
Message-ID: <01bc9dd2$1250a7e0$8b7a13c0_at_stcpd-pc.micro.lucent.com>#1/1
Date: 1997/07/31
Message-ID: <01bc9dd2$1250a7e0$8b7a13c0_at_stcpd-pc.micro.lucent.com>#1/1
I have a problem,
I have a form which is based on a view that I DO NOT want to modify. I would like to have the user be able to navigate throughout this view via the form and apply updates (via a button that executes some PL/SQL) to a different table based on what they currently have in the form. Whenever I attach a trigger to the update button 1 of 2 things happens.
- If I include a commit at the end of the update statement in the PL/SQL the update occurs but I get the error message FRM-40401 No changes to apply, even though the update happens!!! How get I stop this message? I do not want to update the form or it base view, I only want to execute the PL/SQL attached with the button trigger...it appears that the commit in PL/SQL is being interpreted as a Forms do_key(commit_form)
- If I do not include a commit or a do_key(commit_form) then the changes are rolled back once I exit the form. But I don't get an error message....
Any help would be greatly appreciated, this is driving me nuts pdoran_at_lucent.com Received on Thu Jul 31 1997 - 00:00:00 CEST