-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Nic Wise
Sent: Thursday, 14 September 2000 13:16
To: Multiple recipients of list delphi
Subject: RE: [DUG]: IBX: a newbie question
>> IB6, D5 Ent, IBX, concurrent read/write access.
>>
>> I need help on ways of using Transactions (the online help is hopeless).
>>
>> 1). Setting params.
>Pass - I usually use the second one, but I also usually get slapped for
>using it, tho I'm still not sure why.
I did same thing here.
>> 2). Do I need to call StartTransaction/Commit(RollBack)
>> explicitly for EVERY
>> db access?
>no, just on updates/inserts/deletes. Selects are OK.
>something like:
>try
> conn.startTransaction;
> qryGeneral.sql.clear;
> qryGeneral.sql.add('update mytable set myvalue = 1');
> qryGeneral.execSQL;
> conn.commitTransaction;
>except
> conn.rollbackTransaction;
>end;
Thanks
>> 3). Any advises on known issues.
>If you are also using MIDAS, or thread, you need a TIBTransaction object
for
>EACH query, regardless of what its doing.
This one has been documented.
>Get the latest version from interbase.com and/or interbase2000.org
I think I've got the latest ones already.
N
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
