10-03-2022, 01:06 AM
PHP كود :
procedure TForm1.BtnSaveClick(Sender: TObject);
begin
with Table1 do
begin
Edit;
FieldByName('sum').AsFloat:= strtofloat( edtSubTotal2.Text);
post;
end;
end;
procedure TForm1.dsTable1DataChange(Sender: TObject; Field: TField);
begin
with QryCalcul do
begin
Close;
SQL.Clear;
SQL.Add('SELECT SUM(sum) AS AmountP from Table1');
SQL.Add('where ID = :Cod');
parameters.ParamByName('Cod').Value := Table1ID.Value ;
Open;
edtSubTotal1.Text :=FormatFloat('###,###,##0.00', FieldByName('AmountP').Asfloat);
end;
end;
procedure TForm1.dsTable2DataChange(Sender: TObject; Field: TField);
begin
with QryCalcul do
begin
Close;
SQL.Clear;
SQL.Add('SELECT SUM(price) AS AmountT from Table2');
SQL.Add('where UserID = :Cod');
parameters.ParamByName('Cod').Value := Table2UserID.Value ;
Open;
edtSubTotal2.Text :=FormatFloat('###,###,##0.00', FieldByName('AmountT').Asfloat);
end;
end;
end.


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