ClientDataSet Locate

[Henry Olive 5]

Good Day,

Delphi 10.3
My Table looks like below

ID

ABC-0001

ABC-0002

ABC-0003

 

Is there a way to Locate a record just with last characters

For Example

SearchText := '0002'

CDS1.Locate ('ID', QuotedStr(SearchText), [LoPartialKey]);

Above Locate code doesnt works !
 

Thank You

 

 

[Lajos Juhász 293]

You would have to use filter, locate of partialkey always starts at the first letter (matches the beggining of the value).

[Henry Olive 5]

Thank You Lajos