>-----Original Message-----
>From: Massimo Belgrano [mailto:[email protected]]
>Sent: Tuesday, October 13, 2009 12:09 PM
>To: Harbour Project Main Developer List.
>Subject: Re: [Harbour] RDDADO on Beta3
>
>2009/10/13 Horodyski Marek (PZUZ) <[email protected]>:
>>>-----Original Message-----
>> I have tested ADO from contrib.
>> >From Oracle correctly maps only field type CHARACTER.
>> For others types, gives the value of U.
>Can you post a sample (that recreate your problem )
>http://forums.fivetechsupport.com/viewtopic.php?f=3&t=6814
>follow my untested sample
>
>#include "adordd.ch"
>REQUEST ADORDD
>function Main(x_string)
>OPEN CONNECTION x_string
>aDbf := {}
>AADD( aDbf, { "FN", "N", 10, 0 } )
>AADD( aDbf, { "FNF", "N", 12, 4 } )
>AADD( aDbf, { "FC", "C", 40, 0 } )
>AADD( aDbf, { "FD", "D", 8, 0 } )
>AADD( aDbf, { "FL", "L", 1, 0 } )
>AADD( aDbf, { "FM", "M", 0, 0 } )
>dbCreate("dbtest",aDbf)
>? "Creating test database - inserting", nrec, " records"
>use dbtest SHARED via "adordd"
>IF NETERR()
> ? "Unable to open DBTEST "
>ENDIF
>? "INSERT 10 "
>for i = 1 to 10
> append blank
> replace fn with A
> replace fnf with A*A
> replace fc with replicate( CHR(65+A ), 40 )
> replace fd with date() + A
> replace fl with A*2
>next
>browse()
>
>> SQLMIX properly at the moment gives me a values of various types for
>> ORACLE and MS SQL SERVER.
Can you try it with Oracle ?
Here is my query sended via ADO :
select id_dekretacja, to_char( id_dekretacja, '99') dekret, opis,
to_char( sum( case when gr_ik = '3' then kwota else 0 end ),
'999999999999.99') kwota_ik,
to_char( sum( case when gr_ik = '2' then kwota else 0 end ),
'999999999999.99') kwota_gr,
to_char( sum( kwota ),
'999999999999.99') kwota_og
from ( ...
I must all converted to character type, and later to another type from
character.
When have you acces to Oracle server, I can prepare any example.
Regards,
Marek Horodyski
_______________________________________________
Harbour mailing list
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour
