Difference between revisions of "SET FILETYPE"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
Xbase Compatibility | Xbase Compatibility | ||
| Line 26: | Line 23: | ||
The SET COMPATIBLE command has no effect on the format of files created in Recital products. | The SET COMPATIBLE command has no effect on the format of files created in Recital products. | ||
| + | |||
By default SET FILETYPE TO uses native Recital file formats. | By default SET FILETYPE TO uses native Recital file formats. | ||
NOTES: | NOTES: | ||
| − | |||
| − | + | * The dynamic RDDs are not available in Recital products for OpenVMS. | |
| + | |||
| + | * Access to other Xbase file formats via the RDDs requires extra system resources, due to the binary conversions required to access the data. This can result in performance degradation, particularly on large database files. | ||
==Example== | ==Example== | ||
| − | < | + | <code lang="recital"> |
use state.rdb | use state.rdb | ||
set filetype to clipper | set filetype to clipper | ||
| Line 41: | Line 40: | ||
use state_pc | use state_pc | ||
index on STATE to state_pc | index on STATE to state_pc | ||
| − | close</ | + | close</code> |
Revision as of 08:40, 16 April 2009
Class
Xbase Compatibility
Purpose
Table and index file creation in Xbase formats.
Syntax
SET FILETYPE TO [RECITAL | DBASE3 | DBASE4 | DB4 | FOXBASE | FOXPRO | FOXPLUS | CLIPPER | VFP]
See Also
COPY, CREATE, EDITFIELD(), FILETYPE(), INDEXEXT(), SET CLIPPER, SET CLIPPER5, SET COMPATIBLE, SET EDITFIELD, SET FILECASE, SET INDEXEXT, SET MEMOEXT, SET PCEDIT, SET PCEXACT, SET PCFILTER, SET PCGRAPHICS, SET PCKEYS, SET PCLOCKING, SET PCPICTURE, SET PCSAYS, SET PCUNIQUE, DB_FOXPLUSBUGS, DB_FOXPROKEYS, DB_SAMBA
Description
The SET FILETYPE TO command is used to specify a Replaceable Database Driver (RDD) to invoke when creating new database and index files. After issuing a SET FILETYPE TO command, all database, index and memo files created will be in the native Xbase format specified.
The Recital DBMS supports dynamic RDDs that allow transparent read/write access to database, memo and index files created in other Xbase languages. Access to these files is independent of the SET FILETYPE TO command.
Regardless of the file type used, the Recital Applications Data Dictionary (ADD) may still be used. When an Xbase database file is opened, the Recital RDD will look in the current directory for a file of the same name, but with a ’.dbd’ extension. If this file exists, it will be attached and all ADD attributes will be applied to the table.
The SET COMPATIBLE command has no effect on the format of files created in Recital products.
By default SET FILETYPE TO uses native Recital file formats.
NOTES:
- The dynamic RDDs are not available in Recital products for OpenVMS.
- Access to other Xbase file formats via the RDDs requires extra system resources, due to the binary conversions required to access the data. This can result in performance degradation, particularly on large database files.
Example
use state.rdb set filetype to clipper copy to state_pc use state_pc index on STATE to state_pc close
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer (None OpenVMS)
