Re: [foxboro] IA Batch Reporting

Which version of I/A Series Batch?

Alex Johnson
Invensys Systems, Inc.
10707 Haddington
Houston, TX 77043
713.722.2859 (office)
713.722.2700 (switchboard)
713.932.0222 (fax)
ajohnson@xxxxxxxxxxx
For the latest information on ArchestrA, go to
www.invensys.com/Archestra.html.

 -----Original Message-----
From:   Jon Simon [mailto:Jon.Simon@xxxxxxxxxxxx] 
Sent:   Friday, May 16, 2003 1:34 PM
To:     foxboro@xxxxxxxxxxxxx
Subject:        [foxboro] IA Batch Reporting



Report Manager in IA Batch uses a variant of SQL to generate reports. I
would
like to generate a report for the last 24 hours (or previous day) using a
SQL
script. However, there is no information on RptSQL's (the SQL editor for IA
Batch) SQL syntax. Specifically on how to use and manipulate the date and
date-time variables, so that the reports can be generated for a certain
period.
Any information or sample scripts would be appreciated.
Thanks,
Jon Simon
Lever Pond's South Africa
 
 
_______________________________________________________________________
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: