Difference between revisions of "SET DICTIONARY"

From Recital Documentation Wiki
Jump to: navigation, search
(Example)
Line 33: Line 33:
  
 
==Example==
 
==Example==
<pre>
+
<code lang="recital">
 
set dictionary off
 
set dictionary off
 
use customer.rdb
 
use customer.rdb
 
copy to cust2
 
copy to cust2
 
use cust2
 
use cust2
set dictionary to customer</pre>
+
set dictionary to customer</code>
 
+
  
 
==Products==
 
==Products==

Revision as of 04:24, 12 March 2009

SET DICTIONARY

Class

Table Organization


Purpose

Change or deactivate the active dictionary


Syntax

SET DICTIONARY ON | OFF | (<expL>)

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


See Also

CREATE, MODIFY STRUCTURE


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 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.


Example

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

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer