Subject IB_SQL [4.9.14]
Author Aage Johansen
Occasionaly, when I browse tables in IB_SQL, I receive the following message:
=========================================
ISC ERROR CODE:335544329

ISC ERROR MESSAGE:
invalid BLOB ID

STATEMENT:
qrRelInf.<no name>(TIB_BindingCursor)

STATEMENT:
frmBrowse.qrRelInf(TIB_Query)
=========================================
If I try to view the description (The "Desc" pane) I will only find a
"Could not load memo".

Exiting IB_SQL and restarting it mostly fixes the problem. Maybe
just disconnect+connect fixes it as well. However - the error
message returns, sometimes.

I've been using Firebird 2.5. I think it also happens with 2.1,
maybe not with 1.5.
The databases on 2.5 have been converted from 1.5 using something like:
gbak -se service_mgr -fix_fss_metadata ISO8859_1 -fix_fss_data
ISO8859_1 -rep -v -user SYSDBA -password *--* E:\DB_bckp\sl1b3.fbk15 SL1
(SL1 is the database alias)
I connect with ISO8859_1 charset.


I use IB_SQL a lot, and REALLY dislikes it when it misbehaves.

While I'm at it, there's another problem (a visual "niggle"):
Browse a table (the "Data" pane). Switch to the "Fields" pane - the
fields and the values from the current record show. Choose another
table - and voila! - the value from the first field of the previous
table stays on the pane. No harm done, but doesn't look too good.


--
Aage J.