ODBC What Is Supported?

What Is Supported?

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.

Copyright © 1999 Superbase Developers plc, Cambridge, UK, All rights reserved worldwide.

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