Hello,
I am a beginner with Oracle Forms. Please help me
My Scenario:
I have database block in the few items are loaded from Excel. Then, this data is inserted and saved into a table.
I have a check-boxes to select what I want and save only that data.
I have a "SAVE" and "EXIT" button on the menu bar.
I have a function to save data into database table returning a number, which becomes 1 when the save button is pressed. i.e., when the SAVE function is entered, X is assigned 1 and is returned.
=> when X = 1 => save button is pressed.
Requirements:
1. If I do not select the data using check-box and exit ( by pressing exit button ) , it should throw a message saying, you have not selected data and save using button on message bar
2. If I select using checkbox and exit without saving, promt me "Do you want to save changes?"
3. If i select data and save using menu bar and exit the form, just exit the form, without the prompt.
The third option is not at all working!
The first two requirements are hindered by errors like FRM 40400 and FRM 40508
I have put on-error function, still its not working. It is all messed up!
Please help!