SQLMemTable: BDE Alternative Embedded
In-Memory Database with SQL for Delphi / C++Builder
Searches for an index with specified fields.
function FindIndex(FieldNamesList, AscDescList, CaseSensitivityList: TStringList): String;
Description
Call FindIndex to search for a specific index in the table.
FindIndex return name of the index that includes specified fields or empty string if ther is no such index.
FieldNamesList - TStringList object with field names.
AscDescList - TStringList object with constants SQLMem_ASC or SQLMem_DESC (unit SQLMemConst).
Each string of this list corresponds field from FieldNames list. Empty list means that all fields in index should have ascending sort order.
CaseSensitivityList - TStringList object with constants SQLMem_CASE or SQLMem_NO_CASE (unit SQLMemConst). Each string of this list corresponds field from FieldNames list. Empty list means that all string fields in index are case sensitive.
|