Define text to display for 'Null' and also set edit criteria text to 'Is Null'.

Product Version

Property Value

Mydb.dbNullText="Any valid null Text" (Def= )

QuickProp Keyword Abbreviation

Remarks

* Null text is also used to create the appropriate sql criteria - Field is Null compare to Field = ''.

Set T.dbNullText="" for forcing SQL criteria to use Is Null in stead of blank.

Example

<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
T.dbGridMagicCell="fi=1| mac=(#Email#|IB||class=blue|#Email#~#Email#|IN|| class=Beige|#Email#)"
T.dbBlankText="A blank"
T.dbNullText="A null"
End Sub
</script>

See Also

z Class | Tornado Namespace | dbBlankText

---