i think there is nothing wrong with my syntaxDid you test it? Does the query run in SQL*Plus?
i do not know , for what it is written ?Did you try google? Did you try the oracle documentation?
and hope you can provide me with a link to the online help you've mentionedI mean the onlinehelp of forms. Try F1.
Did you test it? Does the query run in SQL*Plus?what part do you mean ?
Did you try google? Did you try the oracle documentation?yes , sure i've tried , and if i found what i need , i would not have asked in the forum ,
I mean the onlinehelp of forms. Try F1.the examples in the onlinehelp also uses lines and built-ins like i said before "connect prior and start with" , which
I mean the query you use in your creation of the record-group. If you say it does not work, it seems likely that your query is not correct, so test it in SQL*Plus or whatever tool you use for your db-development. I would guess that your query does not work and therefore the creation of the recordgroup fails.Did you test it? Does the query run in SQL*Plus?what part do you mean ?
the last thing andreas , i really appreciate your help , but you've posted about three posts in this thread without a vain ,Well, in my eyes this forum is here to give you assistance to solve your problems on your own, so that you are able so solve them alone next time. Just giving you the solution does not really help you as long as you don't understand them. You got a link to a blob-entry with a fully functionional example-tree, you have a working example on your own.
and you could easily answer my simple question directly to accomplish my prompt task .
the examples in the onlinehelp also uses lines and built-ins like i said before "connect prior and start with" , which i do not understand .But whats the implication of this? If you don't understand a specific detail, ask for that specific detail, but simple saying "It does not work, i don't understand why, give me a solution" is not the way it works (my personal opinion).
I want to show some different techniques to populate a tree and a way to interact with "standard" data-blocks.and i do not know the standard techniques originally to know the different ones .
CONNECT BY clause required in this query block- and sure i could not do anything with this error , because i do not know what connect by clause is used for , or even
select 0 , level , dname , null , deptno from deptLEVEL is a psudo-column which only exists in CONNECT BY-queries. As you do not have a CONNECT BY in your query, you cannot reference that column.You have to give a fixed value for that column and as you only have one level in your tree, simply use 1 instead of LEVEL.
LEVEL à This is a specific pseudo-column Derived from “CONNECT BY”.if you can demonstrate this line , how is it derived from "connect by" , and when you told me to replace with "1" , is this "1" means something has something to do with the "level" pseudocolumn , or it is just any column to fill the vacuum ,
ICON à That contains the icon name of the Node (can be NULL).i've seen an example uses ''open'' for the "icon" column, and tried to use it but vainly , there is no icon appears , it is like i write "null" .
as you only have one level in your tree .what is this mean , how 2 levels would look like ?
if you can demonstrate this line , how is it derived from "connect by"http://docs.oracle.com/cd/E11882_01/server.112/e26088/queries003.htm shows everything about hierarchical queries.
and when you told me to replace with "1" , is this "1" means something has something to do with the "level" pseuocolumn , or it is just any column to fill the vacuumThis is taken from the blob-entry i gave you in my first answer:
It states that the second columns NODE_DEPTH is the level of the node inside the tree and as you say you only have one level and no hierarchy in your tree, you simply do a
The query has to be defined so that it has the following result-columns column-name meaning NODE_STATE defines, how the node is initially shown in the tree (-1 = collapsed, 0 = leaf-node, 1 = expanded) NODE_DEPTH The tree-level the row it at. This column defines the hierarchy of the tree-data NODE_LABEL The text to be shown in the tree-node NODE_ICON The name of an icon-file which should be rendered for the treenode. The icon must be accessible to forms as any icon used, e.g. on a button NODE_VALUE The "value" to be stored for the tree-node
SELECT ..., 1 NODE_DEPTH, ... FROM TABLE for this column
i've seen an example uses ''open'' for the "icon" column, and tried to use it but vainly , there is no icon appears , it is like i write "null" .See the above column-description. The name has to be the name of an icon you can access in your form.If ou can use the icon on a button, you can also use it in a tree.
- and you did not mention anything about the "conncet by" , or "start with" clause .See the first link.
what is this mean , how 2 levels would look like ?If you have to levels, then you have a hierarchy which is expressed by giving different values for the NODE_DEPTH.