How to debug EmbeddedGrid SQL statements

[Frank]

Give an example using Nwind or equivalent. The following is a Nwind example. Modify this code to reflect your case.



Dim E64 As New Tornado.z
With E64
.dbQP = "U=60| S=11|D=Nwind|gdf=CustomerID, CompanyName, ContactName"
.dbGridMagicCell = "(;![]#|~/+{})field=CompanyName|Macro=#1#<br>#4#<br>#5#, #7#<p>#2#<br>#4#<br>#9#!field=ContactName|Macro=SQ L0:SELECT OrderID,OrderDate,RequiredDate,ShippedDate from orders where customerID= '#0#'"
.dbNameMap = "field=CustomerID|alias=ID,field=CompanyName|alias =Customer,field=ContactName|alias=Orders"
.dbEmbeddedGridNameMap = "field=OrderID|alias=ID,field=OrderDate|alias=Orde red,field=RequiredDate|alias=Required,field=Shippe dDate|alias=Shipped"
.dbSQL = "SELECT CustomerID,CompanyName,ContactName,ContactTitle,Ad dress,City,Region,PostalCode,Country,Phone,Fax FROM Customers"
.dbTextHolder = "Title=Tornado Demo - MagicCell - Master with embedded Details"
.ASPdbNET()
End With



FK