AAM Building the Bridge to Real Content

( )

Round brackets. Are used in field size definitions in logical constucts or formulas.

Alias

Alias is an alias to the original tablename, which is used instead of the tablename.

Example:

mytable1

Fieldname

Fieldname is the name of an databasetable-field or -column in the used database table.

Example:

 preis 

Feldlist

Fieldlist is a list of fieldnames of the used database table, separated with commas.

Example:

 onum, preis, anz 

Value

Value is here a value that can be stored in the corresponding SQL data type, such as an integer, decimal number or text in "Hochkomma".

Example:

 'Berlin' 

Valuelist

Valuelist is a list of values separated with commas (see value).

Example:

 1001, 'Müller', 'Berlin', .12 

Tablename

Tablename is a name of an table existing or to be created in the database.

Example:

 torder 

Logical constuct

Locical contruct build up from values, fields und SQL-operators (AND, OR, IN, NOT, EXISTS usw.), a logical formula.

Example:

 preis > 100 AND preis < 1000 

Formula

Formula is here a fomula consisting of functions, values or fieldnames.

Example:

 ( (price * prov) - .10 )

Integer

Integer ist a number without decimals.

Example:

 17