Re: CONSTRUCT bytes

>Message-Id: <9205261358.AA23594@rmy.rmy.emory.edu> >Date: Tue, 26 May 92 9:54:31 EDT >From: "John Baker, Lex-Blue Grass Army Depot" <uunet!lexington-emh2.army.mil!jbaker> >Subject: CONSTRUCT bytes >X-Informix-List-Id: <list.1202> > >How many bytes does the Construct clause (version 4.0) require for the variable >that will hold the selection criteria ("char-variable" in the syntax below)? > > CONSTRUCT char-variable ON column-list FROM field-list You need to look at the output of CONSTRUCT (which is the string in the variable "char-variable". It is printable text. If your CONSTRUCT is: CONSTRUCT wh ON sometable.somecolumn FORM s_query.* and you type "A|B|C" because somcolumn is a CHAR(1) column, then the output string will probably be: (sometable.somecolumn='A' or sometable.somecolumn='B' or sometable.somecolumn='C') or sometable.somecolumn in ('A', 'B', 'C') give or takes some blanks and new lines. Either way, you can begin to see why you needed more characters than you thought. Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>