Re: 280 error

>From: scornd7@solomon.technet.sg (Tang Chang Thai) >Subject: 280 error >Date: 6 Oct 1994 04:45:18 GMT >X-Informix-List-Id: <news.9163> >Hi ... I was trying to insert a character string of > 256 bytes into a field >that is defined to be char(360) using dynamic SQL. The online engine returned >an error of -280. Is this supposed to be a feature? >The version of Informix is 5.01 on both client and server. Yes. Literal strings are limited to 256 bytes. However, you are only limited to 32k-1 if you use a host variable -- and that's because you can't have a row bigger than 32k-1 (ignoring blobs). You would use ? in place of the variable name, because you're using dynamic SQL, and would supply the value via a USING clause or an sqlda structure or a DESCRIPTOR. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>