13-03-2016, 07:33 AM
كود :
begin
if ADoquery1.Active then
ADoquery1.Close;
ADOquery1.SQL.Text := 'SELECT SUM(x) AS TOTAL '
+ 'FROM Tablename '
+ 'WHERE Id = '+dbedit.text ;
ADOquery1.Open;
ShowMessage('Total : ' + ADOquery1.FieldByName('TOTAL').asString);
end;

![[-]](https://delphi4arab.net/forum/D4A2020/collapse.png)