Subject Re: [firebird-tools] How to extract blob content to file, using Fsql?
Author Jiri Cincura
On Sun, Dec 20, 2009 at 12:43, RobertoA <amorosik@...> wrote:
> Here the example for insert file contents into blob field
>
> http://www.volny.cz/iprenosil/interbase/fsql-examples.htm
>
> /* Inserting contents of file(s) into blob/varchar fields. */
>
> INSERT INTO tab(id, pict, thumb) VALUES (1, @'c:\pict.jpg',
> @'c:\smallpict.jpg
>
> The question is: - using Fsql, how we can extract data from blob field and
> create a file on Win Xp ntfs?

You can use:
BLOBDUMP <blobid> <file> [FILTER <num1> <num2>]
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com