R:BASE 11 Help

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

•PRINT

•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