Difference between revisions of "CREATE FROM"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
Table basics
 
 
 
 
==Purpose==
 
==Purpose==
 
Create a table from the contents of another table
 
Create a table from the contents of another table
Line 48: Line 44:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 +
[[Category:Table Basics]]
 +
[[Category:Table Basics Commands]]

Latest revision as of 15:33, 10 November 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 Server, Recital