Queries

Index
Turbo Database
    Overview
    Colum Data Types
    Queries
    Operators and Functions
    Automatic Linking
TurboDB Tools
TurboDB Components
Frequently Asked Questions

[prev][next]

Overview

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

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.

[prev][next]

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.