Printable View
We are trying to fill an embedded call with a sql statement in the macro. The grid is returned with the main table, but the sql to fill the Embedded grid only returns No Data. We only need to know how you would debug the Embeddedgrid samples in the Tornado Manual.
Thanks for the Help.
Kriss Kline
NTC
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
I think you mean how to catch the no data return from the embedded grid magiccell. There is no 'Extended' macro support. However, there is support when there is no data return. The Cell is hard coded as "No Data". I'll make this more flexible and let user define their own embedded cell text. Now change the previous example to -> where customerID= '#1#' instead of '#0#'', the there will be no data return. See the Effect of 'No Data'.
The following is from the manual ->
Format - Obj.dbEmbeddedGridMagicCell ="(;,[]#|~/+{})Field | tag | Macro"
Normal macro is only for embedded MagicCell - Basic only, No Extended or Preprogrammed.
Fk
Fixed - now No Data will be default when dbBlankText is blank. The following code will catch the no data and replace with custom text.
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= '#1#'"
.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"
.dbBlankText = "Custom Blank Text"
.ASPdbNET()
End With
No Frank, I get the No Data but I believe that the sql macro should be returning data.
In that case, show me your code and also change the above example to reflect your case. In the example the Embedded SQL is ->
Macro=SQL0:SELECT OrderID,OrderDate,RequiredDate,ShippedDate from orders where customerID= '#1#'
what is your SQL looks like.
Fk
please also explain what you mean but 'debug' the sample.
Fk