Re: Informix TEXT fields
Eduardo Mendez <m3inf@ibm.net> writes:
> We are using PowerBuilder 4 with Informix OnLine 5.
> We are getting a *LOT* of problems with "memo" fields (I mean
> "memo" in the dBASE sense).
>
> [ TABLE DEFINITION of mytable:
> ..., myfield TEXT, ... ]
>
> Since we define them as TEXT, we are not able to do
> INSERT's on them (Informix expects a BLOB type value,
> not a CHAR type value).
>
> [ THIS FAILS:
>
> INSERT INTO mytable( myfield ) VALUES( "Abcd" )>
> ]
>
> Since VARCHAR's in Informix can not go longer than 255,
> we see no way of getting a "memo" field.
>
> A curious point. We *CAN* do INSERT's in the above
> situation if the lenght of the string is 3 or less.
>
> [ THIS WORKS:
>
> INSERT INTO mytable( myfield ) VALUES( "Abc" )>
> ]
>
> Any ideas?
Insert values into all fields except the blob field, then
use UPDATEBLOB.
Peter Simonsen, Ranb'll, DK