Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Locate and Case-Insensitive Index
Thu, Feb 13 2014 1:14 PMPermanent Link

Praveen A B

I have a table with field "company_cd" and case-insensitive index for this field.
I know that to make use of the index I have to use
Table.FilterOptions := [foCaseInsensitive] OR Table.Filter := UPPER(company_cd) = UPPER('ABC').

But, what about Table.Locate() ?
which code forces the use of the above index
Table.Locate('company_cd', 'ABC', []) OR Table.Locate('company_cd', 'ABC', [loCaseInsensitive]) ?
Fri, Feb 14 2014 9:06 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Praveen,

<< But, what about Table.Locate() ?
which code forces the use of the above index
Table.Locate('company_cd', 'ABC', []) OR Table.Locate('company_cd', 'ABC',
[loCaseInsensitive]) ? >>

The latter (loCaseInsensitive) will do what you want.

Tim Young
Elevate Software
www.elevatesoft.com
Image