Difference between revisions of "CONVERT"

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

Revision as of 13:18, 23 October 2009


Purpose

Convert tables to Recital 9 format


Syntax

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


See Also

DB_INDEXSEQNO, Dbconvert, DISPLAY INDEXES, DISPLAY STATUS, DTOS(), INDEX, INDEXKEY(), LIST INDEXES, LIST STATUS, Optimizing Indexes using SYNCNUM, SET COMPATIBLE, Upgrading, USE


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.

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 DBCONVERT/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

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 Database Server, Recital Mirage Server, Recital Terminal Developer