> > > I'm using Firebird with IB Objects. I need to submit a list as a
> > > paramter in this statement:
> > >
> > > SELECT * FROM MYTABLE WHERE ID IN (:MYLIST)
> > >
> > > Is there a way to make this work without having my code supply a new
> > > SQL statement each time?
> >
> > each time what? each time you change the list?
> > Alan
>
> Yes, each time the list changes I need to requery

That's correct - change the list - change the query.
Build the query on the client side as a fixed string each time, or write a
selectable SP which takes a suitably sized varchar as a string parameter,
then parse it server side each time.
Alan