OraFAQ Forum: Forms » Error about Total Field

Home » Developer & Programmer » Forms » Error about Total Field

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

Error about Total Field [message #586716]

Mon, 10 June 2013 05:16

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi,

frm-41375: cannot set queryable property of calculated item :emp.sumsal..

please suggest me how to remove this error

Thanks,
Siva

Report message to a moderator

Re: Error about Total Field [message #586723 is a reply to message #586716]

Mon, 10 June 2013 05:44

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Set "Query allowed" item property to "No".

Report message to a moderator

Re: Error about Total Field [message #586727 is a reply to message #586723]

Mon, 10 June 2013 06:13

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Thanks for reply,

I got same error at run time, i have totally 6 Total(Sum) fields,i Set "Query allowed" item property to "No", And i attached Screen shot and Could you Please suggest me,how to fix that error..

Thanks,

Attachment: image1.png
(Size: 61.91KB, Downloaded 668 times)

Report message to a moderator

Re: Error about Total Field [message #586731 is a reply to message #586727]

Mon, 10 June 2013 06:20

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Do you use SET_ITEM_PROPERTY which modifies these items' "query allowed" property to "Yes"? Search your PL/SQL code and fix it.

Report message to a moderator

Re: Error about Total Field [message #586739 is a reply to message #586731]

Mon, 10 June 2013 06:42

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi Littlefoot,

I wrote when-new-instance trigger on "TOTAL_ORIGINAL"(Summary Field)at item level
like that

begin
if :RHCLANDEDCOSTDET.TOTAL_ORIGINAL is not null then
set_item_property('RHCLANDEDCOSTDET.TOTAL_ORIGINAL', QUERYABLE , PROPERTY_TRUE);
else
set_item_property('RHCLANDEDCOSTDET.TOTAL_ORIGINAL', QUERYABLE , PROPERTY_FALSE);
end if;
end;

But, again i got an error like..

Could you please suggest me..

Thanks

Report message to a moderator

Re: Error about Total Field [message #586742 is a reply to message #586739]

Mon, 10 June 2013 06:45

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

Senior Member

Why did you write that trigger?
Surely that item should always have its queryable property set to false.

Report message to a moderator

Re: Error about Total Field [message #586743 is a reply to message #586739]

Mon, 10 June 2013 06:45

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

This:

set_item_property('RHCLANDEDCOSTDET.TOTAL_ORIGINAL', QUERYABLE , PROPERTY_TRUE);

is wrong. Calculated items can't be queryable, there's no use in setting that property to TRUE. That's what the error message in your first post suggests.

Report message to a moderator

Re: Error about Total Field [message #586744 is a reply to message #586743]

Mon, 10 June 2013 06:50

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Thanks LittleFoot,

Can i write this code in POST-QUERY at Block level,or any other triggers..

Thanks,
Siva

Report message to a moderator

Re: Error about Total Field [message #586746 is a reply to message #586744]

Mon, 10 June 2013 06:56

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You don't understand what we are saying: calculated items can NOT be queryable. You can query items that are based on table columns. Calculated item is a "control" item, its source isn't a column, it is ... calculated and you can't perform query based on such a value.

Therefore, there's no use in moving your code elsewhere, into other triggers. It just won't work.

Report message to a moderator

Previous Topic:	how to display table column heading on oracle form 6i
Next Topic:	how to integrate visual source safe with oracle developer 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 17:58:11 CDT 2024