ADO SQL UPDATE

[DeddyH]

Und so?

Delphi-Quellcode:

ADOQuery1.SQL.Text := 'UPDATE Profil SET Anrede = :geschlecht,'+
'Vorname = :vorname,'+
'Nachname = :nachname,'+
'Alter = :birthday,'+
'Strasse = :strasse WHERE Profil_ID = :id';
ADOQuery1.Parameters.ParamByName('geschlecht').Value := geschlecht;
ADOQuery1.Parameters.ParamByName('vorname').Value := vorname.Text;
ADOQuery1.Parameters.ParamByName('nachname').Value := nachname.Text;
ADOQuery1.Parameters.ParamByName('birthday').Value := birthday;
ADOQuery1.Parameters.ParamByName('strasse').Value := strasse.Text;
ADOQuery1.Parameters.ParamByName('id').Value := main_win.profil_ID;
ADOQuery1.ExecSQL;