Well, I come to a conclusion that Informix 4gl 7.30 could not pass dinamucally a list of strings to a prepared query for use in an IN filter in the WHERE clause... (odd).

The caveat is not pass the string of colors at all with USING.
Instead I statically construct the query adding the string of colors which is variable ans pass dinamically the other parameters:

let c_col = "'blue','red','color'"
let c_sel =
" select count(*) ",
" from some_table",
" where field_code = ? ", --dynamic
" and field_color in (", c_col, ") ", --static-dynamic
" into temp tx ",
" with no log; "

prepare st_sel from c_sel
execute c_sel using 10

Is very simple... which of course is not what I was trying to do originally but achieves the same result...

Anyway I think it is a fault that a collection cannot be passed to preapred statement with Using.

Chucho!

-----Original Message-----
From: vivek.chaudhary (AT) st (DOT) com
To: forum.subscriber (AT) iiug (DOT) org, ids (AT) iiug (DOT) org, John_Carlson (AT) whsmithusa (DOT) com
Date: Thu, 11 Sep 2003 10:55:54 -0700
Subject: RE: How do I pass a collection type to a prepared statement in [1836]

Jean,

I have similar problems by putting the variables in a temp. table, let
us say xyz_temp. Inside your prepared statement, you could say

let c_sel = "select count(*) ",
" from some_table",
" where field_color in (select field_color from xyz_temp) ",
" into temp tx ",
" with no log

Vivek

-----Original Message-----
From: John.Carlson [mailto:John_Carlson (AT) whsmithusa (DOT) com]
Sent: Thursday, September 11, 2003 10:19 AM
To: ids; forum.subscriber
Subject: RE: How do I pass a collection type to a prepared statement in
[1836]


Have you considered the "CONSTRUCT" statement in 4gl?

-----Original Message-----
From: Danny Wright [mailto:dwright (AT) sherwoodfoods (DOT) com]
Sent: Thursday, September 11, 2003 12:14 PM
To: ids (AT) iiug (DOT) org
Subject: Re: How do I pass a collection type to a prepared statement in
[1833]


There may be a better way, but you may have to dynamically build the SQL
statement and not take advantage of the USING for the collection....

It's probably not what you want to do since you have to PREPARE each
time,
but maybe someone has a better idea.




----- Original Message -----
From: "Jean Sagi " <jeansagi (AT) myrealbox (DOT) com>
To: <ids (AT) iiug (DOT) org>
Sent: Wednesday, September 10, 2003 9:56 PM
Subject: [Fwd: How do I pass a collection type to a prepared statement
in
[1829]



"CONFIDENTIALITY NOTICE: This message originates from WHSmith USA Travel
Retail. This email message and all attachments may contain legally
privileged and confidential information intended solely for the use of
the
addressee. If you are not the intended recipient, you should immediately
stop reading this message and delete it from the system. Any
unauthorized
reading, distribution, copying, or other use of this message or its
attachments is strictly prohibited. All personal messages express solely
the
sender's views and not those of WHSmith USA Travel Retail. This message
may
not be copied or distributed without this disclaimer."





Jean Sagi
jeansagi (AT) myrealbox (DOT) com
jeansagi (AT) netscape (DOT) net


sending to informix-list