Subject Re: [firebird-support] query that returns the BLOB ID - not the blob...
Author Thomas Steinmaurer
> Is there an ISQL query method which will produce the BLOB ID? I've hunted for hours for something like this - and have been unsuccessful.

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!