🚀 go-pugleaf

Hello,
why don't you use the IbDataPump utility?

you can download a free version from this site:
http://www.clevercomponents.com/downloads/index.asp

Interbase DataPump v 3.4 standalone application.



That's the guide to how to use the programm:
http://www.clevercomponents.com/products/datapump/dp-tour.asp#21

I used it to divide a 1.7Gbyte database into 6 others using blob fields too.

Bye,
Stefano Giannini



"Bj�rge S�ther" <bjorge@hahaha_itte.no> ha scritto nel messaggio
news:3df5c5eb$1@newsgroups.borland.com...
> "James Ponder" <jhponder@mindspring.com> skrev i melding
> news:3df54f99$1@newsgroups.borland.com...
> > 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.
>
> have you set Stram.Position *after* read but *before* write ?
> ...see, after the srtram has read all data, it's located at end of stream,
> and it will appear to have "no data left".
>
> --
> Bj�rge S�ther
> bjorge@hahaha_itte.no
>
>