I am trying to use a Tree option in Tornado. I used the eg from the site.
But I connected to sql server instead of mdb.

When I run this I get the error

(765 : 999) Error
Error - Invalid SQL






(765 : 999) Error
Error - Invalid SQL

I ran the trace and checked out to see what it the sql it is running and
here it is

SELECT COUNT(1) FROM (Select Employeeid, Orderid, customerid From orders
group by Employeeid, Orderid, Customerid)


For some reason it is running the code replacing the table name with the
full select statement ?

Any help is greatly appreciated...

Thanks
Mani

PS here is the code I am executing


<!--T_ShowTree_3.aspx-->
<%@ Page Language="vb" Debug="true" %>
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim tree As New Tornado.Z()
With tree
.dbPageSize = -1
.dbDbType="sql"
.dbDSN = "gmserver;NORTHWIND;nwind;nwind"
'.dbCommonTables = "index=EID,FullName|sql=Select Employeeid,
Firstname & ' ' & Lastname from employees"
'.dbLookUpFlds = "field=Employeeid|keyindex=EID|lookupindex=FullNam e"
.dbSQL = "Select Employeeid, Orderid, customerid From orders group by
Employeeid, Orderid, Customerid"

'... DB data source defined - use tree to present

.dbTreeParams = "wi=200| he=500|mst=5| mbg=ffffff|
mifp=aspdbmenuicons1.gif| sifp=aspdbmenuscroll.gif| fontsize2=11|
fontname0=Verdana| fontname1=Verdana| fontname2=Verdana| fontname3=Verdana|
textstyle2=1| xoffset0=4| xoffset1=4| xoffset2=4| xoffset3=3|
hovercolor0=6E6E6E| hovercolor1=6E6E6E |hovercolor2=6E6E6E
|hovercolor3=6E6E6E| opencolor0=FF0000| opencolor1=FF0000|
opencolor2=FF0000| visitedcolor0=a5a5a5| Visitedcolor1=a5a5a5|
visitedcolor2=a5a5a5| visitedcolor3=a5a5a5| nodeheight=1| Type=DB|
defaultAction=javascript:alert('Employee = [[0]] : Order ID = [[1]] :
CustomerID = [[2]]')"
Response.Write(.ASPdbTree())

End With
End Sub
</script>