|Subject||Re: [firebird-support] query that returns the BLOB ID - not the blob...|
> 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.
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;
Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server