Devart Forums

Hi

I want search in sqlite table with a key

Do i need an index or put the table in the first record?, etc

I need a little example, please.

Thanks in advance

Hello,

To search in an open DataSet, you can use the standard Locate method. http://docs.embarcadero.com/products/ra ... ocate.html

Hello AlexP

Thanks for your answer. It has helped me a lot, but my question was not clear, sorry.

I need an example to place the table in a record by finding a key and have that table sorted by that field, to continue reading table records sequentially, from the record found.

Sorry again and thanks.

In order to have the table sorted by some field(s), you can use the IndexFieldNames property of the dataset. To place the table in a record, the FindKey, Locate or LocateEx methods of the dataset can be used.
You can find more information about these methods in the LiteDAC documentation at our web-site:
http://www.devart.com/litedac/docs/deva ... dnames.htm
http://www.devart.com/litedac/docs/deva ... bject).htm
http://www.devart.com/litedac/docs/deva ... tions).htm
http://www.devart.com/litedac/docs/deva ... tions).htm