Tornado API Library - V12.30.08

z.dbBoolText Property

Customize the True/False display and dropdown text.

[VisualBasic]
PublicPropertydbBoolTextAsString
[C#]
publicstringdbBoolText{set;}

Property Value

DisplayTrue| Displayfalse| DropTrue| Dropfalse

KeywordDescription
DisplayTrueText displaced when value if cell is True in display of Grid and Form. OK to use image
DisplatFalseText displaced when value if cell is False in display of Grid and Form. OK to use image
DropTrueText displaced when value if cell is True in Filter and Edit drop boxes. MUST be text and defaults to "True".
DropFalseText displaced when value if cell is False in Filter and Edit drop boxes. MUST be text and defaults to "False".

QuickProp Keyword Abbreviation

bot

Remarks

This property offers a method of replacing the True/False standard Boolean text displayed in a Boolean type cell with any user defined text or HTML tags (usually an image). The filter boolean field drop down will also conform to the 3rd and 4th parameters.

For SQL boolean fields use - Obj.dbBoolText = "DropTrue=1|DropFalse=0"

Example

[vb]
<script language="vb" runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
  Dim boo As New Tornado.Z
  With boo
    .dbQP = "u=53|S=1|D=Nwind|Ni=b5,Filter|Th=ti=BoolText"
    .dbSQL = "SELECT ProductName, Discontinued From Products"
    .dbBoolText = "DisplayTrue=<IMG src='/tornado/images-net/happyface.gif'>| 
                   DisplayFalse=<IMG src='/tornado/images-net/sadface.gif'>| 
                   DropTrue=Ya |DropFalse=Na"
    .dbFilterFlds = "0,fi=discontinued|ty=SelectBox+B|va=TF|te=TF"
    .ASPdbNET()
  End With
End Sub
</script>

See Also

z Class | Tornado Namespace