FATS - Fast Access Tree System
Table of Contents
List of Commands
"MI" Insert Matchcode

"MI" Insert Matchcode


Command string:

CMND$ = "MI\{FileNo}\{RecID}\{Col1data}[\{Col2data}[\{Col3data}]]"

FileNoFile number
RecIDRecord- resp. id-number
Col#data Contents of data column #
[ ]Optional

Purpose:

Insert the contents of a record into the matchcode index.

Description:

This command inserts the content of the data columns ("Col#data") of the specified data record ("RecID") into the matchcode index.

The position of the data columns within the command string ("Col#data") corresponds to that with the call of command Create Matchcode File (MC) determined definition. The syntax of the command string corresponds to that of the  Build Matchcode (MB) command.

NOTE: If you want to change the content of a data record that has already been indexed, its previous content (before modification) must at first be removed from the matchcode index with the  Delete Matchcode (MD) command before the new content is inserted with this command.

In the case of recreation or reorganisation of the matchcode index file, the "Build Matchcode" command should be used instead of this command by reasons of speed.

If a primary key was defined during the generation of the matchcode index file (flag "K#:#"), the record number specified via "RecID" then has no importance, i.e. the primary key must be specified (via "Col#data") as with the "MB"-command.

This command is only supported by the extended version of FATS.

Parameters returned:

ERRORCODE:Errorcode or 0 (no error)
RECNO:Undefined
FATSKEY:Undefined

Example:

CMND$ = "MI\1\"+STR$(RECNO)+"\"+COL1$+"\"+COL2$

 BASIC Example

See also:

 "MB" Build Matchcode; page 4-52
 "MC" Create Matchcode File; page 4-55


 

© 2008  GCS Software, Udo Gertz