Delphi and Interbase

[mandarine]

Hello,
What is the difference in using "sanone" and "sacommit" in AUTOSTOPACTION propertie of ibtransaction (IBX) component?

Actually i'm using in ibtransaction settings:

read_committed
no_rec_version
wait

the properties that i'm using are:
Active=false
Autostopaction=sanone
default action=tacommit

All of this are correct to use in a network???

Thanks

 

[footpad]

CarlosProgrammer,

According to the Help file, AutoStopAction controls what happens when transactions are implicitly stopped. It says, "Transactions are implicitly stopped when AutoStopAction is not saNone and the last dataset associated with the transaction closes."

saNone indicates that transactions aren't implicitly stopped, meaning you have to stop them yourself, whereas saCommit automatically commits transactions that are implicitly stopped.

The help file also notes that the property only works with TDataSet descendants and that you should set the property to saNone if your transaction involves TIBSQL components.

As far as the correctness of use, it really depends on your application. If you're unsure that the implicit transactions are serving your needs, then you really should control the transaction explicitly. Yes, it takes more work, however, you then know exactly what's going on.

Hope this helps...

-- Lance