SET FILETYPE

From Recital Documentation Wiki
Revision as of 15:51, 23 November 2009 by Helengeorge (Talk | contribs)

Jump to: navigation, search

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, DB_FOXPLUSBUGS, DB_FOXPROKEYS, DB_SAMBA, 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


Description

The SET FILETYPE command is used to specify a Replaceable Database Driver (RDD) to invoke when creating new database and index files. After issuing a SET FILETYPE 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 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 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 Server, Recital (None OpenVMS)