"Helen Borrie" <helebor@...> wrote in message
news:4.2.0.58.20011013125331.03d1be00@......

> Walter,
> I don't know whether this is the source of your problem but there is no

BLOB SUB_TYPE TEXT - you need BLOB SUB_TYPE 1 for text blobs, afaik.

You can use any sub_type that can be found by this GDML query, where
"numeric_value" holds the pointer to the output value:

FOR X IN RDB$TYPES WITH
X.RDB$FIELD_NAME EQ "RDB$FIELD_SUB_TYPE" AND
X.RDB$TYPE_NAME EQ <sub_type_name>
found = TRUE;
*numeric_value = X.RDB$TYPE;
END_FOR

With this artifact, TEXT doesn't need to be a reserved word.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing