Hi,
you must to set this so:
SELECT FROM TABLE 1 WHERE ID IN ('1', '2', '4', '6')
or
SELECT FROM TABLE 1 WHERE ID IN (1, 2, 4, 6)
Ing. R. Muras.
2011/5/3 Maxim Kuzmin (JIRA) <trac...@firebirdsql.org>
> IN with string, contained multiple values
> -----------------------------------------
>
> Key: CORE-3460
> URL: http://tracker.firebirdsql.org/browse/CORE-3460
> Project: Firebird Core
> Issue Type: Improvement
> Reporter: Maxim Kuzmin
> Priority: Trivial
>
>
> When using WHERE with IN (), for condition allowed only single value
> (integer or varchar). When using string-condition with multiple values, it's
> raise exception:
> SELECT FROM TABLE 1 WHERE ID IN ('1') -- OK
> SELECT FROM TABLE 1 WHERE ID IN ('1, 2, 4, 6') -- EXCEPTION
> Also, this behavior does not use string parameters, such as WHERE ID IN
> (:LIST_ID).
>
> --
> This message is automatically generated by JIRA.
> -
> If you think it was sent incorrectly contact one of the administrators:
> http://tracker.firebirdsql.org/secure/Administrators.jspa
> -
> For more information on JIRA, see: http://www.atlassian.com/software/jira
>
>
>
>
> ------------------------------------------------------------------------------
> WhatsUp Gold - Download Free Network Management Software
> The most intuitive, comprehensive, and cost-effective network
> management toolset available today. Delivers lowest initial
> acquisition cost and overall TCO of any competing solution.
> http://p.sf.net/sfu/whatsupgold-sd
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its
next-generation tools to help Windows* and Linux* C/C++ and Fortran
developers boost performance applications - including clusters.
http://p.sf.net/sfu/intel-dev2devmay
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
