Same connection - many transactions

[Jeweller]

Hello,
Is it possible, within the same UNIConnection (Oracle / MSSQL provider) object, to have different and distinct transaction ? I mean I would like to setup for the same connection, two different channel of transation (like if I have two connection, but I would like to avoid to do this, too expensive).

Example:
Query1, Query2, Query3 on TransationBlue
QueryA, QueryB, QueryC on TransactionRed

So I can
TransationBlue.startTrans
TransationRed.startTrans
Q1.exec
QA.exec
TransationRed.commit
TransationRed.starttrans
Q2.exec
QB.exec
TransationRed.commit
TransationBlue.commit

Is it possible, If so how ?
regards

[azyk]

UniDAC (Oracle and SQL Server) has no support for multiple transactions for a single TUniConnection instance. Therefore, you should use a separate TUniConnection instance for each TUniTransaction instance.