SQLMemTable: BDE Alternative Embedded
In-Memory Database with SQL for Delphi / C++Builder


TSQLMemTable.FindIndex
TSQLMemTable
Top 

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.



© AidAim Software SQLMemTable: In-memory Sql Database Delph