|
-
Frank, thanks for the help, but I just worked around it for now. I have another issue with GridEditUpdate and GridUpdate though.
if you notice, gridupdate (mult update) has more fields listed than editupdate (single update), but when you execute, the same fields are listed.
Any thoughts???
Thanks
John M
see example below
-------------------------------------------------------------
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
'Field ordinals -> 0=OrderID; 1=CustomerID; 2=EmployeeID; 3=OrderDate; 4=RequiredDate; 5=ShippedDate;6=ShipVia;7=Freight
Dim X As New tornado.z()
X.dbQP = "U=1|S=15|M=Ty=Grid!SysInd=t|D=Nwind|ni=b5,upd ate, gridupdate|Q=Orders|Th=Title=Grid Edit| bm=orders;0+1|gdf=0,1,2,3,4,Freight"
X.dbEditUPDATESQL = "(|UPDATE Orders SET Freight=[[7]] WHERE OrderID={{0}}"
X.dbEditGridUPDATESQL = "(|UPDATE Orders SET OrderDate=#[[3]]#, RequiredDate=#[[4]]#, ShippedDate=#[[5]]# WHERE OrderID={{0}}"
X.dbEditUpdateFlds = "fi=0|type=RONOUPDATE,Freight"
X.dbEditGridUpdateFlds = "fi=0|type=RONOUPDATE,fi=OrderDate|type=radio|val= { {0-1}}|def=1,RequiredDate,ShippedDate"
X.dbDebug = "EditSetup,EditAction"
X.dbEditGridUpdate = True
X.ASPdbNET()
End Sub
</script>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|