Description

Searches a Btree index for a specified value and returns a list of keys based on the search value.

Syntax

Extract_SI_Keys (tablename, columnname, value, keylist)

Parameters

The Extract_SI_Keys subroutine has the following parameters.

ParameterDescription
tablenameThe name of the table to search.
columnnameThe name of the indexed column to search.
valueThe value to search for in columnname.
keylistReturns a value mark-delimited array of keys whose column value matches the value searched for. If no matches are found, keylist is null.

See also

Btree.Extract

Example

/* Returns the keys for rows where values in the column ORDER_NO equal 1. */
 
Extract_SI_Keys("CAR_ORDERS", "ORDER_NO", "1", KeyList)
If Get_Status(ErrCodes) Then
       GoSub ErrorHandling
End
  • No labels