Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 437 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Oracle form Check the box if met certain condition.

Is there any function that will check/tick a checkbox once a condition is met because I only found the CHECKBOX_CHECKED() function that return boolean.
What I want is something like IF corraddrno = addrno THEN ('set checkbox as checked').
I am very new to oracle so I am not sure which function that are available to be use.
Thank you in advance.
Best Answer
-
Check the Forms Builder Help entry "About Checkbox Values":
Checkboxes store CHAR, NUMBER, or DATE values. The value of a checkbox can be set by a fetch from a corresponding database column, by end user input via item manipulation, or through initial value or runtime assignment. Similarly, the value of a checkbox can be committed to the database through standard commit processing. When you define a checkbox, you specify what value you want the checkbox to represent as checked and what value you want it to represent as unchecked. For instance, consider a checkbox that indicates whether or not a customer has been approved for credit. When you define the checkbox, you could specify the Value when Checked to be 'CREDIT_OK' and the Value when Unchecked to be 'NO_CREDIT'. When a customer record is fetched, the checkbox stores the value retrieved from its corresponding database column. If the fetched value is 'NO_CREDIT,' the checkbox is displayed in the unchecked state (off). If the end user activates the checkbox to toggle it to the checked state (on), the checkbox value changes to the checked value, 'CREDIT_OK.'
So assign the value you have defined as "Value when Checked" to the item.
Answers
-
Check the Forms Builder Help entry "About Checkbox Values":
Checkboxes store CHAR, NUMBER, or DATE values. The value of a checkbox can be set by a fetch from a corresponding database column, by end user input via item manipulation, or through initial value or runtime assignment. Similarly, the value of a checkbox can be committed to the database through standard commit processing. When you define a checkbox, you specify what value you want the checkbox to represent as checked and what value you want it to represent as unchecked. For instance, consider a checkbox that indicates whether or not a customer has been approved for credit. When you define the checkbox, you could specify the Value when Checked to be 'CREDIT_OK' and the Value when Unchecked to be 'NO_CREDIT'. When a customer record is fetched, the checkbox stores the value retrieved from its corresponding database column. If the fetched value is 'NO_CREDIT,' the checkbox is displayed in the unchecked state (off). If the end user activates the checkbox to toggle it to the checked state (on), the checkbox value changes to the checked value, 'CREDIT_OK.'
So assign the value you have defined as "Value when Checked" to the item.