Shape Relate Order By based on parent
- From: Khaled.Omar@xxxxxxxxx
- Date: 25 May 2006 16:32:25 -0700
I have a question regarding the ADO shape relate command,
I have the following query,
getTreeSQL = " SHAPE {SELECT LINK_ID a,FK_PARENT_ID
b,FK_TREE_ID,FK_TYPE_ID,NAME,LINK,FK_ORDER_TYPE_ID,SORT_INDEX from
TVL_LINK L1 WHERE FK_TREE_ID = " + treeObj.treeID + " AND FK_PARENT_ID
= " + treeObj.RootID + " ORDER BY SORT_INDEX} AS FirstLevel";
getTreeSQL += " APPEND (" ;
getTreeSQL += " (";
getTreeSQL += " SHAPE {select LINK_ID c,FK_PARENT_ID
d,FK_TREE_ID,FK_TYPE_ID,NAME,LINK,FK_ORDER_TYPE_ID,SORT_INDEX from
TVL_LINK L2 WHERE FK_TREE_ID = " + treeObj.treeID + " ORDER BY
SORT_INDEX} " ;
getTreeSQL += " APPEND (" ;
getTreeSQL += " {select LINK_ID,FK_PARENT_ID
e,FK_TREE_ID,FK_TYPE_ID,NAME,LINK,FK_ORDER_TYPE_ID,SORT_INDEX from
TVL_LINK L3 WHERE FK_TREE_ID = " + treeObj.treeID + " ORDER BY
SORT_INDEX} AS ThirdLevel " ;
getTreeSQL += " RELATE c TO e" ;
getTreeSQL += " )" ;
getTreeSQL += " ) AS SecondLevel " ;
getTreeSQL += " RELATE a TO d )";
Instead of order by Sort_index I want to order by name if the
FK_ORDER_TYPE of the parent is equal to 1 and by SORT_INDEX if it is
equal to 2.
when I wrote order by decode(firstlevel.FK_order_type,1,'name', 2,
'sort_index') I got an error that firstlevel.fk_order_type is not a
valid identifier. I want to reference the parent in the child record
set to be able to do it.
Your help is greatly appreciated
.
- Prev by Date: Runtime-error '-2147024882(8007000e)' Not enough storage available to complete this operation.
- Next by Date: SQL Server 2005 with SQLNCLI is not allowing CREATE DATABASE
- Previous by thread: Runtime-error '-2147024882(8007000e)' Not enough storage available to complete this operation.
- Next by thread: SQL Server 2005 with SQLNCLI is not allowing CREATE DATABASE
- Index(es):
Relevant Pages
|
|
