| Creating Alert in a Form [message #293895] |
Tue, 15 January 2008 08:59  |
sudheer.vsk
Messages: 5
Registered: December 2007
Location: BOTSWANA
|
Junior Member |
|
|
Hi All,
I created two forms in oracle 10g.
I'm calling a child form from master form,then I',m inserting one record in the master form and it is successfully stored in database.While going into another record I want to display an alert stating the below Message.
'PLEASE SAVE THE CHANGES BEFORE GOING TO NEXT RECORD'.
How can I display this message?In which Trigger I need to write the above message? At what level I need to mention this Alert(form or block etc).
Thanks&Regards,
sudheer.
|
|
|
|
| Re: Creating Alert in a Form [message #293963 is a reply to message #293895] |
Tue, 15 January 2008 15:14  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
If saving a record is obligatory, why wouldn't you do that automatically? One way to do that might be a block-level WHEN-NEW-RECORD-INSTANCE trigger with a COMMIT; statement.
Of course, you might improve this solution like checking whether something changed and save these changes, or save unconditionally (with possible change of system message level) etc.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
