OraFAQ Forum: Forms » LOV again change value on same row in oracle form

Home » Developer & Programmer » Forms » LOV again change value on same row in oracle form

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

LOV again change value on same row in oracle form [message #673877]

Fri, 14 December 2018 00:04

agm
Messages: 2
Registered: December 2018

Junior Member

i m using oracle form 6i...I restrict the values of my LOV, that the end user cannot select twice the same...for this i write a code on when validate trigger.now i selected value from LOV for first row but when i selected value from LOV for 2nd row it change the value of first row...cursor not move to second row automatically....

Report message to a moderator

Re: LOV again change value on same row in oracle form [message #673883 is a reply to message #673877]

Fri, 14 December 2018 03:34

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

You did something wrong.
But without seeing the code it's hard to guess what.
So post the code of the when-validate-item trigger.

Report message to a moderator

Re: LOV again change value on same row in oracle form [message #674339 is a reply to message #673883]

Tue, 22 January 2019 03:40

agm
Messages: 2
Registered: December 2018

Junior Member

Assume the record group select order is the following:

select empno, ename from emp

The automatic refresh of the LOV must be set to NO

Assume the LOV is attached to the EMP.EMPNO item, add the following code to its When-Validate-Item trigger:

--
-- Remove the selected value from the record group
--
DECLARE
rg_id RecordGroup;
rec_count NUMBER;
BEGIN

-- Get the record group ID --
rg_id := Find_Group( 'EMP_GRP' );

-- Get the number of rows --
rec_Count := Get_Group_Row_Count( rg_id );

-- delete the selected row --
FOR j IN 1..rec_Count LOOP
If Get_Group_Number_Cell( 'EMP_GRP.EMPNO', j ) = :EMP.EMPNO Then
Delete_Group_Row( rg_id, j );
exit ;
End if ;
END LOOP;

END;
i m using this code

Report message to a moderator

Re: LOV again change value on same row in oracle form [message #674342 is a reply to message #674339]

Tue, 22 January 2019 05:32

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Hard to say but I suspect you've got validate_from_list on (which you should do) and the fact that you are removing items from the group is messing it up.

I never do it that way.

I write an LOV query that excludes values inserted into the table the block is based on.
I then post each record to the DB as it is entered.

Report message to a moderator

Previous Topic:	Validation of Value in Sales Order Form
Next Topic:	Dynamic Control Of rows in a excel to oracle forms importing form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 00:29:24 CST 2025