RE: [Harbour] Trouble with SqlRdd
-Original Message- From: Mindaugas Kavaliauskas [mailto:dbto...@dbtopas.lt] Sent: Friday, February 26, 2010 7:18 PM To: Harbour Project Main Developer List. Subject: Re: [Harbour] Trouble with SqlRdd *--- Hi, Marek, for sure I can help you but I need a self contained sample that does not require installation of servers I do not have. Can you made a sample like contrib/rddsql/sddodbc/test/test1.prg and attach .mdb file if it is a problem Microsoft DB? If I do not have self contained sample I need a precise debug info about field types and other field parameters both in SQL language and ODBC API presentation. * Maybe somewhere in the world is exposed to a test Oracle or MsSql server? I will try to find and prepare for the test. Acces I do not use - but can *. mdb I can do something. Appeal to, as I have "example". Regards, Marek Horodyski ___ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
Re: [Harbour] Trouble with SqlRdd
Horodyski Marek (PZUZ) wrote: 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? Hm, mostly I have in harbor\odbc zero when count(*) or sum( ...) are in the query. In sql tools (toad, sql developer etc.) I see correctly value. The problem of care for converting query (numeric fields) into the text - but it's only a workaround, and this should fix it somehow. Hi, Marek, for sure I can help you but I need a self contained sample that does not require installation of servers I do not have. Can you made a sample like contrib/rddsql/sddodbc/test/test1.prg and attach .mdb file if it is a problem Microsoft DB? If I do not have self contained sample I need a precise debug info about field types and other field parameters both in SQL language and ODBC API presentation. Regards, Mindaugas ___ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
RE: [Harbour] Trouble with SqlRdd
-Original Message- From: Horodyski Marek (PZUZ) Sent: Thursday, February 25, 2010 4:38 PM To: harbour@harbour-project.org Subject: [Harbour] Trouble with SqlRdd I have problem with data from Oracle. Here is ask and answer : [...] Hm, mostly I have in harbor\odbc zero when count(*) or sum( ...) are in the query. In sql tools (toad, sql developer etc.) I see correctly value. The problem of care for converting query (numeric fields) into the text - but it's only a workaround, and this should fix it somehow. Regards, Marek Horodyski ___ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
[Harbour] Trouble with SqlRdd
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-CINK-6-13021P1150-0-K0-00-3550-3550-0 0 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-CINK-6-13021P1150-0-K0-00-3550-3550-0 0 [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) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
Re: [Harbour] Trouble with SQLRDD
Horodyski Marek (PZUZ) wrote: Mindaugas, from time to time, in this syntax : ... Many work on SQL's tables, inserts etc. dbUseArea( .T., 'SQLMIX', "select * from table","TABLE" connect) Board() // my Browse function () dbCloseAll() // <-- here is error ? RDDINFO( RDDI_DISCONNECT, connect) Hi, can you use SVN revision 12995 (2009-11-23) or more new. Connection counters are implemted. This should fix GPF if area is closed after connection is closed. Regards, Mindaugas ___ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
