Search code examples
oracleoracle10goracleforms

Oracle Forms Shortest Way of Display Custom Text on Item depends on Database Value of It


My data block item's values 1 or 0 on database. I want to display "yes" or "no" on my text item depends on its value. (If it is 1 show "yes", else (0) show "No" ) What is the shortest way of this in Oracle Forms?


Solution

  • It is easier to make a checkbox or listbox with the values 0 = No and 1 = Yes Then if you switch the value your correct value is automatically saved.