Difference between revisions of "COPY DICTIONARY"
Yvonne.milne (Talk | contribs) m (1 revision) |
Helen.george (Talk | contribs) |
||
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Copy dictionary attributes to a table file | Copy dictionary attributes to a table file | ||
| − | |||
==Syntax== | ==Syntax== | ||
COPY DICTIONARY TO <.xad file> [ADDITIVE] | COPY DICTIONARY TO <.xad file> [ADDITIVE] | ||
| − | |||
==See Also== | ==See Also== | ||
| − | + | [[COPY]], [[COPY STRUCTURE EXTENDED]], [[CREATE FROM]], [[CREATE DICTIONARY]], [[DISPLAY DICTIONARY]], [[LIST DICTIONARY]], [[SET DICTIONARY]] | |
| − | + | ||
==Description== | ==Description== | ||
| Line 16: | Line 13: | ||
The .xad table is created with the following structure: | The .xad table is created with the following structure: | ||
| − | + | {| class="wikitable" width="100%" | |
| − | {| class="wikitable" | + | !widt="25%"|Field||Type||Length||width="45%"|Description |
| − | !Field||Type||Length||Description | + | |
|- | |- | ||
|XAD_TYPE||Character||3||File Type | |XAD_TYPE||Character||3||File Type | ||
| Line 33: | Line 29: | ||
|- | |- | ||
|} | |} | ||
| − | |||
The records of the tale define the ADD attributes from the source table. These may be modified using any of the standard 4GL record editing commands (EDIT, REPLACE etc) if required. | The records of the tale define the ADD attributes from the source table. These may be modified using any of the standard 4GL record editing commands (EDIT, REPLACE etc) if required. | ||
| Line 39: | Line 34: | ||
====ADDITIVE==== | ====ADDITIVE==== | ||
If the <.xad file> already exists, the ADDITIVE keyword can be used to append records. If the ADDITIVE keyword is not specified, any records in the existing <.xad file> will be overwritten. | If the <.xad file> already exists, the ADDITIVE keyword can be used to append records. If the ADDITIVE keyword is not specified, any records in the existing <.xad file> will be overwritten. | ||
| − | |||
==Example== | ==Example== | ||
| Line 47: | Line 41: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| − | [[Category: | + | [[Category:NoSQL Commands]] |
| − | [[Category: | + | [[Category:Lianja VFP Extensions]] |
| + | [[Category:VFP Command Extensions]] | ||
Latest revision as of 08:57, 5 February 2013
Purpose
Copy dictionary attributes to a table file
Syntax
COPY DICTIONARY TO <.xad file> [ADDITIVE]
See Also
COPY, COPY STRUCTURE EXTENDED, CREATE FROM, CREATE DICTIONARY, DISPLAY DICTIONARY, LIST DICTIONARY, SET DICTIONARY
Description
The COPY DICTIONARY command is used to import attributes in an Application Data Dictionary (ADD) into a table file. A new dictionary may be created by using the CREATE DICTIONARY command.
The .xad table is created with the following structure:
| Field | Type | Length | Description |
|---|---|---|---|
| XAD_TYPE | Character | 3 | File Type |
| XAD_FILE | Character | 255 | File Name |
| XAD_ID | Character | 32 | Object ID |
| XAD_OBJECT | Character | 10 | Object Type |
| XAD_SEQNO | Character | 3 | Object Value Sequence # |
| XAD_VALUE | Character | 255 | Object Value |
The records of the tale define the ADD attributes from the source table. These may be modified using any of the standard 4GL record editing commands (EDIT, REPLACE etc) if required.
ADDITIVE
If the <.xad file> already exists, the ADDITIVE keyword can be used to append records. If the ADDITIVE keyword is not specified, any records in the existing <.xad file> will be overwritten.
Example
use accounts copy dictionary to accounts
