Command CREATE FROM Foundation
Creates and opens a new database from a structure extended file.
CREATE <cDbFile> FROM <cStructFile> ; [ALIAS <cAlias>] ; [VIA <cDbeName>] ; [NEW]
The command CREATE FROM uses the field definitions from the structure extended file <cStructFile> to create a new database named <cDbFile>. This new file is opened after it is created. If the option NEW is specified, the file is opened in a free work area.
A structure extended file has at least four fields. Each record contains information about the fields of a separate database file. The following table lists the fields which must be available in a valid structure extended file:
|Field name||Field type||Field length||Decimal places|
If additional fields are included in the structure extended file, they are ignored by CREATE FROM.
Contrary to dBase or CA Clipper, the length of the field FIELD_LEN is not 3 but 5. The length of a character field with more than 999 characters can be entered directly and no longer needs to be encoded using the decimal places FIELD_DEC.
The functional equivalent of CREATE FROM is DbCreateFrom().
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.