Subject | RE: [firebird-support] Re: The Database file is growing exponentialy with UPDATE query |
---|---|
Author | Yusuf Celik |
Post date | 2008-01-28T09:58:06Z |
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]
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]