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
|
var
Qry:TIBquery;
no_facture,mt_ttc:string;
_database:TIBDatabase;
Transaction1:TIBTransaction;
begin
MessageDlg('test2', mtWarning, [mbOK], 0);
DMTactile.NewQry(Qry);
with qry do
begin
if Active then close;
SQL.Clear;
SQL.Add('update ENTETES_RESA set CDE_ACTIF= ''N'' '
+ ' where cde_codresa = :codresa and cde_noenreg = :noenreg and cde_nbnuits =:nbnuits ') ;
ParamByName('codresa').AsFloat := codresa_;
ParamByName('noenreg').Asinteger := noenreg_;
Parambyname('nbnuits').AsInteger := nbnuits_ ;
//ParamByName('cde_actif').AsString:=tactif;
ExecSQL;
MessageDlg('Essai commit', mtWarning, [mbOK], 0);
Transaction1.Commit;
//Commit;
Close;
end;
DMTactile.DestroyQRY(Qry)
end; |
Partager