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
|
procedure TF_Main.AddExportStatus(DealID: integer; FileName: string);
var
ADOUp : TADOQuery;
begin
ADOUp := TADOQuery.Create(Application);
try
ADOUp.Active:=false;
ADOUp.Connection := ADOConnectionParams;
ADOUp.Active := True;
ADOUp.SQL.Text := Format(RS_SQL_AddExportStatus, [DealID, QuotedStr(FileName)]);
ADOConnectionParams.BeginTrans;
try
ADOUp.ExecSQL;
ADOConnectionParams.CommitTrans;
except
On E:Exception do
begin
ADOConnectionParams.RollbackTrans;
MessageDlg(E.Message, mtWarning, [mbOk], 0);
end;
end;
finally
ADOUp.Free;
end;
end; |
Partager