|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
|
|||
|
|||
|
Forms question regarding Alerts
I have an alert that pops up asking the user for input. The buttons available are "Yes" and "No" but I can't figure out how to test for the answer. Actually...it's the syntax that I don't know about. I'm sure it's as easy as:
Code:
IF "yes" then something ELSE something else END IF But the problem is I know that will not work and I need to get the proper syntax. Any help is greatly appreciated. |
|
#2
|
|||
|
|||
|
To display the alert, issue the SHOW_ALERT built-in. SHOW_ALERT is a function that returns a numeric constant that corresponds to the button that the operator selected from the alert. If the operator selects...
Oracle Forms returns - Button 1 = ALERT_BUTTON1 Button 2 = ALERT_BUTTON2 Button 3 = ALERT_BUTTON3 Example ------- DECLARE alert_button NUMBER; BEGIN alert_button := SHOW_ALERT('the name of your alert'); IF alert_button = ALERT_BUTTON1 THEN -- Insert code associated with button 1. ELSIF alert_button = ALERT_BUTTON2 THEN -- Insert code associated with button 2. END IF; -- No code executes if operator selects button 3, the Cancel button. END; |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Forms question regarding Alerts |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|