On Sat, Oct 22, 2011 at 11:21 AM, <michael.vancann...@wisa.be> wrote: > >> >> DBComm.SQLTransaction.StartTransaction; <-- Fails here with >> "transaction already active" > > Correct. The default transaction is made active after connecting. > You should call StartTransaction on this transaction only after a commit or > rollback.
I also found this problem when I migrated from Zeos to SQLdb. Only SQLdb works in this way. IMHO, it not make sense. For automatic transactions, the user can define AutoCommit=True If it is False, I can call StartTransaction BEFORE the Commit. That is the way that all libs work. Marcos Douglas _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal