Subject Re: [firebird-support] Max number of query parameters?
Author Kjell Rilbe
Den 2011-08-31 15:49 skrev Kjell Rilbe såhär:
> What is the maximum number of query parameters for Firebird? Has it
> changed between 2.1 and 2.5 and will it change in 3.0?

A bit of testing: with a query testing for equality with a varchar
column it accepted up to 162 parameters.

But on the same table, it seemed to accept several thousand parameters
on a bigint column.

So does this mean that there's no hard limit to the COUNT of parameters,
but there IS a limit to the data SIZE required by the parameters?

If so, what is that limit?

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64