Jump to content
Henry Olive

ClientDataSet Locate

Recommended Posts

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

 

 

Share this post


Link to post

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

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×