FRM-47323 error

Hello,

When I delete a record from data base and from tree, I got an error message
FRM-47323: No nodes are selected in the tree.
How to select next or previous node ti avoid such an error?

Solceiga
LVL 1
SolveAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Helena Markováprogrammer-analystCommented:
There is FTREE package in the Forms there. Also see "Manipulating a hierarchical tree at runtime" topic in the on-line help (especially FIND_TREE_NODE built-in).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SolveAuthor Commented:
Hello,

I still get that error message when no nodes are selected in the tree?
Does it means, that at least one node must be selected?
I didn't find anything about this error ...
But this doesn't disturb me.
And have one more small question according hierarchical tree:
is there any possibilities to remember a tree's expantion?
For example, when I go through the tree, I expand it under my needs, but when I execute_query,
I populate my tree again, when select the node in the tree, but it is all expanded, not just these previous braches.
Could you help?

s.
0
Helena Markováprogrammer-analystCommented:
You can know which node/nodes is/are expanded - you can move through the tree and store it to the variables.I would store Ftree.NODE_VALUE. After repopulating the tree you can once more go through the tree and expand node/nodes.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

SolveAuthor Commented:
ok,
and how to make a tree to be not expanded in the begining?

s.
0
Helena Markováprogrammer-analystCommented:
Set_Tree_Node_Property(htree,Ftree.ROOT_NODE,Ftree.NODE_STATE,COLLAPSED_NODE);
0
SolveAuthor Commented:
Thank you, very much!
But I am forced to accept other answer, witch corespond the original question :)

s.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.