Solved

Forms and text-boxes

Posted on 2001-06-05
3
1,473 Views
Last Modified: 2006-11-17
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
0
Comment
Question by:asim_shankar
  • 2
3 Comments
 
LVL 2

Expert Comment

by:ddandekar
ID: 6155651
In case status has limited values U could use decode option in query.
0
 
LVL 48

Accepted Solution

by:
schwertner earned 50 total points
ID: 6155665
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
 
LVL 48

Expert Comment

by:schwertner
ID: 6155945
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

831 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