DBSelectIndex

FILEFLEX API REFERENCE

NAME

DBSelectIndex -- Make a specified index file active

SYNTAX

DBSelectIndex(tagName)

CATEGORY

Using Index Files

DESCRIPTION

THIS FUNCTION HAS CHANGED IN FILEFLEX 3.0

DBSelectIndex makes a particular tag (or sort order) current inside an index file. Obviously, then, to select the tag, you need to make sure the index file has been previously opened with DBUseIndex or DBUse (with automatic indexes).

To select the tag, call DBSelectIndex with the name of the tag. This is different from earlier versions of FileFlex where the index to be used was specified by an ID number. Now, since there are multiple sort orders (called "tags") in index files, the sort order to be used is specified by the name of the tag (a string).

FileFlex returns to physical record order from index/tag order by passing an empty string to DBSelectIndex.

NOTES

Indexes are tied to their original data files. As such, you must have the appropriate data file selected with a DBSelect function before calling DBSelectIndex. Failure to do so usually results in FileFlex generating an error code, the user calling technical support, and said user being told to read this section one more time.

EXAMPLE

put DBSelectIndex("BYNAME") into dbResult

SEE ALSO

DBUseIndex, DBSelect

INTERNAL FUNCTION NUMBER

Casa de Bender