Difference between revisions of "CREATE FROM"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
Line 1: Line 1:
==Class==
 
Table basics
 
  
  

Revision as of 13:46, 23 October 2009


Purpose

Create a table from the contents of another table


Syntax

CREATE <filename1> | (<expC1>) FROM <filename2> | (<expC2>)


See Also

COPY, COPY STRUCTURE, COPY STRUCTURE EXTENDED, CREATE, SET CLIPPER


Description

The CREATE FROM command creates a new table, determined by the contents of a table created with the COPY STRUCTURE EXTENDED command. The filenames can be substituted with a <expC1>, enclosed in round brackets, which returns a valid filename. The FROM table consists of five fields, these are:


Field Type Width Description
FIELD_NAME Character 32 Field name
FIELD_TYPE Character 1 Data type of field
FIELD_LEN Numeric 3 Width of field
FIELD_DEC Numeric 3 Number of decimal places
FIELD_DES Character 25 Field Description


Each record of the FROM table defines a field. The structure of the new table, <filename1>, will be created from these field definitions.


Example

use patrons
copy structure extended to patstru
close patrons
create newpatron from patstru


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer