🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #11216

Re: copy tables between databases

#11216
From: CleverComponents Team
Date: Wed, 11 Dec 2002 19:10
31 lines
2373 bytes
Hello Dietrich,

> I have tested your solution #4, but it does not support BLOBS !?
> Message "BLOB NOT FOUND"
Please see function TIBOutputRawFile.WriteColumns: Boolean; located
IBSQL.pas - as you see it can hanlde BLOBs.
If you have problems with it you might want to post your qestions to
borland.public.delphi.database.interbaseexpress
Just check that you have latest version of IBX.

> Also the database keeps growing with every delete / Insert
Unfortunately it is not clear what you meant by this.
Database will grow of course but it will really depends how you insert /
delete data.
I can not explain all details in this small message (please refer to
Interbase documentation) but if you start transaction, delete data and
insert new data into the same table then database will grow.
Once you commited transaction (and reconnected to the database) then next
insert will use space left after deleted records.
So database will not grow all the time unless you will insert more and more
data with every session of delete/update
Generally speaking you should not worry about database size.
If size matters then you probably need seek other solution .

Best regards,


Alex
CleverComponents Team
www.CleverComponents.com
info@CleverComponents.com
Technical Details
Message-ID: <3df78d54@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newspump.sol.net!news.maxwell.syr.edu!colt.net!diablo.netcom.net.uk!netcom.net.uk!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <3df0d44d@newsgroups.borland.com> <3df14ea9$1@newsgroups.borland.com> <3df73ac3$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,c3b2366d6a3e9489
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-11 11:10:06 PST
From: "CleverComponents Team" <info@clevercomponents.com>
Newsgroups: borland.public.interbase.sql
References: <3df0d44d@newsgroups.borland.com> <3df14ea9$1@newsgroups.borland.com> <3df73ac3$1@newsgroups.borland.com>
Subject: Re: copy tables between databases
Date: Wed, 11 Dec 2002 11:10:36 -0800
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 216.103.70.227
Message-ID: <3df78d54@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1039633748 216.103.70.227 (11 Dec 2002 11:09:08 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newspump.sol.net!news.maxwell.syr.edu!colt.net!diablo.netcom.net.uk!netcom.net.uk!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail