The options loCaseInsensitive and loPartialKey of the locate method in the SQLdb doesn't work correctly.
Original Reporter info from Mantis: BraveDOG
-
Reporter name: Carlos Valente
Original Reporter info from Mantis: BraveDOG
- Reporter name: Carlos Valente
Description:
The options loCaseInsensitive and loPartialKey of the locate method in the SQLdb doesn't work correctly.
In the KeyPress event of the object TDBGrid, typing the letter B, it is not the first word that start with that letter (eg, Bruno),
but if there is one name B (only), he finds him.
Steps to reproduce:
procedure TfrmPrestadores.grdDadosKeyPress(Sender: TObject; var Key: char);
begin
DM.tbPrestadores.Locate('Nome', key, [loCaseInsensitive,loPartialKey]);
end;
Additional information:
The database I'm using is MySQL 5.
The version of Lazarus that I'm using is 0.9.29;