I have problem with data from Oracle.
Here is ask and answer :
Ask :
SELECT konto_produkt, SUM (prowizja) prowizja
FROM wynik_interfejsu
GROUP BY konto_produkt
Answer in Toad :
.....
5010013310-CINK0000-6-13021P1150-00000-0000K0-0000000000-3550-3550-00000
00000 0.07
.....
And in Harbour :
dbUseArea( .T., "SQLMIX", "select konto_produkt, sum( prowizja) prowizja
from wynik_interfejsu group by konto_produkt", "PROWIZJA_Z_BAZY_KG")
TYPE LEN NAME VALUE
[1 ].C.. 77 KONTO_PRODUK
5010013310-CINK0000-6-13021P1150-00000-0000K0-0000000000-3550-3550-00000
00000
[2 ].N... 0 PROWIZJA.... 0
in certain records incorrectly see the numeric values (zero of len and
value).
I use Harbour 2.0.0beta3 (Rev. 12489) on WinXP SP3 and both ODBC client
(Oracle and Microsoft).
I could not use the current version, as I have in the GPF.
How this can somehow improve in the sqlrdd?
Regards,
Marek Horodyski
_______________________________________________
Harbour mailing list (attachment size limit: 40KB)
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour
