Connecting a variable to a ADOQuery.SQL.Text (Access)

[MelodyRogueAngel]

Hi how do you connect a certain ADOQuery.SQL.Text value to a variable? Here's an example however it's wrong:

...
Var
sAnimal, sNumber : String;
...
sNumber := edtNumber.text;
sAnimal := ADOQuery.SQL.Text := 'Select Name_Of_Animal From Animals Where Number = ' + sNumber;
...

 

[imex]

Hi,

Try something like that:

ADOQuery.Close;
ADOQuery.SQL.Text := 'Select Name_Of_Animal From Animals Where Number = ' + edtNumber.text;
ADOQuery.Open;
if ADOQuery.IsEmpty then
    ShowMessage('Animal not found')
else
    ShowMessage(ADOQuery.FieldByName('Name_Of_Animal').AsString);

Hope this helps.

[URL unfurl="true"]http://www.imoveisemexposicao.com.br/imoveis-venda-são_paulo-residencial-apartamento[/url]

 

[MelodyRogueAngel]

Thanx it worked like a charm!