1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
| FDConnection1.TxOptions.AutoCommit:=False; // obligatoire pour Firebird
with FDScript1.SQLScripts do begin
Clear;
with Add do begin
Name := 'root';
SQL.Add('@Audi');
SQL.Add('@BMW');
SQL.Add('@Erreur');
SQL.Add('@ter');
end;
with Add do begin
Name := 'Audi';
SQL.Add('INSERT INTO Brands VALUES (1, ''Audi'');');
SQL.Add('INSERT INTO Brands VALUES (3, ''Audi bis'');');
end;
with Add do begin
Name := 'BMW';
SQL.Add('INSERT INTO Brands VALUES (2, ''BMW'');');
SQL.Add('INSERT INTO Brands VALUES (4, ''BMW bis'');');
end;
with Add do begin
Name := 'ter';
SQL.Add('INSERT INTO Brands VALUES (5, ''Audi ter'');');
SQL.Add('INSERT INTO Brands VALUES (6, ''BMW ter'');');
end;
with Add do begin
Name := 'Erreur';
SQL.Add('INSERT INTO Brands VALUES (1, ''Audi'');');
end;
end;
FDScript1.ValidateAll;
FDConnection1.StartTransaction;
if FDScript1.ExecuteAll then FDConnection1.Commit
else begin
showmessage(inttostr(fdscript1.TotalJobSize));
fdConnection1.Rollback;
end;
FDConnection1.TxOptions.AutoCommit:=True; |
Partager