Article View: borland.public.interbase.sql
Article #11216Re: copy tables between databases
From: CleverComponents Team
Date: Wed, 11 Dec 2002 19:10
Date: Wed, 11 Dec 2002 19:10
31 lines
2373 bytes
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-mailReferences:
<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