Topic: Method of subtracting two fields

please help
Method of subtracting two fields

2 (edited by argonx 2021-03-08 07:51:27)

Re: Method of subtracting two fields

Add calculated field and add formula:

( field1 - field2 )



Or if You need to permanently add it You will need formula

procedure frmUlazS_Button1_OnClick (Sender: TObject; var Cancel: boolean);
Begin
         SqlExecute('Update TABLE1 Set amount = amount - ' + frmUlazS.Edit2.sqlValue + ' Where id = ' + frmUlazS.ComboBox1.sqlValue);
end;