Home » Developer & Programmer » Forms » FRM-47313: Invalid query for hierarchial tree.
FRM-47313: Invalid query for hierarchial tree. [message #129068] Thu, 21 July 2005 17:16 Go to next message
Messages: 3
Registered: July 2005
Junior Member

Using Oracle Dev Suite 10
I have followed the instructions in a book on how to create a hierarchial tree , but get "FRM-47313: Invalid query for hierarchial tree." In attempting to debug my problem, I have browsed through the web and here but can't find the solution. I simplified my Data Query property select statement to "select 1,1,'this',king','that' from dual;
I expect to get a menu with only one entry, but that is fine for testing. Still, even with this simplified select statement I get the same error message.

I have a pre-form trigger that says "ftree.populate_tree('BLOCK2.TREE4');.

BLOCK2 is a non-database control block with a Number of Records Displayed property of "1". The tree control is the only item in this block.

Where am I going wrong? Please advise!

Many thanks!

Re: FRM-47313: Invalid query for hierarchial tree. [message #290084 is a reply to message #129068] Thu, 27 December 2007 06:09 Go to previous message
Messages: 104
Registered: November 2006
Location: India
Senior Member

i think you have missed one quote in the query:

the query you have given is:
select 1,1,'this',king','that' from dual

it should have been like:
select 1,1,'this','king','that' from dual
Previous Topic: How to handle duplicate data with ranges
Next Topic: need help
Goto Forum:

Current Time: Wed Oct 26 20:34:52 CDT 2016

Total time taken to generate the page: 0.16963 seconds