Hi Jason,

> You should use the SavePoint method to effect a commit.

that did the trick!

Thanks.

--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/

> HTH,
> Jason Wharton
>
> ----- Original Message -----
> From: "Thomas Steinmaurer" <ts@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Thursday, May 20, 2010 1:13 PM
> Subject: [IBO] Commit interval with TIB_DataPump?
>
>
>> Hello,
>>
>> any ideas on how to implement a commit interval (= doing a commit after
>> processing a particular number of source records) with TIB_DataPump?
>>
>> I've tried to call Commit/CommitRetaining in various events of
>> TIB_DataPump (e.g. AfterExecuteItems, AfterFetchRow, BeforeExecuteItems)
>> but in all cases I end up with an exception, which might differ.
>>
>> Any ideas on how to implement a commit interval?
>>
>>
>> --
>> Best Regards,
>> Thomas Steinmaurer
>> LogManager Series - Logging/Auditing Suites supporting
>> InterBase, Firebird, Advantage Database, MS SQL Server and
>> NexusDB V2
>> Upscene Productions
>> http://www.upscene.com
>> My blog:
>> http://blog.upscene.com/thomas/
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>
>
>
>