[foxboro] AIM Event DB inconsistent query-result

Hello,

We have encountered a weird phenomenon, doing query on a AIM-event
database using OleDb and C#. The AIM-db has Column 'Time'. When running
the exact same query several times consecutively. The returned Time-value
differs by as much as 5 seconds! This phenomenon can also be reproduced
using Excel and ODBC.

For the record, we used: AIM*API 5.5.0 and AIM*ODBC 3.02.03.51

We found that the 'Time' Column in AIM appears to be stored as seconds
since epoch. But in the C#-Dataset it is received as a Datetime.

Does anyone have any ideas on this matter?
Is it posible to retrieve the Time-value as a Long instead of a
(calculated?) datetime?

Regards,
Sander/Martjan
 
 
_______________________________________________________________________
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: