Tornado API Library - V12.30.08

z.dbOptions Property

Miscellaneous options.

Product Version

All
[VisualBasic]
PublicPropertydbOptionsAsString
[C#]
publicstringdbOptions{set;}

Property Value

Obj.dbOptions = "parm=value, parm=value"

KeywordDescription
Port Allow user to customize their Port in CSS emit. See following macro

http://ServerName[[port]]/

DBZUsed in MagicCell equation to arrest divide-by-zero condition. This text will be displayed. Def=0
MagicTNInitFrameWidth,Height

This is to control the init Frame size for the popup. See MagicCell for details

CloseStartUpActionTrue|False(Def). Close/Retain the StartUp Action dialog in the normal display after the action is completed. For example, after startup filter is done, the filter screen will be be displayed.
SingleColumnSortTrue|False(Def). Enforce Single Column Sort.
EditTitleTitle for Combo Edit display. "none" = No title.
DropFirstFirst item of filter and edit drop boxes like [Select an Item] or <Select an item>.
KeepUserQueryStringDef=False. Use this to enable/disable the user carry over variables after first entry. Always use this option unless you need to use the query values throughout your application. In that case it is better to use a session varibale. Any single quote characters in the user querystring will mess up form submits.

QuickProp Keyword Abbreviation

op

Example

.dbSQL = "SELECT Budget, Expense, 'dummy' as Spent From Expense.Csv"
.dbGridMagicCell = "fi=2|mac=<<(#Budget#-#Expense#)/#Budget#:p>>"
.dbOptions = "DBZ=No Budget"
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim CS As New Tornado.z
With CS
   .dbQP = "U=12| S=17|Gdf=0,1,2,3,4| D=Nwind| Q=Orders| Th=tit=Single Column Sort"
   .dbSortFlds = "0,1,2,3"
   .dbSortColLeftJustify = True
   .dbOptions = "SingleColumnSort=true"
   .ASPdbNET()
End With
End Sub
</script>
The following example overrides the system Edit title.
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim CS As New Tornado.z
  With CS
    .dbQP = "U=2||D=NWind|Gdf=01,1,2,3|Th=Ti=Employee Table!EditTitle=<h3>" & _
      "My Big Title<h3>|ni=b5,update| Bm=employees;0"
    .dbSQL = "Select * From employees"
    .dbOptions = "EditTitle = My Small Title"
   .ASPdbNET()
End With
End Sub
</script>
The following example illustrates filter drop with dropfirst.
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim Mydb As New Tornado.z
 With Mydb
    .dbQP = "U=6| S=France| D=nwind| ni=none|th=Ti=Grid Filter, LookUp, DropFirst"
    .dbMode = "Ty=Grid| FilterStart=t"
    .dbSQL = "SELECT OrderID, CustomerID, Freight From Orders"
    .dbCommonTables = "Index=CID| Q=Select DISTINCT CustomerID From Orders"
    .dbFilterFlds = "Fi=CustomerId| Ty=SB| Val=CID"
    .dbOptions = "Dropfirst=&lt;Select an Item&gt;"
    .ASPdbNET()
  End With
End Sub
</script>

See Also

z Class | Tornado Namespace | dbSortFlds | dbMagicCell | dbSkin | Get_UQ