SunQuest
           Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesOracle Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here!
  #1  
Old January 12th, 2005, 04:48 PM
Cernam_SVL_CA Cernam_SVL_CA is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Dec 2004
Posts: 5 Cernam_SVL_CA User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 40 m 4 sec
Reputation Power: 0
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.

Reply With Quote
  #2  
Old January 13th, 2005, 03:43 PM
czullo czullo is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jan 2005
Posts: 1 czullo User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 m 50 sec
Reputation Power: 0
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;

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesOracle Development > Forms question regarding Alerts


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway