| FRM-47313: Invalid query for hierarchial tree. [message #129068] |
Thu, 21 July 2005 17:16  |
dindo_tudara
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  |
mintomohan
Messages: 104
Registered: November 2006
Location: India
|
Senior Member |
|
|
hi,
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
