Index
TurboDB Components
TTdbDataSet
TTdbTable
TTdbBatchMove
Turbo Database
Overview
Colum Data
Types
Queries
Operators and
Functions
Working with Indexes
Automatic Linking
Working with Link and
Relation Fields
Shared Tables
Table Locks
Data Security
TurboDB Tools
TurboDB
Workbench
TurboDB Data Exchange
dataWeb
Builder
Visua
Data Publisher
Frequently Asked Questions
TurboDB comes with its own simple but powerful query language. If you are using the TurboDB Delphi components you employ search-conditions in the Filter property and in the Locate method of the TTdbTable component. If your are building Web applications with dataWeb Builder you need search-conditions in calls of SearchByCondition.
Search-Conditions are boolean expression like in SQL or in Pascal. These are some examples of TurboDB search-conditions:
Name is 'Smith'
Name = "Smith"
Name like 'Smi*'
Name like 'Smit?'
Name has "mit"
Name[3] = 'i'
LeftStr(Name, 2) = "Sm"
Length(Name) > 4
Amount = 13546.45
Amount less 13546.46
Amount < 345,67 or Amount > 567,89
Amount1 * 0.3 > Amount2 * 0.8
Date-of-birth = 20/4/1962
Date-of-birth < 20/4/1962
Date-of-birth from 4/1/1962 upto 4/30/1962
Year(Date-of-birth) < Year(Now)
Name, Amount, Amount1, Amount2 and Date-of-birth are table columns. Single and double quotes can be used equally. TurboDB offers powerful functions and operators for use in search-conditions, e.g. like, from...upto, LeftStr, Year and many others. Refer to Operators and Functions for a complete reference. Comparisons can be combined using the logical operators and, or and not.
Last updated on 11/19/2000. Copyright (c) 2000 by dataWeb GmbH, Aicha, Germany. Turbo Database and TurboDB Components are products by dataWeb - the manufacturers of RAD tools for the Web. Please send your hints, questions and comments to Peter Pohmann.