Subject Re: [firebird-support] Where field in (1,2,3) limitation to 1500
Author Alexandre Benson Smith
At 20:54 30/01/2004 +0100, you wrote:

>FB 1.5 RC 8
>When using "where field in (1,2,3) " I have noticed the 1500 table
>limit. This is mostly adequate but in some rare occasions it is wish
>able to have more table entries.
>Will this value be extended ?
>Can anybody suggest a better way of obtaining this ?
>Thank you !
>Best Regards


Can extract those values from a select statement ?

Something like:

Select * from table1 where field1 in (select field2 from table2)

If you have arbritary values you could insert then on a temporary table and
make a select like the above...


Alexandre Benson Smith
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil


Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004

[Non-text portions of this message have been removed]