Devart Forums

I have a multi-thredded application and would like to take full control of transactions.
This is the scenario.
Thread 1: Start Transaction, execute a set of SQL commands, Commit transaction
Thread 2: Start Transaction, execute another set of SQL commands, Commit Transaction

I am sharing the same TMSConnection component. When thread 2 is running, executing "commit transaction" will commit for both threads.

Is there a way of assigning SQL statements to a specific Transaction?
I have experience with Interbase/Firebird where SQL components have a property linking it to a specific transaction component.

Thanks

Salim

SDAC doesn't support such functionality, because, unlike InterBase, SQL Server doesn't support parallel transactions. You should use some connections (TMSConnection components) to create some parallel transactions.

Thanks for the info. I am still learning about MsSQL.
Best Regards
Salim