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