Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

Thu, Feb 13 2014 1:14 PM	Permanent 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 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. 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