Subject RE: [IBO] Index out of bounds when reuse params
Author Alan McDonald
> Hi,
>
> In some cases when I reuse parameters I get "index out of bounds"
> error.
>
> SQL like
>
> SELECT ...
> WHERE A.X=:TEST
> AND B.X=:TEST
>
> To solve this problem I have to create 2 TEST parameters with the
> same value
>
> SELECT ...
> WHERE A.X=:TEST1
> AND B.X=:TEST2
>
> IBO Version 4.8.6
>
> It's a version bug?

no - AFAIK it's part of the alltime implementation. You can only assign to
parambyname once. If you use params[] as index, this may be possible. I
always make it a habit not use params of the same name.
Alan

>
> Best Regards
>
> William Rocha