Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

making non database item editable

622131Aug 26 2008 — edited Aug 26 2008
Hello experts
Could you please tell me how can i enter a value in the non database item field.After executing a query
when i want to enter another query then i am not able to enter the the value in the non database text field.
can you please tell that how can i enter value in the non database item for enquiry.

Regards
Anutosh

Comments

Frank Kulash

Hi, @kannan-sekar
Is this thread a duplicate of: Unique Index not allowing to insert rows into table.. — oracle-tech
If so, one of them should be closed right away. It's confusing (and counter-productive) to have multiple threads for the same question. (This may not be your fault; the site can behave strangely.)

Frank Kulash

Hi,
I am unable to replicate the issue here, instead i explained in words below.
That makes it hard (perhaps impossible) to solve the problem. What problem do you have in producing a test case that the people who want to help you can replicate?
Step1: Creating table with primary key on col1
CREATE TABLE T1(PKEY NUMBER(10) PRIMARY KEY, ACCT_NO NUMBER(10), ACCT_KEY NUMBER(10), ACCT_STATUS NUMBER(1), ACCT_GRP_STATUS NUMBER(1));
The table created above doesn't have a column called col1. If you have a problem with some table that has a column called col1, post the CREATE TABLE and INSERT statements for that table.
Step2: Creating unique index on using CASE statement
CREATE UNIQUE INDEX IDX_T1_ACCT_KEY ON T1 ( CASE WHEN ACCT_STATUS = 1 AND ACCT_GRP_STATUS = -1 THEN ACCT_KEY ELSE NULL END);
Explain the requirement that the index is supposed to meet. For example, "I need to make sure that among all the rows with the same acct_key value, no more than one of them has acc_status=1 and acct_grp_status=-1."
By the way, that index uses a CASE expression, not a CASE statement. A CASE statement is something different. You'll get better answers faster if you say what you mean.
Below kind of row value is not inserted in my real world (getting unique index error).
Are you sure the index you posted is causing the error? Post the exact, complete error message you get.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 23 2008
Added on Aug 26 2008
1 comment
164 views