Searches the dataset for a specified record and makes that record the current record.function Locate(const KeyFields: String; const KeyValues: Variant; Options: TLocateOptions): Boolean; override; ADOTable1.Locate('Company;Contact;Phone', VarArrayOf(['Sight Diver', 'P', '408-431-1000']), [loPartialKey]);
ADOQuery1.Lookup()
loCaseInsensitive 大小写是否敏感
loPartialKey 部分匹配ADOQuery1.Lookup()// 这个是不行的,他不移动光标
ADOTable1.Locate('Company;Contact;Phone', VarArrayOf(['Sight Diver', 'P', '408-431-1000']), [loPartialKey]);
对头,只能找
ADOTable1.Locate('字段','你想要的值',[loPartialKey]);定位