Maybe with freeadhovUDF:

http://freeadhocudf.org/documentation_english/dok_eng_file.html

hth

Michael





From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ken
Sent: Wednesday, December 15, 2010 8:28 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: query that returns the BLOB ID - not the
blob...





That's exactly what I was wanting to do ...

Now, to somehow do this ...

SET BLOB OFF;
SELECT ID,MEMO FROM TABLE; (MEMO IS THE BLOB field)

... then, for each ID/MEMO selected, BLOBDUMP 'memo' ID.TXT

What I would end up with is a SERIES of text files where the name of the
file is the ID of the record - and the CONTENTS of the file is the contents
of the BLOB.

Is this something that I can run - from a script/commandline?

> Executing in isql:
>
> SET BLOB OFF;
>
> will disable showing the blob content. You get the blob id instead.
>
> With:
>
> BLOBVIEW <blobid>;
>
>
> you then can display the blob content in an external editor (e.g.
> notepad on Windows).
>
> You can turn on displaying BLOBs again with:
>
> SET BLOB ON;
>
>
>
> HTH.
>
>
> --
> With regards,
>
> Thomas Steinmaurer
> Upscene Productions
> http://www.upscene.com
> http://blog.upscene.com/thomas/
>
> Download LogManager Series, FB TraceManager today!
> Continuous Database Monitoring Solutions supporting
> Firebird, InterBase, Advantage Database, MS SQL Server
> and NexusDB!
>

[Non-text portions of this message have been removed]