Tornado API Library - V12.30.08

z.dbEditAllowZeroLength Property

Set blank values to '' or null in Edit SQL.

Product Version

All
[VisualBasic]
PublicPropertydbEditAllowZeroLengthAsBoolean
[C#]
publicbooldbEditAllowZeroLength{set;}

Property Value

Mydb.dbEditAllowZeroLength = "True | False(Def)"

QuickProp Keyword Abbreviation

eazl

Remarks

This boolean property is for Editing operations. If your table/fields allows zerolength fields then a blank '' will be used in the SQL (field='') when this property is set to true. Otherwise a 'null' will be used. The default is to use 'null' (field=null). This is one of those tiny option that can break you if you do not have it.

See Also

z Class | Tornado Namespace | Special Topic - Edit