Page 1 of 1
Error when opening table
Posted: 06.07.2009, 16:50
by 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
Posted: 07.07.2009, 12:22
by 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
Posted: 07.07.2009, 14:51
by fnordbak
seawolf wrote: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
Posted: 07.07.2009, 18:11
by seawolf
Can you provide the sql code declaration of that 2 fields (ora a sample of that table)?
Posted: 08.07.2009, 12:53
by fnordbak
seawolf wrote: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,
