Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread How I can made a compound index?
Wed, Jul 22 2009 4:52 AMPermanent Link

Norbert Stellberg
Hello,
I have 2 Database fields: Name and prename
How I can made an index with this database fields?
For example:
DBTable1.IndexDefs.Add('Name'+'prename','Name',[ixCaseInsensitive]);

with best regards
Norbert
Wed, Jul 22 2009 6:05 AMPermanent Link

"Eduardo [HPro]"
Norbert

> I have 2 Database fields: Name and prename
> How I can made an index with this database fields?
> For example:
> DBTable1.IndexDefs.Add('Name'+'prename','Name',[ixCaseInsensitive]);

Just separate fields with semi colon like the example below:

DBTable1.IndexDefs.Add('Name;prename','Name',[ixCaseInsensitive]);

Note: Does not matter the datatype of the fields.

Eduardo


Image