On 06/11/14 10:22 AM, Martin Schreiber wrote:
On Thursday 06 November 2014 15:43:03 Chris Dryburgh wrote:
I understand that but I don't think your approach allows for a series of
read-only queries to be run in a single transaction batch.
Why not? Activate the datasets with dso_offline, the activation of the first
dataset will start the transaction. Rollback or commit the transaction after
loading all datasets. If one later calls "applyupdates" the dataset
automatically starts a new transaction either by "transactionwrite" if
assigned or the regular "transaction" property. If dso_autocommit is set
there will be also an automatic commit.
Transaction option tao_fake is off of course.
Martin
_______________________________________________
fpc-devel maillist - [email protected]
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel
OK I suppose I had not gotten to the point of fully understanding how it
worked. Well Michael's patch should work for all databases and is close
to being put into trunk. Unless something happens porting the MSEgui
transaction handling approach to other databases should not be needed.
_______________________________________________
fpc-devel maillist - [email protected]
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel
