I don't know what query.resolve does
but the rest of it seems pretty clear. the autocommit question was asked and
answered just this week I think.
autocommit commits the transaction after every update/delete or insert. if
you want that, then you don't need to commit manually.
if you want to be able to rollback your transaction, then you have to manage
your commit actions yourself and thus you cannot have autocommit set to
true.

Alan

-----Original Message-----
From: Christophe Rozec <c.rozec@...>
[mailto:c.rozec@...]
Sent: Tuesday, 14 January 2003 12:46 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Explicit Transaction problem


Hi to all,

I am working with Ibo Components for the database connection and
kbmMW components for the main application.
My problem comes with the Ib_Transaction component , it is configured
like this :

AutoCommit True
Isolation tiCommitted
LockWait False
RecVersion True
ServerAutoCommit True

i need to apply updates to the database, by using this type of code :

KbmQuery.Resolve;

here I get this Error : "Explicit Trans not Allowed wih
ServerAutoCommmit"
By Setting ServerAutoCommit to False, it works, but i would like to
leave it to True.
Does Someone have an idea ?
what does the property ServerAutoCommit involve ?

Thanks,

Christophe ROZEC
titelive




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/