| Subject | Re: [firebird-support] stored procedure with list of values as input parameter |
|---|---|
| Author | Ann Harrison |
| Post date | 2012-01-17T17:05:34Z |
On Tue, Jan 17, 2012 at 11:44 AM, Net Newbie <netfirebird@...> wrote:
2, 3, 4") and
creating a SQL string that you feed to EXECUTE STATEMENT.
Ann
>Its not simple, but it can be done using a string parameter (e.g. "1,
> how to create a stored procedure having a list of values as input parameter?
2, 3, 4") and
creating a SQL string that you feed to EXECUTE STATEMENT.
> I need to retrieve result for query looking likeGood luck,
>
> select field1, field2 from table1 where field3 in (1, 2, 3, 4);
>
Ann