>-----Original Message-----
>From: Alex Strickland [mailto:s...@mweb.co.za]
>Sent: Tuesday, December 01, 2009 1:22 PM
>To: Harbour Project Main Developer List.
>Subject: Re: [Harbour] Problem in OLE implementation
...
>REQUEST ADORDD
>
>function Main()
>
> USE xbrtest.mdb VIA "ADORDD" TABLE "Customer"
>
> Browse()
>
> USE
>
>return nil
>
>It appears to work very well, the browse showing me all the
>customer details. I think it should be restored to SVN.
>
>Thanks and regards
>Alex Strickland
Alex, with ADO I can read from thrue SQL database only characters
fields.
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
....
All numeric or data fields must be covert to character. With ODBC\MIXSQL
all work correct.
Regards,
Marek Horodyski
_______________________________________________
Harbour mailing list (attachment size limit: 40KB)
Harbour@harbour-project.org
http://lists.harbour-project.org/mailman/listinfo/harbour
