Home » Developer & Programmer » Forms » Unable to Navigate between LOVs
Unable to Navigate between LOVs [message #473540] Mon, 30 August 2010 02:28 Go to next message
koolshibu
Messages: 10
Registered: August 2010
Junior Member
I have 2 datablocks(non database) 1-Header & 2-Detail.
In Header there are 3 Text Item with 3 LOV attached with them.
When all the 3 Fields are filled (with the help of their respective LOVs)then Detail records are populated.

However if I am choosing LOV for the 1st Item and then clicking the 2nd Item, Again if I wish to go back to the 1st Item LOV I am unable to do so.

That means my issue is I am not able to navigate to the 1st item in Header to call its LOV if control is in in the 2nd Item.

Both the Header n Detail have the folloowing property:

Navigation Style : Change Datablock
Previus Navigation DataBlock : Null
Next Navigation DataBlock : Null


Re: Unable to Navigate between LOVs [message #473573 is a reply to message #473540] Mon, 30 August 2010 06:07 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What does "being unable to navigate to 1st item" mean? Is there any error message? If so, which one?
How do you navigate to the previous item? Using a mouse or a keyboard? Is there any trigger written on those items (such as KEY-NEXT-ITEM or KEY-PREV-ITEM that prevent navigation)?
Re: Unable to Navigate between LOVs [message #473703 is a reply to message #473573] Tue, 31 August 2010 04:42 Go to previous messageGo to next message
koolshibu
Messages: 10
Registered: August 2010
Junior Member
Header Items:
Region Code, Region Name,
Division Code, Division Name
Major Category Code, Major Category Name
Assoert Role, Indent Frequency
Detail Items:
Category Code, Category Name, and SupplyDays(Mon, Tue, Wed...Sun )
After selecting Region(from LOV), i m coming to Division Code by pressing Tab. After selecting Division Code, I m coming to Major category, after selecting major category (from LOV), when an Assort Role is selected from the List Item then Detail data are populated.
Issue is after selecting Region, when i am selecting Division, then again if im going back & double clicking Region, I am not able to popup its LOV. The control still remains in the Division Code. However by Tab I am able to move back to Region.

KEY-NEXT-ITEM Trigger is on -
(1) Region (Its only checking if Region is left Blank or not)
(2) Assort Role (It's populating some value in the Weekly Indent Frequency based its value chosen)
Re: Unable to Navigate between LOVs [message #473705 is a reply to message #473703] Tue, 31 August 2010 04:47 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
What code are you using to bring up the LOV? double-click isn't the normal method.

Also sounds like your KEY-NEXT-ITEM triggers should be WHEN-VALIDATE-ITEM
Re: Unable to Navigate between LOVs [message #473708 is a reply to message #473705] Tue, 31 August 2010 05:23 Go to previous messageGo to next message
koolshibu
Messages: 10
Registered: August 2010
Junior Member
For all 3 i.e, Region, Division & Maj Cat , I am using
1-WHEN-MOUSE-DOUBLE-CLICK &
2-KEY-LISTVAL
And LOV of MajCat is Dependent on Division
Re: Unable to Navigate between LOVs [message #473710 is a reply to message #473708] Tue, 31 August 2010 05:26 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
So what's the code in WHEN-MOUSE-DOUBLE-CLICK?
Re: Unable to Navigate between LOVs [message #473712 is a reply to message #473710] Tue, 31 August 2010 05:36 Go to previous messageGo to next message
koolshibu
Messages: 10
Registered: August 2010
Junior Member
WHEN-MOUSE-DOUBLE-CLICK:
BEGIN
DO_KEY('LIST_VALUES');
END;
KEY-LISTVAL:
DECLARE
v_lov BOOLEAN;

BEGIN
IF :title_hdr.txt_status IN ('Add','Query') THEN
v_lov := SHOW_LOV('LOV_RO_LOC');


ELSE
RAISE FORM_TRIGGER_FAILURE;
END IF;
END;
Re: Unable to Navigate between LOVs [message #473713 is a reply to message #473712] Tue, 31 August 2010 05:43 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Try changing the WHEN-MOUSE-DOUBLEE-CLICK to:
BEGIN
Go_Item(:System.Trigger_Item); 
DO_KEY('LIST_VALUES');
END;


Can you also please read the orafaq forum guide and follow it in future - specifically the part about formatting posts.
Re: Unable to Navigate between LOVs [message #473714 is a reply to message #473713] Tue, 31 August 2010 05:59 Go to previous messageGo to next message
koolshibu
Messages: 10
Registered: August 2010
Junior Member
NOPE !!
Not working.
Still I am poping up the LOV only by going to that Item by TAB & pressing f9 or Double clicking.
Not by Directly Mouse Clicking.
Re: Unable to Navigate between LOVs [message #473718 is a reply to message #473714] Tue, 31 August 2010 06:51 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you single click in that item does the cursor move to that item?
Re: Unable to Navigate between LOVs [message #473722 is a reply to message #473718] Tue, 31 August 2010 07:55 Go to previous messageGo to next message
koolshibu
Messages: 10
Registered: August 2010
Junior Member
No it's not moving.
That's the Problem.
Re: Unable to Navigate between LOVs [message #473725 is a reply to message #473722] Tue, 31 August 2010 08:17 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Are you getting an errors when you try to click on the other item?
Have you tried running the form in debug mode? It'd help if we knew what triggers were firing when you do this.
Re: Unable to Navigate between LOVs [message #473840 is a reply to message #473725] Wed, 01 September 2010 01:33 Go to previous message
koolshibu
Messages: 10
Registered: August 2010
Junior Member
My issue is resolved now.
I modified as: handled all the code of WHEN-VALIDATE-ITEM OF the 3 Header items, in their respective KEY-LISTVAL ie where the LOVs were called.
I dont know what went wrong in the previus one, but issue is resolved now.
Anyways, thanks a lot all of U. !!
Previous Topic: how can i attach image
Next Topic: system.cursor_record
Goto Forum:
  


Current Time: Thu Sep 19 12:52:56 CDT 2024