1
I am making the following query in Delphi, using Mysql:
QueryExtraiDados.Close;
QueryExtraiDados.SQL.Clear;
QueryExtraiDados.SQL.Add('Select * from clientes where nascimento='+QuotedStr('%'+antecedencia+'%')+' ');
QueryExtraiDados.Open;
Does not return anything in Delphi, if I run the following query in Mysql:
Select * from clientes where nascimento='2015/05/26'
How can I fix this?
Abs
People, already solved, was like this: Queryextraidados.Close; Queryextraidados.SQL.Clear; Queryextraidados.SQL.Add('Select * from customers Where nascimento='+Quotedstr(antecedence)+' '); Queryextraidados.Open;
– Renato Souza
Renato, please post your solution as an answer, not a comment. And since you already solved the problem, accept one of the answers as the solution to your question. It may be your own. If other answers have helped you, vote for them by clicking the up arrow, so you encourage the good answers. Hug!
– utluiz