Devart Forums

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);

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

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.