Index
Turbo Database
Overview
Colum Data Types
Queries
Operators and
Functions
Automatic Linking
TurboDB Tools
TurboDB Components
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 6/2/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.