- - -

- [TurboSQL]

- % -

% [TurboSQL]

- * -

* [TurboSQL]

- / -

/ [TurboSQL]

- + -

+ [TurboSQL]

- < -

< [TurboSQL]

<= [TurboSQL]

- > -

> [TurboSQL]

>= [TurboSQL]

- 6 -

64 bit

- A -

Abs [TurboPL]

access rights [TurboDB]

activation [TurboDB]

for TurboDB Managed

for TurboDB Win32

add

column [TurboSQL]

constraint [TurboSQL]

administration [TurboDB]

AES

aggregation functions [TurboSQL]

ALL keyword [TurboSQL]

alphanumeric column [TurboDB]

ALTER TABLE [TurboSQL]

AND [TurboSQL]

ANY keyword [TurboSQL]

ArcTan [TurboPL]

ARCTAN [TurboSQL]

arcus tangens [TurboSQL]

arithmetic functions and operators [TurboSQL]

Asc [TurboPL]

ASCII [TurboSQL]

ASP.NET [TurboDB]

autoinc

column [TurboDB]

Automatic Linking
Working with Link and Relation Fields

AUTOINC [TurboSQL]

autoinc column [TurboDB]

automatic linking [TurboDB]

Automatic Linking
Working with Link and Relation Fields

- B -

BETWEEN [TurboSQL]

BIGINT [TurboSQL]

BIT [TurboSQL]

blb

file extension [TurboDB]

blob column [TurboDB]

Blowfish

BOOLEAN [TurboSQL]

boolean column [TurboDB]

boolean literals [TurboSQL]

BOTH [TurboSQL]

bracketed column name [TurboSQL]

BY [TuboSQL]

BYTE [TurboSQL]

byte column [TurboDB]

- C -

CALL [TurboSQL]

CASE [TurboSQL]

CAST [TurboSQL]

catalog [TurboDB]

CEILING [TurboSQL]

CHAR [TurboSQL]

CHAR_LENGTH [TurboSQL]

CHECK [TurboSQL]

check constraint [TurboSQL]

Chr [TurboPL]

client/server [TurboDB]

CLR data type [TurboSQL]

column

add [TurboSQL]

modify [TurboSQL]

remove [TurboSQL]

rename [TurboSQL]

column correlation name [TurboSQL]

column data types [TurboDB]

column name [TurboDB]

column name [TurboSQL]

column type [TurboSQL]

CombineDateTime [TurboPL]

Command

CommandBuilder

comments [TurboSQL]

Commit method

Compact Framework

licensing issue [TurboDB]

compatibility [TurboDB]

Upgrade TurboDB Win32 v5
Upgrade to TurboDB Managed v2

between database engines

compound file [TurboDB]

Compound File Explorer

CompressDatabase method [TurboDB]

conditional execution [TurboSQL]

Connection

connection problem

TurboDB Server

connection string [TurboDB]

for database server

ConnectionString property

constraint

add [TurboSQL]

remove [TurboSQL]

CONSTRAINT [TurboSQL]

constraints [TurboSQL]

CONTAINS [TurboSQL]

CONTAINS predicate [TurboSQL]

conversion from TurboDB Win2

correlated sub-query [TurboSQL]

CORRESPONDING [TurboSQL]

Cos [TurboPL]

COS [TurboSQL]

cosine [TurboSQL]

COUNT [TurboSQL]

CREATE AGGREGATE [TurboSQL]

CREATE FULLTEXTINDEX [TurboSQL]

CREATE FUNCTION [TurboSQL]

CREATE INDEX  [TurboDB]

CREATE PROCEDURE [TurboSQL]

CREATE TABLE [TurboSQL]

CreateDatabase method

CURRENCY [TurboSQL]

CURRENT_DATE

CURRENT_TIME

CURRENT_TIMESTAMP

CurrentRecordId [TurboPL]

CURRENTRECORDID [TurboSQL]

- D -

dat

file extension [TurboDB]

Data Definition Language [TurboSQL]

Data Manipulation Language [TurboSQL]

data security

Data Security [TurboDB]

data source [TurboDB]

data type [TurboSQL]

data type mapping [TurboSQL]

data types [TurboDB]

DataAdapter

database

create

