Customize the True/False display and dropdown text.

dbQP Abbr: bot
Version: All

Namespace:  Tornado
Assembly:  Tornado (in Tornado.dll) Version: 12.6.0.9 (1.0.0.0)

Syntax

C#
public string dbBoolText { get; set; }
Visual Basic (Declaration)
Public Property dbBoolText As String

Field 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".

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"

Examples

CopyVB.NET
<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