i used the sub_type TEXT from Interbase, and it "yes" it works...

Carlos, i've a form with a TIB_Edit (for DITCODIGO) and a TIB_Memo (for
DITMENSAGEM), sorry, i forgot to say that, if i open this table with
IBConsole, it works fine too.
My Firebird is a "new" instalation, i had IB before, so i did a rpm -e IB...
removed the /opt/interbase directory and after, instaled the Firebird, my
client on rWindows if the same when i worked with IB (i didn't install it
again).
So, what else can you tell me?
txs in advance....
best regards


[]'s

Walter A. Franco
SysMaker Sistemas
Poços de Caldas - MG
UIN 11.606.129

----- Original Message -----
From: "Claudio Valderrama C." <cvalde@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Saturday, October 13, 2001 2:31 AM
Subject: Re: [IBO] Blob Field on Firebird


> "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
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>