Extract_SI_Keys subroutine
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