Bug in defaulting checkbox in add mode

[alarabie]

When you default a checkbox in .dbEditAddFlds to true, it causes the add query to generate an additional field and causes this error "Number of query values and destination fields are not the same."

Here is an example using nwind:

<script language="vb" runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
Dim update As New Tornado.Z()
with update
.dbUnit = 90
.dbQP = "d=nwind|th=Title=DARTH Complete Information page |gdf=1,2,5,6,3,4,7,8,9"
.dbMode = "ty=grid| sysind=t"
.dbsql = "Select * from products "
.dbskin = "bluesky"
.dbfilterflds = "1,2,5"
.dbeditaddflds = "1,2,3,4,5,6,7,8,fi=9|ty=checkbox|def=true"
.dbpagesize = 14
.dbsortflds = "1,2,5,6,7"
.dbValidatorParams = "code=/tornado/Jars|entry=false"
.dbNavigationItem = "top,bottom,prev,next,filter,reload,add"
.dbBookMark = "products;0"
.ASPdbNet
end with
End Sub
</script>

The extra data field always contains a 0.

I'm using the 10/10 DLL.

[Frank]

Correct - fixed in V10.17+

FK

[alarabie]

Just tested it, works great. Thanks.