----- Original Message -----
From: Sergio H. Gonzalez
> Hello, I'm working with a DB on FB2.1 The DB has some BLOB fields to hold
> images. Every worked fine until today... I get an "invalid blob ID" when I
> open
> the table. I tryen to make a backup, but I get the same error while I'm it.
> What
> can be wrong? How can I solve this problem?

> I use Delphi 6 / IBX. But the same error accurs if I open the table with
> IBExpert

Correction... the fields that are having problems are 3 and all of them are BLOB
SUB_TYPE 1 SEGMENT SIZE 40
if I select any other field I have no errors.

And the problem seems to appears AFTER I run some selects (and stored
procedures) to make a report. I recover the database from a backup and works all
fine, but if I run that report, I can't open the table anymore (if I select one
of the 3 fields I mentioned before). The report only uses *select* instructions.
Can just a *select* damage the database? How can I fix this problem? Help!!
Please !!

this is the table:

CREATE TABLE ARTICULO (
ID ID /* ID = INTEGER DEFAULT 1 */,
CODIGO_S_PROV CHAR(25),
CODIGO_BARON CHAR(8),
DESCRIPCION VARCHAR(100) DEFAULT '',
PROVEEDOR ID /* ID = INTEGER DEFAULT 1 */,
PROCEDENCIA ID /* ID = INTEGER DEFAULT 1 */,
ORIGEN_FABRICACION ID /* ID = INTEGER DEFAULT 1 */,
IMAGEN BLOB SUB_TYPE 0 SEGMENT SIZE 1024,
ID_GRUPO ID /* ID = INTEGER DEFAULT 1 */,
ID_FAMILIA ID /* ID = INTEGER DEFAULT 1 */,
ID_RUBRO ID /* ID = INTEGER DEFAULT 1 */,
NOTAS BLOB SUB_TYPE 1 SEGMENT SIZE 80,
TIPO_CATALOGO CHAR(5),
MARCA VARCHAR(25),
AGREGAR_MARCA CHAR(1),
STD_PACK NUMERIC(9,2) DEFAULT 0,
CODIGO_BARRAS CHAR(13) DEFAULT 0,
ID_POS_ARANC ID /* ID = INTEGER DEFAULT 1 */,
SELECCIONADO CHAR(1) DEFAULT '',
COSTO_BASE NUMERIC(14,3) DEFAULT 0,
ID_SUBGR ID /* ID = INTEGER DEFAULT 1 */,
PORCENTAJE NUMERIC(7,2) DEFAULT 0,
POS_CATALOGO INTEGER DEFAULT 0,
ID_PACK INTEGER DEFAULT 0,
IMPORTADO VARCHAR(1) DEFAULT '',
ACTIVO CHAR(1) DEFAULT 'Y',
NO_REPONER CHAR(1) DEFAULT '',
DESC_ETIQUETA VARCHAR(210),
FOB NUMERIC(14,3) DEFAULT 0,
FECHA_DE_ALTA DATE,
FOB_CON_PACKAGING NUMERIC(14,3),
ID_PACK_USA INTEGER,
WEB_DESCRIPCION BLOB SUB_TYPE 1 SEGMENT SIZE 40,
META VARCHAR(350),
ART_RELACIONADOS VARCHAR(150),
DESC_LARGA_FAM VARCHAR(80),
CAT_OFERTA VARCHAR(3),
DESTACADO_GRUPO VARCHAR(3),
DESTACADO_SUBGRUPO VARCHAR(3),
DESC_INICIO VARCHAR(100),
IMPORTANCIA_INICIO CHAR(1),
FLASH VARCHAR(50),
LINK VARCHAR(255),
TITULO_LINK VARCHAR(255),
DES_DESTACADO_ESP VARCHAR(255),
HINT VARCHAR(100),
INC_EN_WEB CHAR(1),
PDF BLOB SUB_TYPE 1 SEGMENT SIZE 40,
PDF_TITULO BLOB SUB_TYPE 1 SEGMENT SIZE 40
);