management tool [TurboDB]

TurboDB Viewer
TurboDB Workbench
TurboDB Studio

database directory [TurboDB]

database engine [TurboDB]

database file

compact [TurboDB]

compress [TurboDB]

database file [TurboDB]

database management tool [TurboDB]

database server [TurboDB]

database table

exclusive [TurboDB]

locking [TurboDB]

sharing [TurboDB]

DataReader

DataSource [TurboDB]

DataSource property

Datatype

TurboDB

DataWeb.TurboDB namespace

DataWeb.TurboDBManaged namespace

DATE [TurboSQL]

date and time

calculations [TurboSQL]

functions and operators [TurboSQL]

date column [TurboDB]

date format [TurboSQL]

DateStr [TurboPL]

datetime format [TurboSQL]

DateTimeStr [TurboPL]

DateTimeVal [TurboPL]

Day [TurboPL]

DAY [TurboSQL]

day of the week [TurboSQL]

DayOfWeek [TurboPL]

DbProviderFactory

configuration for TurboDB

DDL [TurboSQL]

DECIMAL [TurboSQL]

DECLARE [TurboSQL]

DEFAULT [TurboSQL]

default value

for column [TurboSQL]

delete

index [TurboSQL]

rows [TurboSQL]

table [TurboSQL]

DELETE Statement [TurboSQL]

deployment [TurboDB]

to Compact Framwork

to mobile device

directory database [TurboDB]

DISTINCT keyword [TurboSQL]

DIV [TurboSQL]

DML [TurboSQL]

DOUBLE [TurboSQL]

DROP [TurboSQL]

DROP AGGREGATE [TurboSQL]

DROP FUNCTION [TurboSQL]

DROP PROCEDURE [TurboSQL]

- E -

ELSE [TurboSQL]

encryption

changes [TurboDB]

Encryption [TurboDB]

encryption [TurboSQL]

engine [TurboDB]

ENUM [TurboSQL]

enum column [TurboDB]

error handling [TurboDB]

Error Handling
Error Handling in TurboDB Managed

Error in log-in

upgrade [TurboDB]

evaluation edition [TurboDB]

for TurboDB Managed

for TurboDB Win32

EXCEPT [TurboSQL]

exceptions [TurboDB]

Exchange [TurboPL]

Exclusive property

executing

stored procedure [TurboSQL]

EXISTS predicate [TurboSQL]

Exp [TurboPL]

EXP [TurboSQL]

exponential [TurboSQL]

export [TurboDB]

Expression [TurboPL]

external routine [TurboSQL]

EXTRACT [TurboSQL]

- F -

factory

for ADO.NET provider components [TurboDB]

FAQ

field type [TurboSQL]

file extensions [TurboDB]

file size

of database file [TurboDB]

files

of a TurboDB database

FillStr [TurboPL]

filter

keyword [TurboPL]

filter [TurboDB]

filter condition [TurboSQL]

FLOAT [TurboSQL]

float column [TurboDB]

FLOOR [TurboSQL]

FOREIGN KEY [TurboSQL]

formatting a number [TurboSQL]

Frac [TurboPL]

FRAC [TurboSQL]

FROM Clause [TurboSQL]

fti

file extension [TurboDB]

FULL OUTER JOIN [TurboSQL]

full-text

search-condition [TurboPL]

searching [TurboPL]

full-text index

changes [TurboDB]

create [TurboSQL]

creating [TurboDB]

repair [TurboSQL]

update [TurboSQL]

full-text index [TurboSQL]

full-text search [TurboSQL]

Function

arithmetic [TurboPL]

date and time [TurboPL]

string [TurboPL]

Function [TurboPL]

functions

date and time [TurboSQL]

Functions [TurboSQL]

- G -

GetSchemaTable method

GROUP BY Clause [TurboSQL]

Grouping [TurboSQL]

GUID

create new [TurboSQL]

GUID [TurboSQL]

guid column [TurboDB]

- H -

has [TurboPL]

HAVING Clause [TurboSQL]

hexadecimal number [TurboSQL]

hexadecimal representation

of a number [TurboPL]

HexStr [TurboPL]

HEXSTR [TurboSQL]

hijacking [TurboDB]

HOUR [TurboSQL]

