Re: [foxboro] Decimals in AIM*Historian - ODBC returned data.Automatic Excel reports

Thanks, you right.

Now we are facing the problem with automatic reports. We configured an
excel-ODBC reports which now works perfectly in interactive mode.

We added an Auto_Open macro, it saves the report (just data, no functions)
and quits automatically. If we manually run this sheet, it performs as
expected but when we schedule it using NT´s "task scheduler" the ODBC
function calls "SQL.Request" returns no data.

Any idea will be appreciated.

Thanks in advance,

Rodolfo Piedra



----- Original Message -----
From: "Omori, Suzi" <SOmori@xxxxxxxxxxx>
To: "'Control y Automatizacion (Rodolfo Piedra) '" <rpiedra@xxxxxxxxxxx>
Sent: Saturday, February 22, 2003 1:20 AM
Subject: RE: [foxboro] Decimals in AIM*Historian - ODBC returned data


> Take a look at your Windows Regional Settings:
> Keep in mind that in USA they use (.) as decimal notation....
>
> Regards,
> Suzi
>
>
> -----Original Message-----
> From: Control y Automatizacion (Rodolfo Piedra)
> To: foxboro@xxxxxxxxxxxxx
> Sent: 20/Feb/2003 7:57 PM
> 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: