Home » Developer & Programmer » Forms » Get_item_property LOV_NAME return FRM-40738 error (10.1.2.0.2 , xp)
Get_item_property LOV_NAME return FRM-40738 error [message #311853] Mon, 07 April 2008 02:47 Go to next message
azadehfar
Messages: 10
Registered: April 2006
Location: iran
Junior Member
Dear all
Hi

i want when i press double click on each text item show lov

i write a procedure and call in main WHEN-MOUSE-DOUBLECLICK trigger :

PROCEDURE show_lov_button IS
item_name varchar2(50);
canvas_name varchar2(50);
lov_but_name varchar2(50):='DUMMY_BLOCK.LOV_BUT' ;
lov_name varchar2(50);
lov_choose boolean;
BEGIN

item_name:=:SYSTEM.CURSOR_ITEM;
lov_name := get_item_property(item_name,LOV_NAME);


if get_item_property(item_name,ITEM_TYPE)='TEXT ITEM' then

if get_item_property(item_name,DATATYPE)='DATE' then
calendar.show;

elsif lov_name is not null then

lov_choose:=show_lov(lov_name);
end if ;
end if ;

End;

in lov_name := get_item_property(item_name,LOV_NAME); record return me FRM-40738 error .

Please Help me .
Regards
Adel Azadehfar

Re: Get_item_property LOV_NAME return FRM-40738 error [message #311892 is a reply to message #311853] Mon, 07 April 2008 05:11 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
I think that this error doesn't appear every time you run the form. But comes when you try to navigate to different items?

If that is so then this error might be comming b/c you are trying to get lov name of an item where doesn't has an lov attached to it.

Regards,
Azam Khan
Re: Get_item_property LOV_NAME return FRM-40738 error [message #311911 is a reply to message #311892] Mon, 07 April 2008 06:28 Go to previous messageGo to next message
azadehfar
Messages: 10
Registered: April 2006
Location: iran
Junior Member
tanks for reply
i try another one in next fields and another forms but get same error ( FRM-40738 ) .
i attached my fmb .

when i press double click on text field get FRM-40738 error.
Please help me for solve this problem.

Regards
  • Attachment: Calendar.fmb
    (Size: 108.00KB, Downloaded 530 times)
Re: Get_item_property LOV_NAME return FRM-40738 error [message #311916 is a reply to message #311911] Mon, 07 April 2008 06:33 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear friend,

I dont have webutl libaray. So the form opened but most of the trigger's coding pan is flash.

Regards,
Azam Khan
Re: Get_item_property LOV_NAME return FRM-40738 error [message #311918 is a reply to message #311853] Mon, 07 April 2008 06:35 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
By the way you have seen in the help of GET_ITEM_PROPERTY help you will find that if item doesn't have an LOV attached form will give you an error.

I would suggest that you should see you code again you might be have the error b/c of this.

Regards,
Azam Khan
Re: Get_item_property LOV_NAME return FRM-40738 error [message #312276 is a reply to message #311918] Tue, 08 April 2008 06:42 Go to previous messageGo to next message
azadehfar
Messages: 10
Registered: April 2006
Location: iran
Junior Member
Hi My friend

Tanks for Reply
i pick up webutil pll and add a lov to this field
normaly must by this code :
lov_name := get_item_property(item_name,LOV_NAME);

return lov name but return same error .
i attache new fmb

Please help me .
Regards
  • Attachment: Calendar.fmb
    (Size: 68.00KB, Downloaded 230 times)
Re: Get_item_property LOV_NAME return FRM-40738 error [message #312311 is a reply to message #312276] Tue, 08 April 2008 09:15 Go to previous message
solisdeveloper
Messages: 48
Registered: March 2008
Location: Mexico
Member
Does it say "List of Values" on the message line at the bottom of your screen when you put the focus on the desired Item? this is a good indicator of whether if your item has a lov attached to it or not at all.

Try this at run time, just place yourself on the Item and check if you get this message.
Previous Topic: dynamically adding a row item in a data block
Next Topic: how to validate date
Goto Forum:
  


Current Time: Sat Dec 03 14:22:29 CST 2016

Total time taken to generate the page: 0.07563 seconds