- I -

id

file extension [TurboDB]

IDE

for TurboDB development

identifier

columns [TurboSQL]

identifier [TurboDB]

identity

retrieve of row [TurboSQL]

IF [TurboSQL]

IIS [TurboDB]

import [TurboDB]

in

file extension [TurboDB]

IN [TurboSQL]

IN predicate [TurboSQL]

ind

file extension [TurboDB]

index

calculated [TurboDB]

create [TurboDB]

create [TurboSQL]

delete [TurboDB]

delete [TurboSQL]

expression [TurboDB]

full-text [TurboDB]

management tool [TurboDB]

TurboDB Viewer
TurboDB Workbench
TurboDB Studio

performance [TurboDB]

repair [TurboSQL]

secondary [TurboDB]

unique [TurboDB]

update [TurboSQL]

indication [TurboDB]

Column Data Types
Automatic Linking
Working with Link and Relation Fields

indication [TurboSQL]

information schema [TurboSQL]

INNER JOIN [TurboSQL]

inr

file extension [TurboDB]

insert

rows [TurboSQL]

INSERT Statement [TurboSQL]

installation [TurboDB]

Installing TurboDB Managed
Deploying a TurboDB Managed Application

Int [TurboPL]

INT [TurboSQL]

INTEGER [TurboSQL]

INTERSECT [TurboSQL]

- J -

JOIN [TurboSQL]

- K -

key

open TurboDB table with [TurboDB]

Key [TurboDB]

- L -

language driver

large int column [TurboDB]

LEADING [TurboSQL]

LEFT OUTER JOIN [TurboSQL]

LeftStr [TurboPL]

LEFTSTR [TurboSQL]

LEN [TurboSQL]

Length [TurboPL]

length of a string [TurboSQL]

level

table [TurboDB]

license [TurboDB]

for TurboDB Managed

for TurboDB Win32

LIKE [TurboSQL]

limits [TurboDB]

link

column [TurboDB]

Automatic Linking
Working with Link and Relation Fields

LINK [TurboSQL]

link column [TurboDB]

Local SQL

localization

lock

read [TurboDB]

total [TurboDB]

write [TurboDB]

locking

table [TurboDB]

TurboDB

locking [TurboDB]

Log [TurboPL]

LOG [TurboSQL]

LONGVARBINARY [TurboSQL]

LONGVARCHAR [TurboSQL]

LONGVARWCHAR [TurboSQL]

loop

while [TurboSQL]

Lower [TurboPL]

LOWER [TurboSQL]

lower case [TurboSQL]

LTrim [TurboPL]

- M -

MAKEDATE [TurboSQL]

MAKEDATETIME [TurboSQL]

MAKETIME [TurboSQL]

managed database [TurboDB]

marshalling data types [TurboSQL]

master-detail

insert related rows [TurboDB]

MAX [TurboSQL]

memo column [TurboDB]

MemoStr [TurboPL]

migration from TurboDB Win32

Millisecond [TurboPL]

MILLISECOND [TurboSQL]

MIN [TurboSQL]

Minute [TurboPL]

MINUTE [TurboSQL]

mmo

file extension [TurboDB]

mobile device

creating application

modulo [TurboSQL]

MONEY [TurboSQL]

Month [TurboPL]

MONTH [TurboSQL]

mov

file extension [TurboDB]

multi-session [TurboDB]

multi-threading [TurboDB]

multi-user

locking [TurboDB]

TurboDB Engine Documentation
Multi-User Access and Locking
TurboDB Engine Documentation
Table Locks
See also

multi-user [TurboDB]

access

- N -

net

file extension [TurboDB]

network

optimization [TurboDB]

performance [TurboDB]

problems [TurboDB]

new features [TurboDB]

New Features in TurboDB Managed
New in TurboDB Win32 v5
New in TurboDB Managed v2

NEWGUID [TurboSQL]

NOT [TurboSQL]

Now [TurboPL]

NTimes [TurboPL]

NULLIF [TurboSQL]

Number [TurboPL]

NUMERIC [TurboSQL]

numeric column [TurboDB]

- O -

Operator

arithmetic [TurboPL]

date and time [TurboPL]

string [TurboPL]

Operator [TurboPL]

