|Subject||RE: [firebird-support] Re: "In List" - Can list be a parameter?|
> > > I'm using Firebird with IB Objects. I need to submit a list as aThat's correct - change the list - change the query.
> > > 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
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.