Difference between revisions of "CONVERT"
Helengeorge (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 8: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[DB_INDEXSEQNO]], [[ | + | [[DB_INDEXSEQNO]], [[recitalconvert]], [[DISPLAY INDEXES]], [[DISPLAY STATUS]], [[DTOS()]], [[INDEX]], [[INDEXKEY()]], [[LIST INDEXES]], [[LIST STATUS]], [[Optimizing Indexes using SYNCNUM]], [[SET COMPATIBLE]], [[Upgrading]], [[USE]] |
==Description== | ==Description== | ||
| − | The CONVERT command, like the | + | The CONVERT command, like the ''recitalconvert'' utility, 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==== | ====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 | + | 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==== | ====INDEX==== | ||
Revision as of 14:41, 16 December 2009
Contents
Purpose
Convert tables to Recital 9 format
Syntax
CONVERT [VER90 | INDEX | DBF | FMT | FRX | MEM | PRG | TXT | FRM] <filename>| (<expC>)
See Also
DB_INDEXSEQNO, recitalconvert, 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 recitalconvert utility, 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 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
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
