🚀 go-pugleaf

The other queries don't have this Problem.
So I tried another SQL- Syntax.

The next SQL- Statement does work:
-------------------- SQL
select k.nrdispo,k.nrmandant
FROM admin.sd_kombi_prod k,
             admin.ep_gfk_ratings r,
             admin.ep_potentiale p,
             admin.sd_user u,
             admin.sd_user_kunde uk,
     admin.ep_disp_faktor df
WHERE   k.wb_id = r.wb_id(+)
     AND k.nrkunde=uk.nrkunde
    AND u.id_user=uk.id_user
    AND u.id_user=9
   AND k.datum = p.datum
      AND k.sender_id= df.sender_id(+)
   AND k.datum BETWEEN df.dat_von (+) AND df.dat_bis (+)
   AND k.spotdauer BETWEEN df.min_sek(+) AND df.max_sek (+)
AND k.datum <= (SELECT MAX(datum) FROM ADMIN.Ep_Gfk_Inseln)
and k.nrdispo=426283

-------------------- SQL
The field "nrmandant" (an Integer) is shown right.


This SQL- Statement dosen't work how I want. The ClientDataSet can't work
with it:

-------------------- SQL
select k.nrdispo,k.nrmandant
FROM admin.sd_kombi_prod k,
             admin.ep_gfk_ratings r,
             admin.ep_potentiale p,
             admin.sd_user u,
             admin.sd_user_kunde uk,
     admin.ep_disp_faktor df
WHERE   k.wb_id = r.wb_id(+)
     AND k.nrkunde=uk.nrkunde
    AND u.id_user=uk.id_user
    AND u.id_user=9
   AND k.datum = p.datum
      AND k.sender_id= df.sender_id(+)
   AND k.datum BETWEEN df.dat_von (+) AND df.dat_bis (+)
   AND k.spotdauer BETWEEN df.min_sek(+) AND df.max_sek (+)
AND k.datum <= (SELECT MAX(datum) FROM ADMIN.Ep_Gfk_Inseln)
and k.nrdispo=426283
union all
select k.nrdispo,k.nrmandant
  FROM admin.sd_kombi_prod k,
             admin.edi_prog_ratings r,
             admin.ep_potentiale p,
             admin.sd_user u,
             admin.sd_user_kunde uk,
     admin.ep_disp_faktor df
WHERE k.wb_id = r.wb_id(+)
    AND k.nrkunde=uk.nrkunde
    AND u.id_user=uk.id_user
    AND u.id_user=9
   AND k.datum = p.datum
      AND k.sender_id= df.sender_id(+)
   AND k.datum BETWEEN df.dat_von (+) AND df.dat_bis (+)
   AND k.spotdauer BETWEEN df.min_sek(+) AND df.max_sek (+)
AND k.datum > (SELECT MAX(datum) FROM ADMIN.Ep_Gfk_Inseln)
and k.nrdispo=426283
-------------------- SQL

now the field "nrmandant"  is shown as an defaultvalue " berlauf" for the
overflow- Error.

Is it a bug ?

How chan I fix my Problems ?

Andreas