Using a key field

[jota]

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 ?

Code: Select all

tunitable.IndexFieldNames := KeyPad, KeyEle    // only this property ?
tunitable.KeyFields := KeyPad, KeyEle          // this too ?

Separator between keys in both case, comma or semicolon?

Thanks in advances

[FCS]

Hello,

Here you can find a few answers:

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

Regards
Michal

[azyk]

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.

[jota]

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

[MaximG]

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