1 Topic by Serhij (edited by Serhij 2014-12-05 09:29:44)

  • Registered: 2014-10-21
  • Posts: 89

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;
  • Registered: 2014-02-14
  • Posts: 10,294

Re: Использование SQLExecute UPDATE

SQLExecute('UPDATE dvs SET dvs = "'+ dvs +'", kod_dvs = "'+ kod_dvs +'", bank_dvs = "'+ bank_dvs +'", mfo_banku_dvs = "'+ mfo_banku_dvs +'", rakhunok_dvs = "'+ rakhunok_dvs +'" WHERE (id = 1)');
Dmitry.
  • Registered: 2014-10-21
  • Posts: 89

Re: Использование SQLExecute UPDATE

Спасибо.