At 10/17/2000 11:35 AM (Tuesday), you wrote:

> > >to transfer a BLOB? I hoped that some existing software could cope
> > >with this - but that is not the case or ??
> >
> > If you mean, has someone written a utility for transferring blobs -
>yes,
> > probably, and it will be sitting on his hard disk panting to be let
>out.
>
>This was exactly what I meant. I wonder why the Interbase people
>haven't made such a tool available? ... it seems like a must if you
>want to access Interbase from Paradox ... and it IS possible to get
>blob's out of Interbase with programmes from the package (e.g.
>blobdump from isql) ... you just can't get data in easily :o)

I'm confused by this message thread. I have used Paradox itself to
transfer/load/update blob fields between Paradox tables and Interbase
tables for a long time. Now I have only done it with text blobs but it
works fine.

Here's what I do: Create a table in Interbase with a primary key and a blob
field such as

CREATE TABLE BLOBTEST (PRIMARYKEY INTEGER NOT NULL,
BLOB1 BLOB SUB_TYPE TEXT SEGMENT SIZE 80,
CONSTRAINT BLOBTEST_PK PRIMARY KEY (PRIMARYKEY));

Create a table in Paradox with similar structure. (PrimaryKey field type is
I, Blob1 field type is M).

Open Paradox and the project viewer. Right click on the Paradox table and
select Add. When the table open dialog appears select the alias for the
Interbase database and then the Interbase table.

The Add operation should copy the records from Paradox to Interbase,
including the blob data.