Re: More than 100 Chr$ in UPDATE
Prenom Nom wrote:
>
> Hi !
>
> I'm a beginner with informix SQL, and I would like to know how to write a long
> text (more than 100 caracters) in UPRDATE or INSERT function ?
>
> Thanks a lot for reply ASAP.
>
> Bye,
>
> Lydie (Paris, France)
You could try something like:
insert into mytable
select value1,"this is a very very long text"
||" line that must be inserted using the special concatenation"
||" symbol",value3
from systables where tabid=1;
This seems to work in dbaccess.
--
----------------------------------------------------------------------
John H. Frantz Power-4gl: Extending Informix-4gl
frantz@centrum.is http://www.strengur.is/~frantz/pow4gl.html