Subject Re: [IBO] MON$SQL_TEXT Blob column in MON$STATEMENTS table
Author Thomas Steinmaurer
> When I open the MON$STATEMENT (SQL below) I am getting an "Invalid Blob ID"
> error on most of the MON$SQL_TEXT columns when I hook them up to a TIB_Memo.
> I am getting the same error when I set up a stream and read them. The code
> works for a few of the rows (I must be doing something right) but I get the
> error for most of them. Using the same query and reading the data with the
> IBOBJECTS TIB_Query statements form I click on the MON$SQL_Text column
> button in the grid and the sql text is displayed in a pop up dialog.
> Additionally, when I use IB_Expert's SQL Editor with the same SQL I can read
> all the MON$SQL_Text with no errors so I know the SQL Text is there.
> Anybody got any ideas on what is causing the problem?

This might be related to:
http://tracker.firebirdsql.org/browse/CORE-2632

Fixed in 2.1.4 and 2.5.x.


--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/