I have a IB_Query with the following SQL-Statement:
select
FD.FDID,FD.FDDCID,FD.FDDFID,FD.FDBONUS,
A.FMID,A.FMFDID,A.FMMPID,(select MPNAME from MAINPRODUCTGROUPS where
MPID=A.FMMPID) as MPNAME,A.FMDISCOUNT,A.FMDISCOUNTNEW
,
B.FMID,B.FMFDID,B.FMMPID,(select MPNAME from MAINPRODUCTGROUPS where
MPID=B.FMMPID) as MPNAME,B.FMDISCOUNT,B.FMDISCOUNTNEW
,
C.FMID,C.FMFDID,C.FMMPID,(select MPNAME from MAINPRODUCTGROUPS where
MPID=C.FMMPID) as MPNAME,C.FMDISCOUNT,C.FMDISCOUNTNEW
from
FOLLOWUPDISCOUNTS FD,
FOLLOWUPDISCOUNTS_MP A
,
FOLLOWUPDISCOUNTS_MP B
,
FOLLOWUPDISCOUNTS_MP C
where
A.FMFDID=FD.FDID
and A.FMMPID=11
and
B.FMFDID=FD.FDID
and B.FMMPID=12
and
C.FMFDID=FD.FDID
and C.FMMPID=13

When I open the query, I have the phenomenom, that only the selected row
has the right values. This means, when I select the first row, it shows
the correct values and all other rows show the same, but wrong values.
Now I select for example the third row, now this row has the correct
values and all other show wrong values.
When I execute the SQL-Statement with a IB_Cursor, all is fine, only
IB_Query has this strange behaviour. Can anybody tell me, where the
problem is ?

Guido.