Search found 3 matches

Go to advanced search

by fnordbak
08.07.2009, 12:53
Forum: Firebird
Topic: Error when opening table
Replies: 4
Views: 722

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,
by fnordbak
07.07.2009, 14:51
Forum: Firebird
Topic: Error when opening table
Replies: 4
Views: 722

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.c...
by fnordbak
06.07.2009, 16:50
Forum: Firebird
Topic: Error when opening table
Replies: 4
Views: 722

Error when opening table

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): ht...

Go to advanced search