Subject RE: [firebird-support] Re: The Database file is growing exponentialy with UPDATE query
Author Yusuf Celik
I've been using the current IB Express components with FireBird 2.0x.
since FDB 1.5
using D2007 and also used with D2005 and D2006 versions.

And no problem.
I suggest you not to use Low level calls and not to interfere with the
VCL source code
just use plaint the IB Express calls.
Here how I use it:
Let's say you have db:TIBDatabase and trIb:TIBTransaction componets on
the form.
and the settings are as follows
db.DefaultTransaction = trIb;
trIb.DefaultDatabase = db;

For transactionStart:
if not trIb.Active then
trIb.StartTransaction;
try
Update stm;
insert stmtm;
...
...
trIb.CommitRetaining;
except
trIb.RollbackRetaining;
raise;
end;

Hope it helps
yc


Well,

my code is using the transaction process of Firebird:

in my program I call

DBexecSql( Sql1 ; 1 );

And the rest is done into a specific unit DBConnect.

Its more simple.

From CodeGear I have modify the SQLEXPR.PAS of Delphi 7 adding:

procedure TCustomSQLDataSet.CloseCursor;
begin
inherited CloseCursor;
// TopWare add
FreeStatement;
end;


Recent Activity

*
16
New Members
<http://groups.yahoo.com/group/firebird-support/members;_ylc=X3oDMTJmbTE
4YTc4BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN
2dGwEc2xrA3ZtYnJzBHN0aW1lAzEyMDE1MTIyNjc->

Visit Your Group
<http://groups.yahoo.com/group/firebird-support;_ylc=X3oDMTJlZXMyN2VjBF9
TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2x
rA3ZnaHAEc3RpbWUDMTIwMTUxMjI2Nw-->
New business?

Get new customers.
<http://us.ard.yahoo.com/SIG=13ogtq69c/M=493064.12016308.12445700.867457
8/D=groups/S=1705115386:NC/Y=YAHOO/EXP=1201519467/L=/B=E5gGAELaX90-/J=12
01512267761173/A=3848640/R=0/SIG=131an6mds/*http://searchmarketing.yahoo
.com/arp/srchv2.php?o=US2002&cmp=Yahoo&ctv=Groups1&s=Y&s2=&s3=&b=50>

List your web site

in Yahoo! Search.

Sitebuilder

Build a web site
<http://us.ard.yahoo.com/SIG=13oieoot1/M=493064.12016255.12445662.867457
8/D=groups/S=1705115386:NC/Y=YAHOO/EXP=1201519467/L=/B=FJgGAELaX90-/J=12
01512267761173/A=4025304/R=0/SIG=12uhb64pb/*http://us.rd.yahoo.com/evt=4
4092/*http://smallbusiness.yahoo.com/webhosting/sitebuilding.php>

quickly & easily

with Sitebuilder.

Check out the

Y! Groups blog
<http://us.ard.yahoo.com/SIG=13o9d22ki/M=493064.12016258.12582637.867457
8/D=groups/S=1705115386:NC/Y=YAHOO/EXP=1201519467/L=/B=FZgGAELaX90-/J=12
01512267761173/A=5191952/R=0/SIG=112mhte3e/*http://www.ygroupsblog.com/b
log/>

Stay up to speed

on all things Groups!

.

<http://geo.yahoo.com/serv?s=97359714/grpId=2442406/grpspId=1705115386/m
sgId=91932/stime=1201512267/nc1=3848640/nc2=4025304/nc3=5191952>



Bu e-mail'in tum icerigi gonderenin kisisel tasarrufu ile olusturulmus ve gonderilmistir. Oyak Teknoloji Bilisim ve Kart Hizmetleri A.S. bu e-mail icerigi hakkinda sorumluluk kabul etmez.
This e-mail has been sent by the sender under his/her own individual discretion. Oyak Teknoloji Bilisim ve Kart Hizmetleri A.S. accepts no responsibility.


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