Forms and text-boxes

I've created a form based on a table UserInfo.
One of the fields is a CHAR(1) column storing the status of the user.

On the form I want to display the meaning of that single-character as well. What I tried was to create a trigger for WHEN-NEW-RECORD-INSTANCE as follows :-

BEGIN
  if (GET_ITEM_PROPERTY('STATUS',DATABASE_VALUE)='1')
      <write into the text-box TXT_STATUS>
  endif;
END;

As you can see I can't figure out the code for writing into the TXT_STATUS box.

I could use SET_ITEM_PROPERTY but can't seem to figure out which property to set!

Pls. help.

Thanks,

-- Asim
asim_shankarAsked:
Who is Participating?
 
schwertnerConnect With a Mentor Commented:
Use the PL/SQL statement:

IF :block_name.column_name = '1'
THEN :block_name.TXT_STATUS := 'Desired Value'
END IF;

The only prerequest is to deliver the value into :block_name.column_name  using default select statement or other select statement and to define the appropriate lenght and data type for the control item :block_name.TXT_STATUS
0
 
ddandekarCommented:
In case status has limited values U could use decode option in query.
0
 
schwertnerCommented:
IF :block_name.column_name = '1'
THEN :block_name.TXT_STATUS := 'Desired Value';
ELSIF :block_name.column_name = '2' THEN :block_name.TXT_STATUS := 'Desired Value_1';
ELSIF :block_name.column_name = '3' THEN :block_name.TXT_STATUS := 'Desired Value_3';
END IF;

Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.