This content has been marked as final. Show 4 replies
You can use Alert property in oracle forms..
Check the syntax in forms builder HELP menu (F1 key) and search
Here is some example code from help menu..
Also look up "Show alert built-in"
-- Declare a NUMBER variable for the -- constant returned by the Show_Alert function DECLARE alert_button NUMBER; BEGIN IF :item.price IS NOT NULL THEN -- call the user-named calculation subprogram calculate_totals; ELSE -- display the alert alert_button := Show_Alert('no_price_alert'); IF alert_button = ALERT_BUTTON1 THEN -- invoke the price List window Go_Block('product_prices'); END IF; -- do nothing if operator selects button 2 END IF; END