Subject | Re: [firebird-tools] How to extract blob content to file, using Fsql? |
---|---|
Author | Jiri Cincura |
Post date | 2009-12-21T09:45:14Z |
On Sun, Dec 20, 2009 at 12:43, RobertoA <amorosik@...> wrote:
BLOBDUMP <blobid> <file> [FILTER <num1> <num2>]
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com
> Here the example for insert file contents into blob fieldYou can use:
>
> 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?
BLOBDUMP <blobid> <file> [FILTER <num1> <num2>]
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com