 |
Supported
SBL Keywords
The Superbase ODBC driver was designed to be able
to support a subset of the key words and operators from the
Superbase Basic Language (SBL) when used in field-level constants,
calculations, and validations.
The following key words are supported (and cannot
be used as field names):
| AND |
ASC |
CHR$ |
| DATE$ |
DAY |
DAY$ |
| DAYS |
FCASE$ |
FN |
| FN alpha |
FN ansi |
FN ext |
| FN ibm |
FN name |
FN oem |
| FN path |
FN root |
HRS |
| IF |
LCASE$ |
LEFT$ |
| LEN |
LIKE |
LOOKUP |
| LTRIM$ |
MID$ |
MINS |
| MOD |
MONTH |
MONTH$ |
| NOT |
NOW |
OR |
| PAD$ |
PI |
REM |
| REPLICATE |
RIGHT$ |
SECS |
| SER |
SPACE$ |
STR$ |
| THOUSECS |
TIME$ |
TIMEVAL |
| TODAY |
TRIM$ |
UCASE$ |
| USERNAME |
VAL |
YEAR |
Also the following binary operators are supported:
+, -, *, /, ^, MOD,=, <>, >, <,
>= , <=, LIKE.
|
Legal Notice
