Normal & Grid Edit

Edit#ProductIDProductNameSupplierIDDiscontinued
goupdate 1 1 vvbvcbcbcbii 1
goupdate 2 2 Chang55dd 1
goupdate 3 3 Syrddu 1
goupdate 4 4 Chef Anton's Cajun Seasoning 2
goupdate 5 5 asdf 2

bottom next goreload gogridupdate

[1 - 5 : 81]

Edit - Boolean field with Default
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim Ed As New Tornado.z
  With Ed
    .dbQP = "U=1|S=10|M=G!sys=t!Rowedit=t|D=NWIND|Q=Products|gdf=0,1,2,discontinued|" _
      & "Bm=products;0|Ni=b5,Update,GridUpdate|egu=t|ega=t|Th=Ti=Normal & Grid Edit"
    .dbE ditAddFlds = "1, fi=Discontinued|Ty=CB|Def=t"
    .dbEditGridAddFlds = "1, 2, fi=Discontinued|Ty=CB|Def=f"
    .dbEditUpdateFlds = "fi=0|Ty=RONOUP, 1, fi=Discontinued|Ty=CB|Def=t"
    .dbEditGridUpdateFlds = "fi=0|Ty=RONOUP, fi=Discontinued|Ty=CB|Def=f"
    .ASPdbNET()
  End With
End Sub
</script>

The example illustrates Editing a boolean field with a 'default value' in normal and Grid mode. It looks trivial but no so easy to accomplish with other tools.

Send comments on this topic.
Copyright (c) 1998-2006 ASP-db