.DCW STRUCTURE.......The structure of a Work (.DCW) file
OVERVIEW.............An overview of the dCLIP "Work" System
RESTORING AREAS......Restoring all work area information from a file
SAVING AREAS.........Saving all work area information to a file

.DCW STRUCTURE

The structure of a Work (.DCW) file

Description:

NOTE: The structure of .DCW files is currently undergoing re-design
for better normalization. The new structure will be simpler.
This information is provided for reference purposes for the
current version. After the structure is changed, you will be
required to convert the old to the new structure. A program
will be provided to do this.

Each record of a .DCW file contains fields whose information has a
different meaning, dependent upon the FILE_TYPE of the record.


Field Name Type Len ------------- Type of Record -------------------
---------- ---- --- -- Title -- -- E/S -- -- I -- -- R --

FILE_TYPE C 1 (empty) E or S I R
FILE_NAME C 35 Title Data Name Index Name
FILE_ALIAS C 10 Data Alias Data Alias
RELA_ALIAS C 10 Data Alias Rela Alias
FIELD1 C 10 Rela Field
FIELD2
KEY C 250 SET DEFAULT Index Key
FILTER_STR C 250 SET PATH Data Filter
RECNO C 10 # of databases Record #
DBX_BROWSE C 2 Browse .DBX #
DBX_EDIT C 2 Edit .DBX #
DBX_DICT C 2 Dict .DBX #
RDD C 10 Rdd Name
INDEX_NO N 2 Index Order
TAG_NAME C 10 Index Tag
INDEX_FOR C 250 Index Cond.
UNIQUE L 1 Unique?
DESCEND L 1 Descend?
ISCDX L 1 Combined Index?

See Also:

RESTORE WORK
SAVE WORK

OVERVIEW

An overview of the dCLIP "Work" System

Description:

The dCLIP "Work" system is similar in concept to other
data-dictionary systems or dBASE/FoxPro .VUE files. This
system allows the user to "capture" the information about all
work areas to a data dictionary for later restoring all work
areas.

Saving work area information is accomplished with the SAVE
WORK command or DC_WORKSAVE() function or from the ASSIST menu.

Restoring work area information is accomplished with the
RESTORE WORK command or DC_WORKRESTORE() function or from the
ASSIST menu.

Work area information is saved to a file with the .DCW
extension. An additional file of the same prefix name but with
the extension .DCX is also created if the open work areas also
were previously browsed or edited with the BROWSE or EDIT
commands respectively. For all work areas that are using index
files, a file name with the prefix of the alias for that work
area and a suffix of .DCT will be created for recreating index
files and tags.

Notes:

** NOTE TO BETA TESTERS **

The structure of the .DCW file is currently undergoing
re-design for better normalization and will be finalized in the
next beta release. The work system commands and functions are
not likely to change, however, your existing .DCW files will
need to be converted with a conversion program that will be
supplied.

Examples:

    . USE INVITEMS NEW INDEX INVITEMS
   
 . USE INVOICE NEW INDEX INVNMBR
   
 . SET RELATION TO INV_NMBR INTO INVITEMS
   
 . USE CUSTOMER NEW INDEX CUSTNAME, CUSTNMBR
   
 . SET RELATION TO CUST_NMBR INTO INVOICE
   
 . BROWSE TILE EDIT CASCADE
   
 . SAVE WORK TO CUSTOMER
   

   
 In the above example the following files will be created by
   
 the SAVE WORK command:
   

   
 CUSTOMER.DCW - A .DBF type file with 10 records:
   

   
      (1) Title record
   
      (3) Type "S" records for opening databases in shared mode
   
      (4) Type "I" records for opening index files
   
      (2) Type "R" records for setting relations
   

   
 CUSTOMER.DCX - An array type file with 6 records:
   

   
      (3) Browse-configuration arrays
   
      (3) Edit-configuration arrays
   

   
 INVITEMS.DCT - An index information file for INVITEMS.NTX
   
 INVNMBR.DCT - An index information file for INVNMBR.NTX
   
 CUSTNAME.DCT - An index information file for CUSTNAME.NTX
   
 CUSTNMBR.DCT - An index information file for CUSTNMBR.NTX

See Also:

RESTORE WORK
SAVE WORK

RESTORING AREAS

Restoring all work area information from a file

Description:

Restoring work area information is accomplished with the
RESTORE WORK command, DC_WORKRESTORE() function, or by
selecting "Restore Work Areas from .DCW file" from the "WORK"
sub-menu of "ASSIST".

This will accomplish the following:

* Open databases and index files using the proper RDD
(Replaceable Data Driver).
* Re-build all index files and/or tags if they do not exist.
* Restore parent-child relations.
* Restore record, index and tag pointers.
* Restore browse and edit window configurations.
* Restore filters.
* Restore Database environment such as PATH, DEFAULT, UNIQUE,
etc.

See Also:

SAVE WORK
dc_worksave()
RESTORE WORK
dc_workrestore()

SAVING AREAS

Saving all work area information to a file

Description:

Saving work area information is accomplished with the SAVE WORK
command, DC_WORKSAVE() function, or by selecting "Save Work
Areas to .DCW file" from the "WORK" sub-menu of "ASSIST".

This will accomplish the following:

* Save the names and paths of all databases, including the RDD
(Replaceable Data Driver).
* Save information about all tags and indexes so they can be
re-built if they become corrupted or deleted.
* Save parent-child relations.
* Save record, index and tag pointers.
* Save browse and edit window configurations.
* Save filters.
* Save Database environment such as PATH, DEFAULT, UNIQUE,
etc.

See Also:

SAVE WORK
dc_worksave()