Subject Re: Command Line Tool
Author HKlemt
--- In firebird-support@yahoogroups.com, "kummi_n" <kummi_n@y...>
wrote:
> Hi,
>
> Is there a command line tool(other than gbak) to Insert BLOB Data
to
> FireBird DB?

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);

Best Regards

Holger Klemt

The Worldwide Firebird Conference, November 13th - 15th, Prague,
Czech Republic

The most Expert for InterBase and Firebird --- www.ibexpert.com
HK Software - Gerhard Stalling Str 47A - 26135 Oldenburg - Germany
Phone/Fax +49 700 IBEXPERT (42397378) www.h-k.de
Training and Support for Delphi, InterBase, Firebird, AS/400