Re: Forms 4.5: Using 'commit;' in a trigger.

hi,

you should better create a block related to your table. initialize data in pre-insert trigger and call the built-in 'commit_form' within your when-button-pressed trigger.

Oracle ensures that this is the logical way of forms programming.

Renaud

Martyn Dissington a écrit dans le message <38CCFFF0.5BE2D07D_at_mail.burton-college.ac.uk>...
>
>I would like to use a when-button-pressed trigger to insert a line into
>a table. When the trigger is getting to the line 'Commit;' the user is
>shown the message 'FRM-40401: No changes to save.' as there have been no
>changes to the current block.
>
>But if i take out 'Commit;' the line that is inserted does not get
>saved. How do i saved this insert without doing a commit_form;
>
>thanks in advance,
>
>Martyn.
>
>--
>Could any replies be CC'd to
>< mdiss2bu_at_burton-college.ac.uk >
Received on Mon Mar 13 2000 - 18:24:39 CET