Home » Developer & Programmer » Forms » what is wrong with this code?
what is wrong with this code? [message #211441] Thu, 28 December 2006 13:00 Go to next message
jewelthief
Messages: 2
Registered: December 2006
Junior Member
DECLARE
htree ITEM;
node_value VARCHAR2(100);
abc number;
BEGIN

htree := Find_Item('tree1');


node_value:=Ftree.Get_Tree_Node_Property(htree, :SYSTEM.TRIGGER_NODE, Ftree.node_value );

set_block_property('TOPICS',default_where,'topic_id=node_value');
go_block('TOPICS');
execute_query;
if error_code=40505 then
set_alert_property('alert',alert_message_text,DBMS_ERROR_TEXT);
abc:=show_alert('alert');
end if;


END;

i have written this code in when-tree-node-selected trigger but it is giving me error that
"NODE_VALUE" invalid identifier.
Re: what is wrong with this code? [message #211450 is a reply to message #211441] Thu, 28 December 2006 14:39 Go to previous messageGo to next message
Littlefoot
Messages: 20899
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
set_block_property('TOPICS',default_where,'topic_id=node_value');

In this line, you've said that 'topic_id = node_value' - it is a string, all of it. Would it help if you put it this way?

... 'topic_id=' || node_value);
Re: what is wrong with this code? [message #212214 is a reply to message #211441] Thu, 04 January 2007 04:40 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: replace form on server
Next Topic: Matrix Form
Goto Forum:
  


Current Time: Wed Dec 07 12:52:05 CST 2016

Total time taken to generate the page: 0.20494 seconds