Devart Forums

if i trace my database-traffic i encounter the following situation:

SQLTransaction Begin 2466650 53 x MGPC01
SQLTransaction Commit 2466650 53 x MGPC01
RPC:Completed exec sp_executesql N'UPDATE Patient ...
SQLTransaction Begin 2466718 53 x MGPC01
SQLTransaction Commit 2466718 53 x MGPC01
RPC:Completed exec sp_executesql N'UPDATE Patient ...

why are there SQLTransactions Beginns and Commits, but no Statement in it? Why is there no Transaction around the statements ?

thanks for helping me understanding this

We couldn't reproduce the situation.
Please send us a complete small test project to reproduce the situation; it is desirable to use Northwind or Master schema objects, otherwise include definition of your own database objects; don't use third party components

Also supply us following information
- Exact version of Delphi.
- Exact version of DbxSda. You can see it history.html.
- Exact version of Microsoft SQL Server and OLE DB provider that you use.
You can see it in version info of SQLOLEDB.DLL and SQLNCLI.DLL.