Difference between revisions of "CONVERT"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=CONVERT=
 
 
 
==Class==
 
Table Basics
 
 
 
 
==Purpose==
 
==Purpose==
 
Convert tables to Recital 9 format
 
Convert tables to Recital 9 format
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
[[Optimizing Indexes using SYNCNUM]], [[Upgrading from Pre-9.0 Versions]], [[USE]]
+
[[recitalconvert]], [[DISPLAY INDEXES]], [[DISPLAY STATUS]], [[LIST STATUS]], [[SET COMPATIBLE]], [[Upgrading]], [[USE]]
  
  
 
==Description==
 
==Description==
The CONVERT command, like the DBCONVERT utility in Recital Terminal Developer, can be used to convert Recital version 8.x tables to the Recital 9.0 format, to populate tables' SYNCNUM values or to convert files from other Xbase formats.  If no conversion type is specified, the default is VER90, which converts Recital version 8.x tables to the Recital 9.0 format.
+
The CONVERT command, like the ''recitalconvert'' utility, can be used to convert Recital version 8.x tables to the Recital 9.0 format or to convert files from other Xbase formats.  If no conversion type is specified, the default is VER90, which converts Recital version 8.x tables to the Recital 9.0 format.
  
 
====VER90====
 
====VER90====
 
Database tables (.dbf files) used by the Recital 9.0 and later product lines use a different file structure to previous Recital versions.  Therefore, before you can use your existing Recital data tables, they must be converted to the new file structure.  The CONVERT command can be used to convert a single specified table or multiple tables.  Wildcard characters can be used in the file specification.
 
Database tables (.dbf files) used by the Recital 9.0 and later product lines use a different file structure to previous Recital versions.  Therefore, before you can use your existing Recital data tables, they must be converted to the new file structure.  The CONVERT command can be used to convert a single specified table or multiple tables.  Wildcard characters can be used in the file specification.
  
Recital Corporation strongly recommends that you perform a full backup of your Recital applications upgrading and converting your tables.  Production tag index files are recreated by the DBCONVERT/CONVERT process, but single index files (.ndx) will need to be rebuilt manually.
+
Recital Corporation strongly recommends that you perform a full backup of your Recital applications upgrading and converting your tables.  Production tag index files are recreated by the recitalconvert/CONVERT process, but single index files (.ndx) will need to be rebuilt manually.
 
+
====INDEX====
+
The INDEX convert option processes the specified tables or all Recital 9 tables in the current directory if no filenames are specified.  It updates all the SYNCNUM values starting with 1 in the first row and adding one to the value for each subsequent row.  Any previous values stored in the rows are discarded.
+
 
+
This option will also locate any .dbx files associated with the table or tables and convert them to use SYNCNUM at the end of each index expression to optimize the index by making all the keys unique.  Character indexes have SYNCNUM added to the end of the expression.  Date indexes are converted to DTOS() and have the SYNCNUM added to the end.  Numeric indexes are not affected.
+
 
+
The SYS(14) and INDEXKEY() functions will not return the SYNCNUM if it is on the index, however DISPLAY/LIST INDEX and DISPLAY/LIST STATUS will.
+
 
+
Please see DB_INDEXSEQNO for optimizing .ndx files.
+
  
 
====DBF | FMT | FRX | MEM | PRG | TXT | FRM====
 
====DBF | FMT | FRX | MEM | PRG | TXT | FRM====
Line 67: Line 51:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]

Latest revision as of 11:11, 5 October 2010

Purpose

Convert tables to Recital 9 format


Syntax

CONVERT [VER90 | INDEX | DBF | FMT | FRX | MEM | PRG | TXT | FRM] <filename>| (<expC>)


See Also

recitalconvert, DISPLAY INDEXES, DISPLAY STATUS, LIST STATUS, SET COMPATIBLE, Upgrading, USE


Description

The CONVERT command, like the recitalconvert utility, can be used to convert Recital version 8.x tables to the Recital 9.0 format or to convert files from other Xbase formats. If no conversion type is specified, the default is VER90, which converts Recital version 8.x tables to the Recital 9.0 format.

VER90

Database tables (.dbf files) used by the Recital 9.0 and later product lines use a different file structure to previous Recital versions. Therefore, before you can use your existing Recital data tables, they must be converted to the new file structure. The CONVERT command can be used to convert a single specified table or multiple tables. Wildcard characters can be used in the file specification.

Recital Corporation strongly recommends that you perform a full backup of your Recital applications upgrading and converting your tables. Production tag index files are recreated by the recitalconvert/CONVERT process, but single index files (.ndx) will need to be rebuilt manually.

DBF | FMT | FRX | MEM | PRG | TXT | FRM

The other file formats are as follows:


File Type Description
DBF Tables and Memos
FMT Screen Format files
FRX FoxPro Report Format files
MEM Memory files
PRG Program files
TXT Text files
FRM Report Format files


Example

convert ver90 *.dbf
convert ver90 customer.rdb


Products

Recital Server, Recital