Subject Re: [IBO] Blob Field on Firebird
Author Helen Borrie
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.

If this isn't the problem, watch here a bit longer, as Claudio did the bug fixes on the BlobID problems and he may spy something for you...Claudio is probably sleeping at the moment. :)

Are you using IBConsole? If so, check whether you get the same problem using IB_SQL or commandline isql...

regards,
Helen


At 11:46 PM 12-10-01 -0300, you wrote:
>Hi,
>
>I have a simple project with a simple table like this:
>
>CREATE TABLE "DITOS"
>(
> "DITCODIGO" INTEGER NOT NULL,
> "DITMENSAGEM" BLOB SUB_TYPE TEXT SEGMENT SIZE 80 CHARACTER SET WIN1252,
> PRIMARY KEY ("DITCODIGO")
>);
>
>When i used it under Interbase 6.0 (Linux / Delphi 5.0) it works fine, now i took out the IB and instaled FB, so, when i insert a new register, i receive an error:
>
>ISC ERROR CODE: 335544329
>ISC ERROR MESSAGE:
>invalid BLOB ID
>
>so, i ask, it's a problem with what? FB? Delphi? Linux? "Me"??? :-)
>
>any hints is welcome...
>txs
>
>
>[]'s
>
>Walter A. Franco
>SysMaker Sistemas
>Poços de Caldas - MG
>UIN 11.606.129
>
>
>[Non-text portions of this message have been removed]
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________