Tornado - Dropdown during Add Record
I'm still unable to successfully implement a dropdown field in Add record mode. This seems to occur when using multiple "new tornado.z" modules.
Using a single module works fine.
I've included some code using "NWIND"
as an example.
<%@ Page Language="vb" %>
<script runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
Dim Emp As String = "Nancy,Andrew,Janet,Margret,Steven,Micheal,Robert, Laura,Anne"
Dim ID As String
Dim GD As New Tornado.Getdata()
Dim M1 As New Tornado.Z()
With M1
.dbQP = "U=6| M=ty=SBox!SboxMacro=({{1,2,3,4,5,6,7,8,9}}~{{" & Emp & "}})"
.dbTextHolder = "Title=Select an Employee"
.ASPdbNET()
End With
Response.Write("<Center>" & GD.Get_Sbox(6) & "</center>")
ID = GD.Get_SelectBoxSelection(6)
Dim EmpArr As String() = Split(Emp, ",")
Dim M2 As New Tornado.Z()
With M2
.dbQP = "U=7| M=Grid| D=NWIND| ni=b5,add| gdf=0,1,2,3,7|Bm=orders;0| Q=Select * FROM Employees where EmployeeID = " & ID
.dbEditUpdateFlds = "fi=lastname|ty=SelectBox|tex=empIDx"
.dbCommonTables = "i=empIDx|sql=SELECT LastName FROM Employees"
.ASPdbNET()
End With
End Sub
</script>