Re[2]: Limits In ESQL/C

Jonathan, Thank you for your explanation. I was confused when one of the Tech Support people at Informix told me that the maximum limit was 256 characters for the SQL statement. Puru. ______________________________ Reply Separator _________________________________ Subject: Re: Limits In ESQL/C Author: johnl@informix.com (Jonathan Leffler) at INTERNET Date: 22/6/95 11:16 AM Neither -- that limit is probably 32k-1, though you would have to be preparing a string variable, not a literal string. The first limit applies to SELECT * FROM Somewhere WHERE SomeColumn = "A very .... long string"; The very long string can't be more than 256 characters. Note that it only applies to string literals -- you can use longer strings provided they are represented by variables. The second limit applies to the layout of ESQL/C source code. No line can be more than 512 characters long, though a statement can extend of many lines. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: pbalakrishnan@symantec.com (Puru Balakrishnan) >Date: 22 Jun 1995 00:47:58 GMT >X-Informix-List-Id: <news.14864> > > The Release Notes for ESQL/C for Windows states the following limits: > > Size of quoted String literal : 256 chars > Length of Line : 512 chars. > > I am not sure which one of these applies to the maximum length of >SQL Statement which can be passed while PREPARING statements. Is it >256 or 512?