Anders Welen <anders.welen@lks.covd.se> wrote:
:I'm running SE 5.01 for SCO under Linux ;)
:I have a char(600) field that I'm trying to perform
:INSERT and UPDATE on but I'm getting error -280.
:(I've tried both isql and ESQL/C)
:How do I solve this STUPID limitation about 256
:characters of Informix.
:If anyone out there knows why this limitation exists,
:please feel free to explain it to me!!!
I don't know why the limitation is there, nor do I care, I have never
hit it so far. I simply use a variable instead. I don't know the
syntax for it in C (i program only in 4GL), but it is possible in C as
well.
To hit this limitation in isql you would have to either realy type a
lot (which I would use another tool for) or have externally generated
statements. There is a way around this too, but I don't remember it
for sure. May be concatenation works? The operator is || (two virtical
bars).
Nils.Myklebust@ccmail.telemax.no
NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway
My opinions are those of my company