Re: How to insert a string more large than 256 c
stephane galet wrote:
>
> Hi
>
> Is there anybody know how to insert a string more large than 256 c.
> I tried with : insert into table set column = "..."||"..." but the
> database returned a syntx error
INSERT INTO table (key,column) VALUES ("keyval1","First part of text.");
UPDATE table SET column = TRIM(column) || " Next 256 bytes of text "
WHERE key = "keyval1";
UPDATE table SET column = TRIM(column) || " Third 256 bytes of text "
WHERE key = "keyval1";....
Art S. Kagel