Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 2 of 2 total |
Locate and Case-Insensitive Index |
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 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |