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.
| Parameter | Description |
|---|---|
| tablename | The name of the table to search. |
| columnname | The name of the indexed column to search. |
| value | The value to search for in columnname. |
| keylist | Returns 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
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
