OraFAQ Forum: Forms » Get_item_property LOV

Home » Developer & Programmer » Forms » Get_item_property LOV_NAME return FRM-40738 error (10.1.2.0.2 , xp)

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

Get_item_property LOV_NAME return FRM-40738 error [message #311853]

Mon, 07 April 2008 02:47

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

Report message to a moderator

Re: Get_item_property LOV_NAME return FRM-40738 error [message #311892 is a reply to message #311853]

Mon, 07 April 2008 05:11

azamkhan
Messages: 557
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

Report message to a moderator

Re: Get_item_property LOV_NAME return FRM-40738 error [message #311911 is a reply to message #311892]

Mon, 07 April 2008 06:28

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 1407 times)

Report message to a moderator

Re: Get_item_property LOV_NAME return FRM-40738 error [message #311916 is a reply to message #311911]

Mon, 07 April 2008 06:33

azamkhan
Messages: 557
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

Report message to a moderator

Re: Get_item_property LOV_NAME return FRM-40738 error [message #311918 is a reply to message #311853]

Mon, 07 April 2008 06:35

azamkhan
Messages: 557
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

Report message to a moderator

Re: Get_item_property LOV_NAME return FRM-40738 error [message #312276 is a reply to message #311918]

Tue, 08 April 2008 06:42

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 1094 times)

Report message to a moderator

Re: Get_item_property LOV_NAME return FRM-40738 error [message #312311 is a reply to message #312276]

Tue, 08 April 2008 09:15

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.

Report message to a moderator

Previous Topic:	dynamically adding a row item in a data block
Next Topic:	how to validate date

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 12:14:03 CDT 2025