Programming environments have reserved words that you must avoid using as names in your database, as otherwise you may have problems referring to the table or field that uses the reserved word as a name. For example, in SQL, the words ORDER and SORT are reserved words.
It is recommended that you set up a list of reserved words and post it to the Base Dictionary, or to each database as it is created. This provides a secure method of preventing developers from inadvertently using a reserved word as a name on the database.
From release 4.620, when DP4 is installed it should copy a number of files of type .RWL into the directory with DP4 executables, containing reserved words for the languages most commonly used with DP4. You can use the Reserved Words (W) option on the main menu of MAKEDB to post these words to BD or to your application database.
You can also create your own additional lists of reserved words as follows:
Use a text editor to create a list of reserved words, one on each line.
On the command line, enter the command to load the Reserved words utility:
RESWORDS filenameThe reserved words are posted to the Base Dictionary (or you can use the -DB option to post the reserved words to a specified database).
Whenever you post a list of reserved words to a database, RESWORDS will warn you if one of the new reserved words has already been used as a name on the database.
you can use RESWORDS -DELETE to remove the list of reserved words from a database.