We do this kind of query by building the (0,12,34) in a string and manually
adding it to the sql before sending to the database.







Dayna Sherstobitoff

------------------------------------------

Liquid Software Designs, Inc.
2474-108 Walnut St.
Cary, NC 27518
------------------------------------------
D: 919.373-4300

O: 866.618.1531
F: 866.394.5961

dayna@...

<http://www.liquidsoftwaredesigns.com/> www.liquidsoftwaredesigns.com



This E-mail and any files transmitted with it are confidential, may contain
sensitive information, and are intended solely for the use of the individual
or entity to whom they are addressed. If you have received this E-mail in
error, please notify the sender by reply E-mail immediately and destroy all
copies of the E-mail and any attachments.

myhead





From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of schimmi62
Sent: Wednesday, July 18, 2012 09:04 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] WHERE clause with IN





Hi.

Is it possible to use Params with a
"select * from table where typ_id in (10,12,15)" query?

If not, which is the best approach?

TIA

Jörg





[Non-text portions of this message have been removed]