With TIBODatabase, you just have to issue a StartTransaction and the
inherited AutoCommit which is probably used, is suspended and
your transaction is awaiting a Commit to complete or Rollback
to undo itself.

----- Original Message -----
From: "eddressel" <eddressel@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, December 18, 2008 7:27 AM
Subject: [IBO] not post transactions until requested


>I use a TIBODatabase for my connection and use the default transaction.
>
> I create TIB_DSQL objeects and execute the SQL to update values in a
> table. But I want to not post the transactions until the user presses
> 'Save' (where I call .commit). Right now I see in the monitor log that
> COMMIT RETAINING is automatically sent to the server
>
> Can I make the server wait until I explicitly call Commit?
>
> TIA,
>
> Ed Dressel
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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 !
> Yahoo! Groups Links
>
>
>