|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
September 10th, 2006, 12:38 AM
|
|||
|
|||
|
Limit of 'IN' statement
I am developing an accounting system with firebird 1.5.3 and vb6. i got a problem with this query which has more than 1500 search parameter
select id from sub_groups where name in ( more than 1500 names in here ) firebird has returned error, which concluded that it has a limit of 1500 parameter in 'IN' query. is it the limit of firebird or what, any solution if anybody have out there please tell me asap.
|
|
#2
September 10th, 2006, 04:53 AM
|
||||
|
||||
|
It might be a limit of Firebird but I would say that an application that uses an IN on 1500 names is most certainly flawed and in bad need of some kind of join.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Limit of 'IN' statement |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
