E@DBLOCKMIDSUB

Name

The E@DBLOCKMIDSUB call has the following format:

DN@<Logical>(E@DBLOCKMIDSUB)

where <Logical> identifies the database file to use to perform the E@DBLOCKMIDSUB call.

Description

E@DBLOCKMIDSUB performs similarly to E@DBLOCKMIDRNG, but it allows for more precision in defining the range, because it lets you specify beginning and ending values on the last key field defining the range.

Using the API in a Program

E@DBLOCKMIDSUB can be used in conjunction with E@DBLOCKSUBRNG and E@DBLOCKKNXTRNG.

The database routines perform an equal condition on all D@ <Index> fields up to the subrange field designated in the E@DBSUBRNG. It performs a "where greater-than and less-than" condition on this index field.

Input Values

Field	Description
<Logical>	You must specify the database index name that you want to create a record in.
Record retrieval variables (also known as D@ fields)	Fill in the D@ fields that define the point to position at in the mid-subrange, and also initialize any other D@ fields that do not define the mid-subrange. Define the beginning and ending values of the last key by moving the appropriate values to the record retrieval fields named D#START#<KeyFieldName> (starting value) and D#END#<KeyFieldName> (ending value). This defines the range itself.
E@DBSUBRNG	Move a number into E@DBSUBRNG in order to tell the interface which key is the last significant one defining the range. This number is equivalent to the position of the field in the index.

Return Values

Field	Description
D<prefix>@NOTFOUND – or – E@KEY@FOUND	The Modify routines set D<prefix>@NOTFOUND to FALSE if a record is found, TRUE if a record is not found, or E@KEY@FOUND if the keys are found.