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
Transaction with(out) Statements
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.
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.