Difference between revisions of "SET DICTIONARY"
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Change or deactivate the active dictionary | Change or deactivate the active dictionary | ||
| − | |||
==Syntax== | ==Syntax== | ||
| Line 7: | Line 6: | ||
SET DICTIONARY TO [<.dbd filename> | (<expC>) ] | SET DICTIONARY TO [<.dbd filename> | (<expC>) ] | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[ | + | [[ALTER TABLE]], [[CREATE DICTIONARY]], [[CREATE TABLE]], [[DISPLAY DICTIONARY]], [[LIST DICTIONARY]] |
| − | + | ||
==Description== | ==Description== | ||
| Line 17: | Line 14: | ||
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 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 SET DICTIONARY TO command will deactivate the current dictionary. | The SET DICTIONARY TO command will deactivate the current dictionary. | ||
NOTE: SET DICTIONARY TO will not deactivate triggers or field and table protection. | NOTE: SET DICTIONARY TO will not deactivate triggers or field and table protection. | ||
| − | |||
==Example== | ==Example== | ||
| Line 33: | Line 27: | ||
set dictionary to customer</code> | set dictionary to customer</code> | ||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|DICTIONARY]] | [[Category:Set_Commands|DICTIONARY]] | ||
Revision as of 08:47, 10 February 2012
Contents
Purpose
Change or deactivate the active dictionary
Syntax
SET DICTIONARY ON | OFF | (<expL>)
SET DICTIONARY TO [<.dbd filename> | (<expC>) ]
See Also
ALTER TABLE, CREATE DICTIONARY, CREATE TABLE, DISPLAY DICTIONARY, LIST DICTIONARY
Description
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 SET DICTIONARY TO command will deactivate the current dictionary.
NOTE: SET DICTIONARY TO will not deactivate triggers or field and table protection.
Example
set dictionary off use customer.rdb copy to cust2 use cust2 set dictionary to customer
