> IBOQuery.ExecuteImmediate(SQL, nil);
> IBOQuery.ApplyUpdates;

ApplyUpdates is used when doing cached updates stuff. What you really need
to do is Commit the transaction.

IBODatabase.StartTransaction;
try
<loop start>
IBOQuery.ExecuteImmediate(SQL, nil);
<loop end>
IBODatabase.Commit;
except
IBODatabase.Rollback;
raise;
end;

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "gjustier" <newsgroup@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, June 12, 2002 4:26 AM
Subject: [IBO] Commit problem ?


> Dear all,
>
> I have a problem with IBObjects.
> When I create new records with a stored procedure,
> let's say sp_newcontract, I can't see the resulting contract
> in my "search contract" screen until I close the application and open
> it again.
> I am using the following command to run the SP :
>
>
> What am I doing wrong ?
>
>
> Thanks in advance,
> Guillaume
>
>
>
>
>
___________________________________________________________________________
> 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 http://docs.yahoo.com/info/terms/
>
>
>