You must review all table and column names to be sure that no invalid names are defined and no reserved words are used.
In the current version, a 1-18 character alpha-numeric name must be specified for a column. Spaces are NOT permitted. Valid names must start with an alpha character and can include the following symbols:
•Letters (A-Z)
•Numbers (0-9)
•_ (underscore)
•# (pound sign) *
•$ (dollar sign) *
•% (percent sign) *
*Note: For ODBC compliance, it is NOT recommended to use the #, $, or % even though R:BASE permits it.
Review your table and column names that may begin with a number. Check for any characters that are not supported like a question mark "?" or a greater than character ">".
Also review your table and column names to verify that no reserved words are used. These words, commands, keywords, and other names are to be used exclusively by the R:BASE database. Names used by System Tables, System Views and System Columns are also reserved words. As a rule, all words beginning with "SYS" are reserved.
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
If you are still using a legacy version of R:BASE, it is recommended that you perform these table and column name changes in that version. After making the table and column names changes, R:BASE will update the form, report, and label column objects with the appropriate new name. However, if any of the columns and tables are listed in the form, report, and label variable expressions, you must manually edit these expressions.
On paper, record any table and column name changes. Later in the conversion process when you're updating your command files, you will need to make these necessary name changes for the command files as well.
