From Recital Documentation Wiki
Revision as of 16:18, 10 March 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search



Table Organization


Change or deactivate the active dictionary


SET DICTIONARY ON | OFF | (<expL>) SET DICTIONARY TO [<.dbd filename> | (<expC>) ]

See Also



The SET DICTIONARY ON | OFF command enables or disables the use of Recital’s Data Dictionary (.dbd) files. By default SET DICTIONARY is ON. When SET DICTIONARY is OFF, and a table is opened that has an associated data dictionary, the data dictionary is ignored. To disable a dictionary file after the table has opened, use the SET DICTIONARY TO command.

The SET DICTIONARY TO <.dbd filename> command can be used to change the current dictionary. The filename can be substituted with an <expC>, enclosed in round brackets, which returns a valid filename. If no file extension is specified, ’.dbd’ is used. This command will change the active dictionary to the specified <.dbd filename>. The dictionary must have been created from the current table.

The dictionary file is created from the CREATE or MODIFY STRUCTURE work surface. It is created with the same basename as the table, but with a ’.dbd’ extension. To create another dictionary for the same table, the current dictionary should be copied to a new name first.

The SET DICTIONARY TO command will deactivate the current dictionary.

NOTE: SET DICTIONARY TO will not deactivate triggers or field and table protection.


set dictionary off
use customer.rdb
copy to cust2
use cust2
set dictionary to customer


Recital Database Server, Recital Mirage Server, Recital Terminal Developer