Subject Re: "In List" - Can list be a parameter?
Author ra8009
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:
> > 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