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!
>