Locating a string containing a single quote '

NoComprende · Post by **NoComprende** » Tue 29 Apr 2008 07:58

I'm not really affected by this problem but thought you might like to know

Suppose SearchStr=="DON'T" then the following works OK

Query->Locate(SearchFld,SearchStr,TLocateOptions()LocateEx(SearchFld,SearchStr,TLocateExOptions()<<lxNearest);

Antaeus · Post by **Antaeus** » Tue 29 Apr 2008 09:43

Thank you for the information, we will investigate this issue.

Dimon · Post by **Dimon** » Mon 05 May 2008 07:57

This behaviour is not connected with a single quote contained in a string.
When the IxNearest option is set, LocateEx moves the cursor to a specific record in a dataset or to the first record in the dataset that is greater than the values specified in the KeyValues parameter. At that the dataset must be sorted by KeyFields. The sorting can be set with the IndexFieldNames property.