Operating Condition
Syntax: SET ANSI ON/OFF
Default: ON
Set ANSI to OFF to allow R:BASE to accept the reserved words shown in the lists below.
The following "Command" names are allowed when ANSI is OFF:
•ABORT
•ALTER
•APPEND
•ASSIGN
•ATTACH
•AUTOCHK
•AUTONUM
•BACKUP
•BEEP
•BREAK
•BROWSE
•BUILD
•CALL
•CASCADE
•CASE
•CD
•CHANGE
•CHDIR
•CHDRV
•CHKDSK
•CHOOSE
•CLEAR
•CLOSE
•CLOSEWIN
•CLS
•CODELOCK
•COMMENT
•COMMIT
•COMPUTE
•CONNECT
•CONTINUE
•CONVERT
•COPY
•CREATE
•CREATEOB
•CROSSTAB
•DATE
•DEBUG
•DECLARE
•DEFAULT
•DEFF
•DEFINE
•DELETE
•DELETEOB
•DETACH
•DIALOG
•DIR
•DISCONNE
•DISPLAY
•DRAW
•DROP
•ECHO
•EDIT
•ELSE
•ENDIF
•ENDSW
•ENDWHILE
•ENTER
•ERASE
•EXIT
•EXPAND
•EXPRESS
•FCONVERT
•FETCH
•FILLIN
•FLUSH
•GATEWAY
•GET
•GETPROPE
•GOTO
•GRANT
•IF
•INPUT
•INSERT
•INTERSEC
•JOIN
•LABEL
•LAUNCH
•LBLPRINT
•LISTATT
•LOAD
•MAXIMIZE
•MD
•MENU
•MIGRATE
•MINIMIZE
•MKDIR
•MOVE
•NEXT
•NOECHO
•NORMALIZE
•OPEN
•OUTPUT
•ON
•PACK
•PASSTHRO
•PAUSE
•PLAYBACK
•PLUGINS
•PRNSETUP
•PROCESSM
•PROJECT
•PROPERTY
•PUT
•QBE
•QUERY
•QUIT
•RBAPP
•RBBEDIT
•RBDEFINE
•RBEDIT
•RBLABELS
•UPGRADE
•RBSYNC
•RD
•RECALC
•RECORD
•RECOVER
•REDEFINE
•REFF
•RELOAD
•REMOVE
•RENAME
•RESTORE
•RETURN
•REVOKE
•RMDIR
•ROLLBACK
•RPHONE
•RUN
•RUNRBA
•SATTACH
•SCONNECT
•SDETACH
•SDISCONN
•SELECT
•SET
•SETFOCUS
•SHOW
•SKIP
•SNAP
•SSQL
•STDCALL
•SUBTRACT
•SWITCH
•TALLY
•TILE
•TRACE
•TURBO
•TYPE
•UNION
•UNLOAD
•UPDATE
•USER
•VIEW
•WHENEVER
•WHILE
•WRITE
•ZIP
The following "Status" names are allowed when ANSI is OFF:
•AND
•ANSI
•AUTOCOMM
•AUTOCONV
•AUTODROP
•AUTOSKIP
•AUTOSYNC
•AUTORECO
•AUTOROWV
•AUTOUPGR
•BELL
•CAPTION
•CASE
•CASEP
•CENTURY
•CGA
•CHARACTE
•CHECKPRO
•CLEAR
•CLIPBOAR
•CMPAUSE
•COLCHECK
•COLLATEC
•COLLATE
•COLOR
•COMPATIB
•CURRENCY
•DATE
•DEBUG
•DIALOG
•ECHO
•EDITOR
•EOFCHAR
•EQNULL
•ERROR
•ESCAPE
•EXPAND
•EXPLODE
•FASTLOCK
•FASTFK
•FEEDBACK
•FILES
•FIRST
•FIXED
•FOLD
•FORMAT
•HEADINGS
•IDQUOTES
•INDEXONL
•INSERT
•INTENSIT
•INTERVAL
•JSORT
•KEYMAP
•LAYOUT
•LCFOLD
•LINES
•LOCK
•LOOKUPS
•MANOPT
•MAXTRANS
•MDI
•MENU
•MESSAGES
•MIRROR
•MOUSE
•MULTI
•NAME
•NAMEWIDT
•NOCALC
•NOTE_PAD
•NULL
•OFFMESS
•OLDLINE
•ONELINE
•OPTIONS
•PAGELOCK
•PASSTHRO
•POINTER
•POSFIXED
•PREFIX
•PRINTER
•PROCEDUR
•PROGRESS
•PROMPT
•QUALCOLS
•RBADMIN
•RBGSIZE
•RECYCLE
•REFRESH
•REVERSE
•ROWLOCKS
•RULES
•SELMARGI
•SERVER
•SCRATCH
•SEQUENCE
•PAGEMODE
•SHORTNAM
•SORT
•SORTMENU
•STARTUP
•STATICDB
•SUFFIX
•TABSIZE
•TIME
•TIMEOUT
•TOLERANC
•TRACE
•TRANSACT
•UINOTIF
•USER
•USERAPP
•UTF8
•VERIFY
•VERSION
•WAIT
•WALKMENU
•WHILEOPT
•WIDTH
•WINAUTH
•WINBEEP
•WRITECHK
•WRAP
•YEAR
•ZERO
•ZOOMEDIT
The following "Keyword" names are allowed only when ANSI is OFF:
•ADA
•ADD
•ANY
•AS
•ASC
•ASCII
•AT
•AUTHORIZE
•AUTONUMBER
•AVG
•BEGINS
•BETWEEN
•BLINKING
•BOTH
•BY
•C
•CASCADE
•CHARACTER
•CHECK
•COBOL
•COLUMNS
•CONSTRAINT
•CONTAINS
•CONTINUE
•CURSORS
•DATA
•DECIMAL
•DESC
•DISTINCT
•DUPLICATE
•END
•ENDC
•EQ
•ESCAPE
•EXCEPT
•EXECUTE
•EXISTS
•FAILS
•FILL
•FLOAT
•FORTRAN
•FOUND
•GE
•GO
•GOTO
•GROUPED
•GT
•HAVING
•INDEX
•INDICATOR
•INTO
•IS
•KEY
•KEYBOARD
•LAG
•LANGUAGE
•LE
•LEAD
•LIKE
•LISTREL
•LT
•MAX
•MIN
•MODULE
•MPW
•NE
•NOCHECK
•NOFILL
•NONE
•NONUM
•NULL
•NUM
•OF
•OFF
•ON
•OPTION
•ORDER
•OWNER
•PASCAL
•PLI
•PRECISION
•PRINTER
•PRIVILEGES
•PROCEDURE
•PUBLIC
•READ
•REFERENCES
•RPW
•SCHEMA
•SCREEN
•SECTION
•SELECT
•SMALLINT
•SOME
•SORTED
•SOUNDS_LIKE
•SQLCODE
•SQLERROR
•STRUCTURE
•TABLE
•TABLES
•TERMINAL
•TO
•UNION
•UNIQUE
•USING
•VALUES
•VIEWS
•WITH
•WORK
There is also a set of keywords which have special meaning when parsing commands, like the SELECT command and CREATE TABLE command. Many of the keywords are actually allowed when ANSI is off, but to use them as column names in a SELECT, the word must be identified as a name and not as a keyword. This is performed by enclosing the word in the IDQUOTES characters. As an example: SELECT Claim, `Check`, Bank FROM Activity
The following "Keyword" names are allowed only when ANSI is OFF, but need IDQUOTES around the word to be used as column names:
•ADD
•ANY
•AS
•AT
•BETWEEN
•BY
•CASCADE
•CHECK
•CONSTRAINT
•CONTAINS
•DISTINCT
•EQ
•ESCAPE
•EXISTS
•FAILS
•GE
•GROUPED
•GT
•HAVING
•IS
•KEY
•LE
•LIKE
•LT
•NE
•NULL
•ON
•ORDER
•REFERENCES
•SELECT
•SOME
•SORTED
•SOUNDS_LIKE
•UNION
•UNIQUE
•USING
•WITH
In addition, the following keywords are allowed regardless of the ANSI setting, but need IDQUOTES around the word to be used as column names:
•ATT
•CASE
•COLUMN
•DEFAULT
•FALSE
•FOREIGN
•INNER
•JOIN
•LEFT
•PRIMARY
•RIGHT
•TOP
•TRIGGER
•TRUE
•USER