Topic: Использование SQLExecute UPDATE
Подскажите, как тут правильно использовать команду UPDATE:
procedure frmGholovna_button_zminyty_dvs_OnClick (Sender: string; var Cancel: boolean);
var
dvs: string;
kod_dvs: string;
bank_dvs: string;
mfo_banku_dvs: string;
rakhunok_dvs: string;
begin
dvs := frmGholovna.dvs.Text;
kod_dvs := frmGholovna.kod_dvs.Text;
bank_dvs := frmGholovna.bank_dvs.Text;
mfo_banku_dvs := frmGholovna.mfo_banku_dvs.Text;
rakhunok_dvs := frmGholovna.rakhunok_dvs.Text;
SQLExecute('UPDATE dvs SET dvs = "'+ dvs +'", SET kod_dvs = "'+ kod_dvs +'", SET bank_dvs = "'+ bank_dvs +'", SET mfo_banku_dvs = "'+ mfo_banku_dvs +'", SET rakhunok_dvs = "'+ rakhunok_dvs +'" WHERE (id = 1)');
end;