Symbian
Symbian Developer Library

SYMBIAN OS V9.4

Feedback

[Index] [Previous] [Next]


Supported SQL subset

[Top]


add-column-set

add-column-set : add-column-spec | ( add-column-spec-comma-list )

[Top]


add-column-spec

add-column-spec : column-identifier data-type

[Top]


boolean-factor

boolean-factor : [ NOT boolean-primary ]

[Top]


boolean-primary

boolean-primary : predicate | ( search-condition )

[Top]


boolean-term

boolean-term : boolean-factor [ AND boolean-term ]

[Top]


column-definition

column-definition : column-identifier data-type [ NOT NULL ]

[Top]


column-identifier

column-identifier : user-defined-name

[Top]


column-value

column-value : literal | NULL

[Top]


comparison-operator

comparison-operator : < | > | <= | >= | = | <>

[Top]


comparison-predicate

comparison-predicate : column-identifier comparison-operator literal

[Top]


data-type

data-type : BIT | [ UNSIGNED ] TINYINT | [ UNSIGNED ] SMALLINT | [ UNSIGNED ] INTEGER | COUNTER | BIGINT | REAL | FLOAT | DOUBLE [ PRECISION ] | DATE | TIME | TIMESTAMP | CHAR [ (n) ] | VARCHAR [ (n) ] | LONG VARCHAR | BINARY [ (n) ] | VARBINARY [ (n) ] | LONG VARBINARY

[Top]


date-literal

date-literal : #{exact date expression}#


Note:

Valid date and time expressions are those which can be parsed by the Parse() member function of the TTime class.

[Top]


digit

digit : 0 | 1 | 2 | ... 8 | 9

[Top]


drop-column-set

drop-column-set : column-identifier | ( column-identifier-comma-list )

[Top]


index-name

index-name : user-defined-name

[Top]


letter

letter : a | b ... y | z | A | B ... Y | Z

[Top]


like-predicate

like-predicate : column-identifier [ NOT ] LIKE pattern-value

[Top]


literal

literal : string-literal | numeric-literal | date-literal

[Top]


null-predicate

null-predicate : column-identifier IS [ NOT ] NULL

[Top]


numeric-literal

numeric-literal : {exact numeric types}


Note:

Valid numeric forms are those which can be parsed by the Val(TInt64&) and Val(TReal&) member functions of the TLex class.

[Top]


pattern-value

pattern-value : string-literal


Notes:

Non SQL-standard characters in the pattern value are used as wildcards:

Standard SQL uses the underscore (_) and percent (%) characters respectively.

[Top]


predicate

predicate : comparison-predicate | like-predicate | null-predicate

[Top]


search-condition

search-condition : boolean-term [ OR search-condition ]

[Top]


select-list

select-list : * | column-identifier-comma-list

[Top]


sort-specification

sort-specification : column-identifier [ ASC | DESC ]

[Top]


string-literal

string-literal : '{character}'


Note:

Character strings can contain any text character. A single quote character (') can be embedded by using two single quote characters.

[Top]


table-name

table-name : user-defined-name

[Top]


update-column

update-column : column-identifier = column-value

[Top]


user-defined-name

user-defined-name : letter [ letter | digit | _ ]...