| Subject | Re: [firebird-support] Where field in (1,2,3) limitation to 1500 |
|---|---|
| Author | Alexandre Benson Smith |
| Post date | 2004-01-30T20:26:57Z |
At 20:54 30/01/2004 +0100, you wrote:
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...
HTH
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
----------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004
[Non-text portions of this message have been removed]
>HiHi,
>
>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
>HB
>Norway
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...
HTH
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
----------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004
[Non-text portions of this message have been removed]