Subject | Re: [firebird-support] query that returns the BLOB ID - not the blob... |
---|---|
Author | Thomas Steinmaurer |
Post date | 2010-12-15T19:09:44Z |
> 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!