Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

do you want to save the changes you have made?

user613563Jan 15 2009 — edited Jan 16 2009
i have a non-tabular single table form

i finish enter one record (from first to last field),
first field being primary key and i press down arrow key.
Form, without saving the first record moved to second record for entry.

I want the form to prompt me with the message
'do you want save changes you have made?' before it move on to the
2nd blank record for enrty.

i used WNRI at FORM level with the commit command enclosed within,
but they all saved silently
and moved to the next record for entry without prompting the SAVE msg.

IF :SYSTEM.RECORD_StatuS in ('NEW','INSERT') then
COMMIT_FORM;
end if;

IF :SYSTEM.RECORD_StatuS in ('NEW','INSERT') then
COMMIT;
end if;

IF :SYSTEM.RECORD_StatuS in ('NEW','INSERT') then
do_KEY('COMMIT_FORM');
end if;

one more question ;
are WNRI, KEY-NXTREC & KEY-DOWN trigger's purpose same?

ty.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 13 2009
Added on Jan 15 2009
13 comments
5,296 views