At 04:32 AM 15-01-01 +0000, you wrote:

>--- In IBObjects@egroups.com, "Jason Wharton" <jwharton@i...> wrote:
>
> > As for the transaction behavior with ASTA. If you are using an
>explicit
> > TIB_Transaction object you need to ensure that you are committing
>it so that
> > changes are saved.
>
>So I don't need a TIB_Transaction for the components that I use? If
>I don't specify one, it uses the default. Does that mean that all
>SQL operations are commited as soon as they are executed? (with
>default?)
>
>Would it be better to explicitly start a transaction and commit it.
>I am a little confused if your statement "If you are using an
>explicit TIB_Transaction object" means that for all of the IB objects
>I have specified a TIB_Transaction or if it means that for each time
>I execute an SQL statement that I explicitly start a transaction and
>then either commit it or roll it back.

You can do MyDataset.IB_Transaction.StartTransaction to take explicit
control of the <default>, if you are not using an IB_Transaction dropped in
from the component palette. As soon as you do this, AutoCommit is disabled
until the transaction ends...note that with CommitRetaining, AutoCommit
stays False.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________