Umgang mit Datenbank

[mkinzler]

Am besten mit Parametern:

Delphi-Quellcode:

with DataModule2.ADOQuery1 do
  try
    Active:=false;
    SQL.Text := 'INSERT INTO Tabelle1 (feld1, Feld2) VALUE ( :w1, :w2)');
    Paramters.ParamByName( w1, 'a'); 
    Paramters.ParamByName( w2, 'b'); 
    ExecSQL;
    Paramters.ParamByName( w1, 'c'); 
    Paramters.ParamByName( w2, 'd'); 
    ExecSQL;
    ...
    DataModule2.ADOConnection1.CommitTrans;
   except
    on E:Exception do DataModule2.ADOConnection1.RollbackTrans;
   end;