|Subject||Re: [firebird-support] Limits of IN operator with Delphi 7|
>It may be a size limitation (for PLANs) in older versions of IB/Fb.
> I have a problem with a query using the 'IN' operator.
> The query looks like this:
> Select ID, Name, Contact
> from Customer
> where ID in (1,2,3,4,5,6,7,8,..... etc)
> I am using the standard TIBQuery component in Delphi 7. I am modifying
> the SQL property according to the user selection. When you send lots
> of numbers, (about 160 values or so), you get an exception:
> "EIBClientError: Unknown Error - Can't retrieve plan"