Re: [foxboro] Decimals in AIM*Historian - ODBC returned data

Have you tried using the Excel add-in (AimHistValue or AimHistArray)?

Andre

-----Original Message-----
From: Control y Automatizacion (Rodolfo Piedra)
[mailto:rpiedra@xxxxxxxxxxx]
Sent: Thursday, February 20, 2003 3:57 PM
To: foxboro@xxxxxxxxxxxxx
Subject: [foxboro] Decimals in AIM*Historian - ODBC returned data


We implemented a data report using following ODBC call in excel, but
returned data has no decimal.

=SQL.REQUEST("DSN=AIM_Historian;AP=S00001;DB=Reduction";;4;"SELECT '"&B$7&"'
FROM '"&B$1&"'  WHERE (Source='"&B$6&"' and Time BETWEEN {ts '"&$C$3&"'} And
{ts '"&$C$4&"'})";TRUE)

Any idea  how to get the data with, at least, one decimal.

Thanks in advance,

Rodolfo Piedra
Control y Automatizacion SA
PO Box 1612-7050
Costa Rica
Celular +506   834-1921
Ph: +506  256-9901
Fax: +506 223-3539  /  257-5392
rpiedra@xxxxxxxxxxx


 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
 
 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave

Other related posts: