Error when opening table

[fnordbak]

I'm getting an error that says "Cannot access blob record in column 33 with type Unknown" when trying to open a table containing two blob fields.

If I open the table in Database Workbench - Firebird Edition, both fields have a "subtype" of "-2" (whatever that means): http://yfrog.com/09blobbucj

Any idea what is wrong?

ZeosLib v6.6.5-stable
Delphi 2007

[seawolf]

I know that Firebird has 10 blob subtypes, from 0 to 9, and permit to
define custom blob subtypes (i.e. subtype -2).
To be sure open system table rdb$types and verify if you have a row
RDB$FIELD_SUB_TYPE, with RDB$TYPE set to -2

[fnordbak]

I know that Firebird has 10 blob subtypes, from 0 to 9, and permit to
define custom blob subtypes (i.e. subtype -2).
To be sure open system table rdb$types and verify if you have a row
RDB$FIELD_SUB_TYPE, with RDB$TYPE set to -2

No, there are 10 rows, with RDB$TYPE from 0 to 9.

http://i28.tinypic.com/153sg3t.jpg

[seawolf]

Can you provide the sql code declaration of that 2 fields (ora a sample of that table)?

[fnordbak]

Can you provide the sql code declaration of that 2 fields (ora a sample of that table)?

Code: Select all

  FRONTCOVER_BLOB                   BLOB SUB_TYPE -2 SEGMENT SIZE 80,
  BACKCOVER_BLOB                    BLOB SUB_TYPE -2 SEGMENT SIZE 80,