Different values between DataSet and Oracle query

Viewed 34

I've used DataSet and a TableAdapter to connect to my Oracle database which works fine.

But I am getting in my DataPreview in Visual Studio a different and one missing value.

I had never a problem like this in the past.

Please see the attached picture:

PICTURE Problem missing and wrong data

I hope it is understandable.

I've used C#, .NET Framework 4.8 and Oracle PL SQL Oracle Developer 14.

And I used off course the same SELECT to counter check the data:)

Oracle SELECT statement:

select
    to_char(lrg.lroug_date,'DD.MM.YYYY')AS Datum,
    to_char (decode (sum(lcsl.lcsl_qtyhost), 0, 0,
    sum(lcsl.lcsl_qtymissed) * 100) / sum(lcsl.lcsl_qtyhost)), '0D00') as Anteil_in_Prozent
from 
    lcos_ship_line lcsl, lroute lrou, lroute_group lrg
where 
    lcsl.lrou_ref = lrou.lrou_ref
    and lrou.lrou_groupident = lrg.lroug_groupident
    and lrg.lroug_date between trunc(sysdate-7) and trunc(sysdate)
group by 
    lrg.lroug_date, lrpca_ref
order by 1

Problem solved

I had a old tnsnames.ora File on my Computer. Thats because i used to get wrong values from a different server. Thank you all for your Help :)

0 Answers
Related