GridEditUpdate & def=

[Frank]

check the following to see whether it makes sense.... we'll set the shippeddate with a def = today...

'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,5,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,fi=ShippedDate|type= TEXT|def=Now()"
X.dbEditGridUpdateFlds = "fi=0|type=RONOUPDATE,OrderDate,RequiredDate,fi=Sh ippedDate|type=TEXT|def=Now()"
X.dbDebug = "EditSetup,EditAction"
X.dbEditGridUpdate = True
X.ASPdbNET()

[johnmooney]

I was just using that date field as an example to show that the def= does not work for a bit field.

I need the def=1 because I'm using as a 'lock record' mechanism that makes the record leave that particular user's desktop once it is locked.

John M

[Frank]

there is a 'discontinued' field in NWIND product table. See whether you can make a valid example out of it to show it breaks.

FK

[Frank]

I got the Discontinued example going. Will check it a bit more and send to you...send me a private email so I can return.

FK