Queries

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

[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 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.