At 07:51 AM 21/02/2004 +0700, you wrote:

>Followed yours suggestion ( with no repeatable usage of :empid_2 and
>without order by clausul ), its WORKS.
>For now i will trying to eleminated using repeatable parameter as possible.
>
>It is will be fixed on next release of firebird ?

there's nothing to fix. Parameters aren't variables, they are
placeholders. The server receives them at prepare time, in an ordered
array. At execution time, the client passes an array mapping values to the
placeholders, by array position. So it's a mistake to suppose that you can
pick up those placeholders and use them in multiple places as if they were
variables.

/hb