>Hi,
>Can anyone give me the syntax to setup a table with more than 1 level
>of hierarchy in a data shape for example:
>
>--this works perfect!!
>strSh = "SHAPE {SELECT distinct moc001 FROM styles} "+;
> "APPEND ({SELECT moc001,moc002,mon001 FROM styles} "+;
> " AS CollectStyles RELATE moc001 TO moc001)"
>
>
>--need to add another level...this attempt doesnt work...
>strSh = "SHAPE {SELECT distinct moc001 FROM styles} "+;
> "APPEND (SHAPE {select distinct moc002 from styles}"+;
> "APPEND ({SELECT moc001,moc002,mon001 FROM styles}) "+;
> "RELATE moc001 TO moc001)"
>
>--Maybe one more level?
>
>What I would like to get is
>
>+MOC001
> +MOC002
> +other values
>
>FYI the database is oracle,db2 or sqlserver..
>
>BR
>Tim

Tim,
Do a search for HierarchicalFlexGrid and I can assure you'd find samples with 'select ...' and the easier 'table' :)
Cetin