EPUB | CHM | PDF

Example: SetKey, GotoNearest

Top Previous Next

To set cursor to row in which City field begins with 'Santa':

with MySQLTable1 do
begin
  SetKey;
  FieldByName('State').AsString := 'CA';
  FieldByName('City').AsString  := 'Santa';
  GotoNearest;
end;

See also: TMySQLTable.SetKey, TMySQLTable.GotoNearest methods