FATS - Fast Access Tree System Table of Contents List of Commands "MD" Delete Matchcode

"MD" Delete Matchcode

---

Command string:

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

FileNo	File number
RecID	Record- resp. id-number
Col#data	Contents of data column #
[ ]	Optional

Purpose:

Delete the contents of a record from the matchcode index.

Description:

This command removes the content of the data columns ("Col#data") of the specified data record ("RecID") from 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.

An result set generated before calling of this command remains unchanged from this command, i.e. can possibly contain subsequently deleted data records.

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$ = "MD\1\"+STR$(RECNO)+"\"+COL1$+"\"+COL2$

 BASIC Example

See also:

 "MI" Insert Matchcode; page 4-67

© 2008  GCS Software, Udo Gertz