RE: INSERTing string longer the 256 bytes

Carlos, Just because *you* haven't had to do this, that doesn't mean others haven't, and it certainly doesn't mean this isn't the design failure that it is. I currently have a total kludge work-around, that works-barely, but is not satisfactory in the long term. I also don't see how the OS would effect the situation, although I guess thats why I posted the question. Thanks, Steve > -----Original Message----- > From: Info Temp [mailto:inf999@cap-az.com] > Sent: Thursday, February 03, 2000 7:28 AM > To: Steven Frank > Cc: informix-list@iiug.org > Subject: Re: INSERTing string longer the 256 bytes > > > Steven Frank wrote: > > > Perhaps I'm missing something, but when trying to insert a > string value of > > greater than 256 bytes, Informix generates an error -280 (A > quoted string > > exceeds 256 bytes). > > > > I understand the error, but not the restriction. For Pete's > sake, even MS > > Access allows this!! > > > > Is there a decent workaround for this complete design failure > on Informix's > > part? > > > > Thanks > > Never having tried to insert a string that long, I don't know the > answer to > your question, but isn't your conclusion a bit harsh? I don't > know how many > times I've bumped into some constraint that made it appear the > software was > not very robust, only to find that changing a parameter set by the OS > corrected the situation. > > carlos > > >