+---------------------------------+
|     COPY STRUCTURE EXTENDED     |
+---------------------------------+
COPY TO <file> STRUCTURE EXTENDED

-----------------------------------
Copies database structure to records in a new database.
-----------------------------------

The field structure of the currently selected database is copied into
database records in the TO <file> with this command.  The TO file is
created, and its contents are determined by the structure of the
currently selected database.  The TO <file>'s structure is fixed in
format and consists of four fields.  The names of the four fields and
their contents are:

FIELD_NAME      Field names from database
FIELD_TYPE      Field Type
FIELD_LEN       Width of Field
FIELD_DEC       Number of decimal places

After any desired modifications are made to the newly created TO <file>
the resulting database may then be used to create a new database file
using the CREATE FROM command.

+---------------------------------+
|         Program Example         |
+---------------------------------+
USE items
COPY STRUCTURE EXTENDED TO temp
USE temp
APPEND BLANK
REPLACE field_name WITH 'allcost'
REPLACE field_type WITH 'N'
REPLACE field_len WITH 10
REPLACE field_dec WITH 2
CREATE backup FROM temp
USE backup
APPEND FROM items
REPLACE ALL allcost WITH quantity * price

-----------------------------------

See Also:  CREATE FROM

-----------------------------------