Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > S > SET

ANSI

Scroll Prev Top Next More

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