可不可能同時使用兩個 Transaction ? (同一個 Connection )

dbExpress 及 ADO 均可以但也要看後台 Database 支不支援    以下節錄 Help File :    StartTransaction method (TSQLConnection) Initiates a new transaction in the associated database. Delphi syntax: procedure StartTransaction(TransDesc: TTransactionDesc); Description Call StartTransaction to start a new transaction against a database server that supports transactions. (MySQL servers do not support transactions.) You can check the TransactionsSupported property to determine whether the server supports transactions. If the server does not support transactions, StartTransaction does nothing. TransDesc describes the transaction you are starting. It lets you specify A user-defined transaction identifier. If the server supports nested or overlapped transactions, you can initiate multiple transactions by calling StartTransaction and providing each transaction with its own unique identifier. The transaction isolation level. This indicates the degree to which this transaction can see?changes made by other transactions. If the transaction is successfully started, StartTransaction sets the InTransaction property to true. Updates, insertions, and deletions that take place after a call to StartTransaction are enlisted in that transaction until another overlapping transaction is started or until the application calls Commit to save the changes or Rollback to cancel them. Tip: If the server does not support multiple transactions, check the status of the InTransaction property to be sure that another transaction is not already in progress. Tip: When working with overlapped transactions, you can indicate the transaction to which a dataset belongs by setting its TransactionLevel property to the transaction identifier you assign in this method. ------------------------------------ BeginTrans method (TADOConnection) initiates a new transaction in the associated database. Delphi syntax: function BeginTrans: Integer; Description Call BeginTrans to start a new transaction in the data store the ADO connection component is connected to. BeginTrans returns a value of type integer, indicating the nesting level of the new transaction. A successful execution of BeginTrans triggers an OnBeginTransComplete event and sets the InTransaction property to true. Note: The ADO connection object must have an active connection before BeginTrans can be used.

引言: 可不可能同時使用兩個 Transaction ? (同一個 Connection )

不知這是不是您要的... Database1.ApplyUpdates([Query1, Query2]) 利用TDatabase元件進行ApplyUpdates 若成功則一起Commit 若一個失敗則一起Rollback ~小弟淺見，參考看看~

謝謝 channel 不過這不是我要的，到是如 Justmade 所說的 ，只是我還沒試成功