Devart Forums

Hello

I define the following index in my database:

CREATE UNIQUE INDEX "IndTreeView" ON "TreeElements" ("KeyPad" ASC,"KeyEle" ASC)

Which properties should I use in 'tunitable' component if I want to use that index with 'findkey', 'locate', etc ?
Separator between keys in both case, comma or semicolon?

Thanks in advances

Hello,

Here you can find a few answers:

http://forums.devart.com/viewtopic.php?f=28&t=32380

Regards
Michal

Server indexes are used on ordering and searching data on the server side automatically, for example, on executing clauses WHERE, ORDER BY, etc. Client can't use server indexes. Therefore, when using local ordering and search (methods IndexFieldNames, Locate, etc..), we don't use server indexes. TUniTable has no such methods, that could allow using server index on the client side.

Hello

Thank you both for the answers

Sorry, I´m using Sqlite database. The previous answer about the indexes is it right for this db?

Thanks

You are absolutely right. The previous answer is applicable to SQLite as well.