TurboIMAGE/XL Database Management System Reference Manual (30391-90012)

Chapter 5 181
TurboIMAGE/XL Library Procedures
DBFIND
The other is for modes 4 and 24, which requires a structured format as
follows:
Bytes Meaning
1-2 Type of generic search. An ASCII character pair is in this
field:
=*
search for key values equal to argument1 (similar to a
DBFIND mode 1)
<*
search for key values less than argument1
<=
search for key values less than or equal to
argument1
>*
search for key values greater than argument1
>=
search for key values greater than or equal to
argument1
[ ]
search for key values greater than or equal to
argument1 AND less than or equal to argument2
@c wildcard search when the wildcard character is c.
Scan argument for the first wildcard character c. If a
wildcard character is found in position n, 1-based,
search for keys that match first n−1 characters of
argument.
If c is non-blank and non-null, then it is the wildcard
character that will be used. Some examples are: @*
and @@.
If c is a blank or null, then the one set by DBCONTROL
mode 15, if any, is used. Otherwise, the current
default wildcard character (stored in the root file) is
used. The wildcard character is changeable via the
DBUTIL SET command or DBCONTROL mode 15.
PK
Partial Key search. Search for key values that
match
n characters in argument1 (n is length of
argument1 provided in bytes 4 and 5 described
later). Argument1 need not contain a wildcard. If
it does within the
n characters, it will be
considered as one character part of the search
value. For example, if n is 4, argument1 is
ABC@, and the wildcard to be used is @,
DBFIND
will return records containing ABC@ as the first
four characters in the key value.
* indicates a space character.