copying BLOB fields between databases

Article View: borland.public.interbase.sql

Article #11189

Back to borland.public.interbase.sql Previous Next

#11189

From: James Ponder
Date: Tue, 10 Dec 2002 02:22

17 lines
1736 bytes

I need to copy selected BLOB fields from one database to another.

Suppose:

         db1.gdb and db2.gdb are the databases.

         tbl1 is a table in db1.gdb which contains a BLOB field.

         tbl2 is a table in db2.gdb which also contains a BLOB field.

I need to select specific records from tbl1 and copy them to tbl2.

I am using Delphi 6 Pro and Interbase 6.  I have played with 
TIBBlobStream but can't get it to work.  Any help would be appreciated. 
  Answers to my email (jhponder@mindspring.com) would also be 
appreciated as I have difficulty accessing the newsgroup on any regular 
basis.  Thank you.

Technical Details

Message-ID: <3df54f99$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.wirehub.nl!news-hub.cableinet.net!blueyonder!nntp2.aus1.giganews.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,4d808d7339ef4747,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-09 18:27:43 PST
Date: Mon, 09 Dec 2002 18:22:23 -0800
From: James Ponder <jhponder@mindspring.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: copying BLOB fields between databases
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 66.32.153.33
Message-ID: <3df54f99$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1039486873 66.32.153.33 (9 Dec 2002 18:21:13 -0800)
Lines: 18
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.wirehub.nl!news-hub.cableinet.net!blueyonder!nntp2.aus1.giganews.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail