How to goto nearest?

[charin]

I would like to search for nearest but following command it not working.
Anyone have solution for this?

with MyTable1 do begin
SetKey;
FieldByName('Company').AsString:=edSearch.text;
GotoNearest;
end;

[AlexP]

hello,

There is no GoToNearest method in MyDAC. Instead of it, you should use the Locate or LocateEx method.

Code: Select all

MyTable1.Locate('Company',edSearch.text,[]);

[cybsistemas]

include memdata.dcu in the uses
MyTable1.LocateEx('Company',edSearch.text,[lxNearest])

[charin]

Thanks, cybsistemas & AlexP it work very well.

[AlexP]

hello,

If you have any other questions, feel free to contact us.