Hi,

OK, here is the suggestion/wish.

We currently have a complex database structure and a lot of
information (almost access rights) are all managed directly into
memory. So, we often have to use the clause "IN" in our queries such
as:

SELECT * FROM EMPLOYEES WHERE EMPLOYEE_ID IN (Item1, Item2,...
Item1500);

The problem is that the "IN" clause has a limitation of 1500 items.
So, it gives us a lot of problems.

Do you know if that limitation could be removed in a next version of
Firebird ?

I already know that I could use the "IN" clause in sub-queries but
this way is not good enough for us.

Thanks to all.

--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@t...> wrote:

> develop111 wrote:
>
> >Hi,
> >
> >Is there a forum where we can submit wishes for enhancements

about

> >Firebird ?
> >
> >Thanks!
> >
> >
> I think the best way is to discuss ir here first and then someone

will

> put more ideas and when the feature is mature, put it on source

forge

> feature requests...
>
> see you !
>
> --
>
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda.
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br