--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@s...> wrote:

> > with ibescript.exe from www.ibexpert.com you can do this
> > without a problem.
> >
> > example script:
> >
> >
> > SET BLOBFILE 'C:\f.jpg';
> > INSERT INTO ... VALUES (..., :h00000000_FFFFFFFF);
> > SET BLOBFILE 'C:\f2.jpg';
> > INSERT INTO ... VALUES (..., :h00000000_FFFFFFFF);
> > SET BLOBFILE 'C:\f3.jpg';
> > INSERT INTO ... VALUES (..., :h00000000_FFFFFFFF);
>
> Can I insert several files/blobs using single INSERT ?
>
> INSERT INTO ... VALUES

(..., :h00000000_FFFFFFFF, :h00000000_FFFFFFFF, :h00000000_FFFFFFFF);

>
> Ivan

No, but you can prepare 1 "blob" file containing several binary files
together and then do this

SET BLOBFILE 'C:\all_in_one.lob';
INSERT INTO ... VALUES
(..., :h00000000_12345678, :h12345679_55555555, :h5555556_FFFFFFFF);

Ales