Hello Daniel,

I just have punctually tested your SQL-example and have not
encountered such problem.
What IBO version are you using?
I had tested with IBO4.6Bc+hotfix
both FireBird 1.5.3 and FireBird 2.0 (RC5).

--
Best regards,
Ramil R. Khabibullin khabibr@...

>
>
>
>
>
> Hello there,
>
> This is FYI, I'll solve the problem by changing the SQL statement to a
> more "sane"
> version.
> Here is what I encountered with the following SQL, anyways:
>
> select
> u.id, u.name, u.u_us,
> case when( exists(select a.* from
> add_agents a where a.id_main=:id_add and a.id_user=:id_user) ) then
> "I" else
> case when( exists(select a.* from add_agents a where
> a.id_main=:id_add) ) then
> "T" else
> "F"
> end
> end as has_agents from
> sys_users u where u.id=:id_salesman
>
> I need to get three different kinds of information that I have squeezed into
> this single statement:
> - Am I the agent for the address?
> - If not, does the address have other agents assigned?
> - What's the name of the supplied user? (No relation to any address here)
>
> This might not be the most noble way to do it, but that's not the matter
> here. The problem I encountered is that the parameter-values for
> id_add and id_salesman are mixed up. The query does not work
> as expected when I do the following:
>
> C.ParamByName('id_add' ).AsInteger := AdressId;
> C.ParamByName('id_user' ).AsInteger := UserId;
> C.ParamByName('id_salesman').AsInteger := SalesmanId;
>
> But it works fine when I exchange the values for id_add and id_salesman:
>
> C.ParamByName('id_salesman').AsInteger := AdressId;
> C.ParamByName('id_user' ).AsInteger := UserId;
> C.ParamByName('id_add' ).AsInteger := SalesmanId;
>
> I tried the same query with IBPP, a lower-level Interbase/Firebird API and
> it worked as expected without mixing any values, so I highly suspect
> IBObjects as the culprit.
>
> If you need more background information to reproduce the problem,
> please let me know.
>
> Regards,
> Daniel Albuschat
>
> --
> eat(this); // delicious suicide