Execute button

Posted on 2011-04-21
Last Modified: 2012-05-11
I use execute button for one of my forms and I use
when  button pressed trigger
If:system.Mode = 'Normal' then
End if;
but when I first open the form and  pressed the button it execute the query immediately. I don't know why.
Question by:poznan
    LVL 51

    Accepted Solution

    it means :system.Mode is abnormal :)
    LVL 51

    Expert Comment

    kidding, did you check the value of :system.Mode before this command? what does it show?

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now