View source for CREATE FROM

From Recital Documentation Wiki

← CREATE FROM

You do not have permission to edit this page, for the following reason:

---

You can view and copy the source of this page:

==Class== Table basics ==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: {| class="wikitable" !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== <code lang="recital"> use patrons copy structure extended to patstru close patrons create newpatron from patstru </code> ==Products== Recital Database Server, Recital Mirage Server, Recital Terminal Developer [[Category:Documentation]] [[Category:Commands]] [[Category:Table Basics]] [[Category:Table Basics Commands]]

Return to CREATE FROM.