Subject Re: [IBO] Running without automatic transaction start
Author Steve Boyd
If I could always remember to do this, I could always remember to start
the transaction. :(

I think you are missing the point. I wanted to know if there was some
setting I can use to have IBO tell me that I forgot to start the
transaction. I'm not really looking for ways to do it myself.

Hans wrote:
> To avoid missing a start ..
>
> if not IBODatabase.InTransaction then
> IBODatabase.StartTransaction
>
> before ever database operation
>
>
> ----- Original Message -----
> From: "Steve Boyd" <sboydlns@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Wednesday, January 21, 2009 2:03 PM
> Subject: Re: [IBO] Running without automatic transaction start
>
>
>
>> I know that issuing my own StartTransaction will prevent IBO from
>> starting another one, but what I want is for IBO to throw an exception
>> if I forget to issue my own StartTransaction. I want to avoid the
>> situations that arise when I forget to start a transaction, and hence
>> forget to commit it, leaving transactions open.
>>
>> Hans wrote:
>>
>>> Turn AutoCommit off and or just issue your own StartTransaction before
>>> the start of any database opereations. IBO will not start its own in
>>> that case.
>>>
>>> ----- Original Message -----
>>> From: "Stephen Boyd" <sboydlns@...>
>>> To: <IBObjects@yahoogroups.com>
>>> Sent: Wednesday, January 21, 2009 1:42 PM
>>> Subject: [IBO] Running without automatic transaction start
>>>
>>>
>>>
>>>
>>>> Is there any way to prevent transactions from automatically starting?
>>>> I want to be able to run in an environment where I am responsible for
>>>> starting and committing / rolling back all transactions myself.
>>>>
>>>>
>>>>
>>>> ------------------------------------
>>>>
>>>> ___________________________________________________________________________
>>>> 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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>> ------------------------------------
>>>
>>> ___________________________________________________________________________
>>> 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
>>>
>>>
>>>
>>>
>>>
>>>
>> [Non-text portions of this message have been removed]
>>
>>
>> ------------------------------------
>>
>> ___________________________________________________________________________
>> 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
>>
>>
>>
>>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>
>
>
>


[Non-text portions of this message have been removed]