| No. of records displayed in list item is more than 1 [message #487492] |
Tue, 28 December 2010 04:14  |
 |
madhur05321
Messages: 7
Registered: December 2010
Location: Chandigarh
|
Junior Member |
|
|
hi..everybody.
this is my first blog m writing here.
Actually m working on oracle 10g forms.
I have a list item in which no. of records displayed is 10.
I am populating this list item through a recordgroup.
I want when user select a value from first record then he should not be able to select the same value in further record of that list item.
Kindly tell me.
Madhur
|
|
|
|
|
|
|
|
|
|
|
|
| Re: No. of records displayed in list item is more than 1 [message #487868 is a reply to message #487866] |
Mon, 03 January 2011 00:50  |
swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai
|
Senior Member |
|
|
Create global temporary table like this
create global temporary table CHK_DUP_REC
(
COLUMN1 VARCHAR2(40) not null,
COLUMN2 VARCHAR2(40) not null,
COLUMN3 VARCHAR2(40) not null,
COLUMN4 VARCHAR2(40) not null
)
on commit delete rows;
-- Create/Recreate primary, unique and foreign key constraints
alter table CHK_DUP_REC
add constraint PK_ALL_COLS primary key (COLUMN1,COLUMN2,COLUMN3,COLUMN4);
Write code field like this :
-------------------------------
begin
INSERT INTO fas.chk_dup_rec(column1, column2, column3, column4)
values(val1,val2, val3, val4);
EXCEPTION WHEN DUP_VAL_ON_INDEX THEN
message('message whatever you want' );
Raise form_trigger_failure;
end ;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
