GrumpyRain wrote:

>
> Hello,
>
> 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"
>

It may be a size limitation (for PLANs) in older versions of IB/Fb.


--
Aage J.