Subject Re: [IBO] Basic IBO usage question
Author peter@cyionics.com
thanks Paul

----- Original Message -----
From: Paul Vinkenoog
To: IBObjects@yahoogroups.com
Sent: Sunday, August 10, 2003 12:24 PM
Subject: Re: [IBO] Basic IBO usage question


Hi Peter,

> I have just started using IBObjects again, previously I had been
> using the IBO_Transaction bar I am now trying to do multiple inserts
> in code, but the transaction is obviosuly not commiting.
>
> I can't find anything in the help , or getting started guide ?

My help files state that ApplyUpdates, CommitUpdates and CancelUpdates
are work in progress. I don't know what they are for, but the standard
procedure is, after setting the field values like you did:

> Product_IB_Datasource.Insert;
>
> Product_IB_Query.FieldByName('VENDOR_ID').AsInteger := ...
> ...

...to call Post on the Dataset:

> Product_IB_Query.Post;

If your transaction component has AutoCommit true, you can leave it
at that. Otherwise, you have to call Transaction.Commit or
Transaction.CommitRetaining.

In an exception handler, you could call Transaction.Rollback or
Transaction.RollbackRetaining


HTH,
Paul Vinkenoog


Yahoo! Groups Sponsor
ADVERTISEMENT




___________________________________________________________________________
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 !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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