Home » Developer & Programmer » Forms » about button on LOV - Oracle Forms 10g (Oracle Form 10g)
about button on LOV - Oracle Forms 10g [message #507778] Tue, 17 May 2011 21:03 Go to next message
dophuong_cs
Messages: 92
Registered: May 2011
Location: Viet Nam
Member

Hi all!
I hava LOV and i want process events when click button Cancle on LOV then disable a canvas, but i don't know how process it.
where could know events click mouse in button Cancle on LOV - Oracle Forms?
I wish i could recived anserw from you!
Thanks & Regards

[Updated on: Tue, 17 May 2011 21:17]

Report message to a moderator

Re: about button on LOV - Oracle Forms 10g [message #507801 is a reply to message #507778] Wed, 18 May 2011 01:14 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What do you mean by "disabling a canvas"?

This is a scenario: you run a form. Navigate through items. There's a LoV on one of items. You open the LoV. Click <Cancel>. Now you want to "disable a canvas".

I'm afraid I don't understand what you said.
Re: about button on LOV - Oracle Forms 10g [message #507945 is a reply to message #507801] Wed, 18 May 2011 09:55 Go to previous messageGo to next message
dophuong_cs
Messages: 92
Registered: May 2011
Location: Viet Nam
Member

explain i have 1 LOV and i want "disable a canvas" if mouse click button "Cancle" on LOV that, but how don't it, please help for me, i very need.
Re: about button on LOV - Oracle Forms 10g [message #507946 is a reply to message #507801] Wed, 18 May 2011 10:01 Go to previous messageGo to next message
cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester
Senior Member
Littlefoot wrote on Wed, 18 May 2011 07:14
What do you mean by "disabling a canvas"?

Re: about button on LOV - Oracle Forms 10g [message #508008 is a reply to message #507946] Wed, 18 May 2011 22:21 Go to previous messageGo to next message
dophuong_cs
Messages: 92
Registered: May 2011
Location: Viet Nam
Member

explain, now i has a Form called "NHAN_VIEN", block1 name is "EMP" on form "NHAN_VIEN" and display canvas name "CV_TB1" , block 2 name "DEPT" on form "NHAN_VIEN" display on canvas "CV_TB2".
Now, i run form and on block1 display full about 'employee': name employee, department, salary... inthere department choose from LOV name "LOV_DEPT". When LOV display, if click in button "OK" then return value of LOV for Item department on block1, if click in button "Cancle" then display canvas2, but i don't know how do it to perform display canvas2 when click in button "Cancle" on LOV name "LOV_DEPT".
please help me.
Re: about button on LOV - Oracle Forms 10g [message #508027 is a reply to message #508008] Thu, 19 May 2011 01:54 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is what you might do: basically, you don't want to "disable" current canvas, but change focus to another one (which is, actually, an item in another block that is located on a different canvas). Therefore, KEY-LISTVAL trigger (or, if you are opening a LoV by pushing a button, WHEN-BUTTON-PRESSED) might look like this:
go_item('dept.deptno');
list_values;
if :dept.deptno is null then
   go_item('emp.empno');
end if;

In other words: if you don't select DEPTNO from list of values, :DEPT.DEPTNO item will remain empty, IF will evaluate to TRUE and you'll GO_ITEM (to another block on another canvas).
Re: about button on LOV - Oracle Forms 10g [message #508032 is a reply to message #508027] Thu, 19 May 2011 02:10 Go to previous messageGo to next message
dophuong_cs
Messages: 92
Registered: May 2011
Location: Viet Nam
Member

how do you know click in button "Cancle" of LOV then after then display canvas2.
Re: about button on LOV - Oracle Forms 10g [message #508034 is a reply to message #508032] Thu, 19 May 2011 02:19 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I can't (don't know how to) capture <Cancel>, but I *suppose* (which might be wrong) that, if you don't select anything, item remains empty. THAT I can check (with an IF).
Re: about button on LOV - Oracle Forms 10g [message #508289 is a reply to message #508034] Fri, 20 May 2011 03:24 Go to previous messageGo to next message
1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad
Member
Sir, I think if "show_lov" built-in is used instead of "list_values" then we may track, on the basis of returned boolean value, whether user has selected any value from LOV.
Re: about button on LOV - Oracle Forms 10g [message #508305 is a reply to message #508289] Fri, 20 May 2011 04:16 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
/forum/fa/2115/0/

Much better option than mine, because the item could have had a value BEFORE list of values was displayed (so my IF wouldn't do its job correctly).
Previous Topic: how can update primary key in master and details
Next Topic: Get_block_Property
Goto Forum:
  


Current Time: Sat Sep 07 15:35:59 CDT 2024