Tornado API Library - V12.30.08

z.dbStartUpGoto Property

Performs a linear search to locate the first matching record from recordset on entry.

Product Version

All
[VisualBasic]
PublicPropertydbStartUpGotoAsString
[C#]
publicstringdbStartUpGoto{set;}

Property Value

Obj.dbStartUpGoto = Search format

Search format -
    # = Goto Row 15 (e.g. 15)
    P# = Goto Page 3 (e.g. P3)
    Col ? Value (e.g. 3 > 88)
    FieldName ? Value (e.g. Salary ? 123456)
    Col = String (e.g. Name = Frank)
    Col starts with 'F' (e.g. Name = f%)
    Col contains 'F' (e.g. Name = %F%)
    Col > 'F' (e.g. Name > a)
---------------------------------------------
    ? = operator (=, >, <, >=, <=, <>)
    Col = Visual Column # or Fieldname
    Col is 0 based
    Text compare is case insensitive
    Value type autodetect (S, N, D and B)

QuickProp Keyword Abbreviation

sugh

Remarks

StartUpGoto is activated in dbMode via SuperGoto=True in the second group.

Example

Firstname=Frank (Firstname='Frank')

Lastname > b

Salary>12345

Lastname=F% (LastName starts with 'F')

2=%f% (Column 2 contains 'F'- 3rd column)

Discontinued=True (Discontinued = True)

Note: Normally, the search column should be sorted.

The following example is SuperGoto -

<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
  Dim Sgt As New Tornado.z
  With Sgt
    .dbQP = "U=1| S=5| Ps=11| Gdf=0,1,2| Fhf=1,2| D=Nwind| Q=Orders|Th=Ti=Supergoto"
    .dbMode = "type=Dual-Horiz| SuperGoto=true"
    .ASPdbNET()
  End With
End Sub
</script>
The following example is StartUpGoto -
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
  Dim Sgo As New Tornado.z
   ith Sgo
    .dbQP = "U=71| S=13| M=dh| Gdf=0,1,2| Fhf=1,2| Ps=11| D=Nwind| Th=Ti=StartUpSuperGoto"
    .dbStartUpGoto = "CustomerID=B%"
    .dbSQL = "Select * From Orders ORDER BY CustomerID"
    .ASPdbNET()
  End With
End Sub
</script>

See Also

z Class | Tornado Namespace | dbMode