Subject Re: further understanding of transactions in IBO
Author Scronkey
Thanks for your reply Jason.
For particular reasons, I need the entire batch to succeed or fail.

But am I better off using a TIB_Cursor, or TIB_DSQL for this job?
What are the speed / efficiency differences?

Also, you suggested using a stored proc. By this, do you mean
creating a stored proc which accepts all fields as paramteres, then
execute the procedure?


--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> That's exactly right. You were running in AutoCommit = true mode
and calling
> StartTransaction suspends AutoCommit and puts you in control.
> I highly recommend when importing data you use a stored procedure
> instead of failing a whole batch catch the exception for the
record, log it
> into a special errors table and allow the process to continue.
> See InterBase language guide for how to catch and respond to