On 7 Jun 2005 at 1:01, Adam wrote:

>Your call to prepare should NOT happen inside the FOR loop.

It does not matter much. IBX does not prepare statement more than
once, so it is just one call and one If inside.

>Secondly, consider using ParamByName for your own sanity in 6 months
>time :)

You are right here. Unfortunatelly, there is no performance
difference between ParamByName and Param by number. Inside every
value assignment there is a loop though all params with name
comparsion. (It was one reason why I made my own component set.)
--
SY, Dimitry Sibiryakov.