بسم الله الرحمن الرحيم


اخوانى الاعزاء فى المنتدى بعد التحية

عند خطا فى الشجرة

عاوزاستعراض كل بيانات جدول معين فى شجرة بحيث كلها عبارة عن اب ليس لها ابن

declare
htree1 item;
STR varchar2(200);
begin
STR :='select 0 , LEVEL,INITCAP(ITM_name),'' OPEN '' ITM_id from ITEMS' ;


htree1:=find_item('TREE4');
ftree.set_tree_property(htree1,ftree.query_text,STR);
ftree.populate_tree(htree1);
end;

جزاكم الله الخير

السلام عليكم ..
the Mistake in select statement
any select (Hierarchical tree) Must contain 5 Expression

Expression 1 - This expression contains a value that expresses the state of the record. State indicates
whether the record is shown (expanded), not shown (collapsed), or shown at the
same level as the parent record. A value of ‘1’ will cause the record to be shown. A
value of ‘-1’ will cause the record to be hidden with the parent record marked as
having children record. A value of ‘0’ will cause the record to be displayed at the
same level as the parent. This expression is referenced as tree property
Ftree.node_state.

Expression 2 - This expression contains a value that ranks the record in the hierarchy. For example, if
the record is a grandparent it would have a value of 1; if it were the parent it would
have a value of 2; and finally the child record would have a value of 3. This expression
is referenced as tree property Ftree.node_depth.

Expression 3 - This expression contains the value that will be displayed in the tree when the record is
displayed. The value can be literal text if the node is a description of the next level of
records such as ‘Departments’ in Figure 1 or the name of a table column if it
represents the actual table values. This expression is referenced as tree property
Ftree.node_label.

Expression 4 - This expression identifies the icon that can be shown next to the node. This is a
comparable feature to the icons used in Object Navigator to represent various objects
(i.e. canvas, data blocks, items). The referenced icons must be located in the current
working directory or the directory listed in the UI_ICON string value in the registry. A
value of ‘null’ can be used if no icon is desired. This expression is referenced as tree
property Ftree.node_icon.

Expression 5 - This expression contains a value that is used to identify the record used on the current
node. It is generally the primary key of the record that supplied the value and can be
used when navigating to another form. . This expression is referenced as tree property
Ftree.node_value.