Normal & Grid Edit

Edit#ProductIDProductNameSupplierIDDiscontinued
goupdate 1 132 aaaa
goupdate 2 133 2225
goupdate 3 134 MIcKE
goupdate 4 135 myold
goupdate 5 138 mydb

bottom next goreload gogridupdate

[1 - 5 : 104]

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