OraFAQ Forum: Forms » No. of records displayed in list item is more than 1

Home » Developer & Programmer » Forms » No. of records displayed in list item is more than 1 (Oracle 10g forms)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: No. of records displayed in list item is more than 1 [message #487517 is a reply to message #487492]

Tue, 28 December 2010 06:52

infosuresh2k
Messages: 77
Registered: September 2009
Location: CHENNAI, INDIA

Member

Hi,

You want to restrict the selection(user selects 10 then again next record if same 10 they selects then we have to through message) or u want to remove the value from the list in further records.

Regards,
Suresh.V

Report message to a moderator

Re: No. of records displayed in list item is more than 1 [message #487861 is a reply to message #487517]

Mon, 03 January 2011 00:15

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

Requirement is clear...when user select any value in list ...he cant select this value again...

Report message to a moderator

Re: No. of records displayed in list item is more than 1 [message #487863 is a reply to message #487517]

Mon, 03 January 2011 00:27

madhur05321
Messages: 7
Registered: December 2010
Location: Chandigarh

Junior Member

hi.......

Thanx for the reply ..i mean tell me any of the way..whether user will go through message or the selected item should not be appear next time.

Regards
Madhur Jain

Report message to a moderator

Re: No. of records displayed in list item is more than 1 [message #487866 is a reply to message #487863]

Mon, 03 January 2011 00:43

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

hey madhur,

just create global temporary table....your problem will be solved...

Report message to a moderator

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 ;

Report message to a moderator

Re: No. of records displayed in list item is more than 1 [message #487869 is a reply to message #487866]

Mon, 03 January 2011 00:50

madhur05321
Messages: 7
Registered: December 2010
Location: Chandigarh

Junior Member

thanx for the reply..
the table from wich i am creating the record group..that table shud i convert into global temporary table?????

Madhur

Report message to a moderator

Re: No. of records displayed in list item is more than 1 [message #487870 is a reply to message #487869]

Mon, 03 January 2011 00:51

madhur05321
Messages: 7
Registered: December 2010
Location: Chandigarh

Junior Member

Report message to a moderator

Re: No. of records displayed in list item is more than 1 [message #487875 is a reply to message #487870]

Mon, 03 January 2011 01:40

madhur05321
Messages: 7
Registered: December 2010
Location: Chandigarh

Junior Member

hi..

Sir its not working..can u elaborate how it works?????

Madhur

Report message to a moderator

Re: No. of records displayed in list item is more than 1 [message #487879 is a reply to message #487875]

Mon, 03 January 2011 01:54

madhur05321
Messages: 7
Registered: December 2010
Location: Chandigarh

Junior Member

what is happening m telling u ...

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 ;

this code is just stopping the user to enter the duplicate record in global temporary table.
lets suppose user is on first record of the list item.and he is keep on changing the values of that list item.
then this code is keep on inserting the values in a table.and then when user moves to next record then this stops him to select any of the value bcz all the values are already in that table.I want whn user moves to next record then the prior value selected by him on first record.that value only should be insert in a table.then only we can stop the user to select that value not all the values.....Hope i have clear the problem

Madhur

Report message to a moderator

Re: No. of records displayed in list item is more than 1 [message #487883 is a reply to message #487879]

Mon, 03 January 2011 02:59

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

hi madhur,

i had same req. while creating this attach form...my requirement is that i cant select same item code, empid for each record....

is same kind of your requirment ?

Attachment: pblm.GIF
(Size: 78.70KB, Downloaded 595 times)

Report message to a moderator

Re: No. of records displayed in list item is more than 1 [message #487926 is a reply to message #487883]

Mon, 03 January 2011 06:42

madhur05321
Messages: 7
Registered: December 2010
Location: Chandigarh

Junior Member

hi swapnil..

You are saying that u can not select same item code..but at my side..m able to select the same item..but i dont want to select the same..

Madhur

Report message to a moderator

Re: No. of records displayed in list item is more than 1 [message #488118 is a reply to message #487926]

Wed, 05 January 2011 01:24

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

hi madhur,

i know your req. thats why i tell u read global temporary table concept...

as per concept, if u selecting same values error shown immediately..

Report message to a moderator

Previous Topic:	Load html page inside a canvas (merged)
Next Topic:	Passing parameter with form link

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 17:22:45 CDT 2024