Hi all :)
i think that i have problem in the phase of insertion ...
that's my code :
i := show_alert('VALID');
But,when i want to update record ,i encounter this error:
frm-40508 impossible to insert record
Violation unique constraint
Any solutions ?
Edited by: 979155 on 4 janv. 2013 19:45
I THink you are having wrong understanding of oracle form concept
When you press SAVE button automatically forms will commit all pending transactions... so why do you need to invoke 'when button pressed' for doing the same work ?
I know there are two modes in oracle:
automatic and manual; for manual I mastery but the alternative ideas I just on consultation (using execute_query) but for the update I have not ideas ...
for the button, it is that there must be a trigger (when-button-pressed)? If yes, what it will contain code in pl / sql?
You didn't solve the problem, you simply bypassed it. But be aware that standard.commit will NOT save ANY oustanding changes in your forms-blocks, it will only commit things which you inserted, updated or deleted by your own DML-statements.