dbOptions Property

Miscellaneous options.

Product Version

All

[Visual Basic]
Public Property dbOptions As String

[C#]
public string dbOptions {set;}

Property Value

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

Keyword	Description
Port	Allow user to customize their Port in CSS emit. See following macro http://ServerName[[port]]/
DBZ	Used in MagicCell equation to arrest divide-by-zero condition. This text will be displayed. Def=0
MagicTNInitFrame	Width,Height This is to control the init Frame size for the popup. See MagicCell for details
CloseStartUpAction	True\|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.
SingleColumnSort	True\|False(Def). Enforce Single Column Sort.
EditTitle	Title for Combo Edit display. "none" = No title.
DropFirst	First item of filter and edit drop boxes like [Select an Item] or <Select an item>.
KeepUserQueryString	Def=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

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>

z.dbOptions Property

Product Version

Property Value

QuickProp Keyword Abbreviation

Example

See Also