Do not use reserved words or any shorter forms of them as names for columns, tables, or views. As a rule, if the word is a reserved word, R:BASE will flag it. R:BASE will not allow you to use a reserved word as a column or table name, but this MAY NOT always be the case. For example in the table designer, R:BASE may not warn you about REF, short for REFERENCES, but REF will not be allowed in a command file. If a particular column or table is giving you problems, please check out the list below and consider all shortened versions of the words listed here.
The following is a list of all reserved words.
#DATE #PI #TIME ADA ADD ALL AND ANY AS ASC ASCII AT AUTHORIZE AUTONUMBER AVERAGE AVG BEGINS BETWEEN BLINKING BOTH BY CASCADE CHARACTER CHECK CMDHIST COLUMNS CONSTRAINT CONTAINS CONTINUE COUNT CURRENT CURSORS DATA DBCONN DECIMAL DESC DISTINCT DUPLICATE END ENDC EQ ESCAPE EXCEPT EXECUTE EXISTS EXPLAIN FAILS FILL FLOAT FOR FOUND FROM FULL GE GO GOTO GROUPED GT HAVING IN INDEX INDICATOR INTO IS KEY KEYBOARD LAG LANGUAGE LAST |
LE LEAD LIKE LIMIT LISTREL LT MAX MAXIMUM MIN MINIMUM MODULE MPW NE NOCHECK NOFILL NONE NONUM NOT NULL NUM OF OFF ON OPTION OR ORDER OUTER OVER OWNER PARTITION PLI PRECISION PRINTER PRIVILEGE PROCEDURE PUBLIC READ REFERENCES RPW SCHEMA SCREEN SECTION SELECT SMALLINT SOME SORTED SOUNDS_LIKE SQLCODE SQLERROR STATICVAR STDEV STRUCTURE SUM TABLE TABLES TEMPORARY TERMINAL TJOURNAL TO UNION UNIQUE USING VALUES VARIANCE VIEWS WHERE WITH WORK |
Of the above, the following are new reserved words added with the release of R:BASE 11.
•CMDHIST
•STATICVAR
•EXPLAIN
•DBCONN
•TJOURNAL