operators

date and time [TurboSQL]

Operators [TurboSQL]

optimization [TurboDB]

OR [TurboSQL]

ORDER BY Clause [TurboSQL]

OUTER JOIN [TurboSQL]

- P -

Parameter

ParameterCollection

parameters [TurboSQL]

password

open TurboDB table with [TurboDB]

Password [TurboDB]

PasswordNeeded event [TurboDB]

performance

network [TurboDB]

Pocket PC

creating application

Pos [TurboPL]

Predicates [TurboSQL]

PRIMARY KEY [TurboSQL]

programming language [TurboSQL]

Protection [TurboDB]

provider factory [TurboDB]

- Q -

query

optimization [TurboDB]

performance [TurboDB]

speed [TurboDB]

Query [TurboSQL]

quoted column name [TurboSQL]

quoted string [TurboSQL]

quotes

changes [TurboDB]

- R -

ReadOnly property

record id

query for current [TurboDB]

redo-log [TurboDB]

referential integrity [TurboSQL]

rel

file extension [TurboDB]

relation

column [TurboDB]

Automatic Linking
Working with Link and Relation Fields

RELATION [TurboSQL]

relation column [TurboDB]

remove

column [TurboSQL]

constraint [TurboSQL]

rename

column [TurboSQL]

reporting

tool [TurboDB]

reserved words

changes [TurboDB]

RIGHT OUTER JOIN [TurboSQL]

RightStr [TurboPL]

Rijndael

rmv

file extension [TurboDB]

rnt

file extension [TurboDB]

roll-back [TurboDB]

Rollback method

Round [TurboPL]

ROUND [TurboSQL]

row identity [TurboSQL]

rtr

file extension [TurboDB

RTrim [TurboPL]

- S -

sample programs [TurboDB]

Scan [TurboPL]

search-condition [TurboDB]

searching

full-text [TurboPL]

searching [TurboDB]

Second [TurboPL]

SECOND [TurboSQL]

SELECT Statement [TurboSQL]

server [TurboDB]

session [TurboDB]

SET [TurboSQL]

Sin [TurboPL]

SIN [TurboSQL]

sine [TurboSQL]

single-file database

edit storage objects

view storage objects

single-file database [TurboDB]

small int columm [TurboDB]

SMALLINT [TurboSQL]

Smartphone

creating application

SOME keyword [TurboSQL]

sorting [TurboSQL]

specification [TurboDB]

speed [TurboDB]

SQL console [TurboDB]

SQL dialect [TurboDB]

SQL for TurboDB see TurboSQL

Sqrt [TurboPL]

SQRT [TurboSQL]

square root [TurboSQL]

stored procedure

executing [TurboSQL]

stored procedure [TurboSQL]

Str [TurboPL]

STR [TurboSQL]

string column [TurboDB]

string comparison [TurboSQL]

string length [TurboSQL]

string literal [TurboSQL]

string operators and functions [TurboSQL]

sub-query [TurboSQL]

sub-select [TurboSQL]

substring [TurboSQL]

SUM [TurboSQL]

support [TurboDB]

system tables [TurboSQL]

- T -

table

alter schema [TurboSQL]

create [TurboSQL]

delete [TurboSQL]

indexing [TurboDB]

linking [TurboDB]

Automatic Linking
Working with Link and Relation Fields

locks [TurboDB]

management tool [TurboDB]

TurboDB Viewer
TurboDB Workbench
TurboDB Studio

master/detail [TurboDB]

relationship [TurboDB]

restructure [TurboSQL]

sharing [TurboDB]

TurboDB Engine Documentation
Multi-User Access and Locking
TurboDB Engine Documentation
Table Locks
See also

TABLE [TurboSQL]

table alias [TurboSQL]

table correlation name [TurboSQL]

table level [TurboDB]

table level [TurboSQL]

table name [TurboDB]

table name [TurboSQL]

TDB

tdbd

file extension

tdbd file [TurboDB]

thread [TurboDB]

time

calculations [TurboSQL]

functions and operators [TurboSQL]

TIME [TurboSQL]

time column [TurboDB]

time format [TurboSQL]

TIMESTAMP [TurboSQL]

TimeStr [TurboPL]

TimeToDateTime [TurboPL]

Today [TurboPL]

TOP keyword [TurboSQL]

tra

file extension [TurboDB]

TRAILING [TurboSQL]

transaction [TurboDB]

Transactions

TurboDB

translation

trial edition [TurboDB]

for TurboDB Managed

for TurboDB Win32

TRIM [TurboSQL]

TurboDB

datetime format

Engine

overview

products

TurboDB 4

TurboDB Data Exchange

TurboDB Managed

TurboDB Managed 1

TurboDB Native

TurboDB Server

configuration

connection problems

installation

network problems

TurboDB Studio

TurboDB Viewer

TurboDB Workbench

TurboDBCommand class

about TurboDBCommand class

all members

TurboDBCommandBuilder class

about TurboDBCommandBuilder class

all members

TurboDBConnection class

about TurboDBConnection class

all members

TurboDBConnection.CompressDatabase method

TurboDBConnection.ConnectionString property

TurboDBConnection.CreateDatabase method

TurboDBConnection.DataSource property

TurboDBConnection.Exclusive property

TurboDBConnection.PasswordNeeded event

TurboDBConnection.ReadOnly property

TurboDBDataAdapater class

about TurboDBDataAdapater class

TurboDBDataAdapter class

all members

TurboDBDataReader

Information on the TurboDBDataReader class

TurboDBDataReader class

about TurboDBDataReader class

TurboDBDataReader.GetSchemaTable method

TurboDBException class

about TurboDBException class

all members

TurboDBLockType Enumeration

TurboDBParameter class

about TurboDBParameter class

all members

TurboDBParameterCollection class

about TurboDBParameterCollection class

all members

TurboDBTransaction class

about TurboDBTransaction class

all members

TurboDBTransaction.Commit method

TurboDBTransaction.Rollback method

TurboDBType Enumeration

TurboSQL

TurboSQL Guide
SQL Dialect

aggregation functions

ALTER TABLE statement

arithmetic functions and operators

boolean literals

column names

Column Names
Column Correlation Names

comments

CREATE FULLTEXTINDEX [TurboSQL]

CREATE INDEX statement

CREATE TABLE statement

Data Definition Language

Data Manipulation Language

data types

date and time functions and operators

date format

DELETE Clause

DISTINCT keyword

DROP statement

filter condition

FROM Clause

General Functions

General Operators

General Predicates

GROUP BY Clause

Grouping

HAVING Clause

insert records

INSERT Statement

Miscellaneous Functions and Operators

ORDER BY Clause

parameters

Query

search-condition

SELECT

sorting

Statement

string operators and functions

table names

Table Names
Table Correlation Names

time format

TOP keyword

UPDATE FULLTEXTINDEX statement

UPDATE INDEX statement

update records

UPDATE Statement

vs. Local SQL

WHERE Clause

- U -

unicode string column [TurboDB]

UNION [TurboSQL]

UNIQUE [TurboSQL]

unmanaged database [TurboDB]

UPDATE FULLTEXTINDEX statement [TurboSQL]

UPDATE INDEX statement [TurboSQL]

update rows [TurboSQL]

UPDATE Statement [TurboSQL]

upgrade [TurboDB]

Upgrade TurboDB Win32 v5
Upgrade to TurboDB Managed v2

upgrading [TurboDB]

Upper [TurboPL]

UPPER [TurboSQL]

upper case [TurboSQL]

user-defined aggregate [TurboSQL]

user-defined function [TurboSQL]

user-defined procedure [TurboSQL]

- V -

validation [TurboSQL]

VARCHAR [TurboSQL]

variable

declare [TurboSQL]

set [TurboSQL]

VARWCHAR [TurboSQL]

- W -

WCHAR [TurboSQL]

Web application [TurboDB]

Week [TurboPL]

WEEK [TurboSQL]

week number [TurboSQL]

WEEKDAY [TurboSQL]

WEEKDAYNAME [TurboSQL]

WeekDayNo [TurboPL]

WHERE Clause [TurboSQL]

WHILE [TurboSQL]

wide memo column [TurboDB]

wide string column [TurboDB]

Windows Mobile

creating application

word filter [TurboPL]

- Y -

Year [TurboPL]

YEAR [TurboSQL]