08-30-2011 08:14 AM
Hi,
I'm trying to use the query below to maintain trend info in a citadel query.
SELECT IntData.LocalTime, IntData."BOIBUMBA/NUEX/C7981"
FROM IntData
WHERE (IntData.LocalTime BETWEEN (SELECT MAX(RawData.LocalTime) FROM RawData WHERE RawData.LocalTime <= {ts '2011-07-01 11:41:45'}) AND (SELECT MIN(RawData.LocalTime) FROM RawData WHERE RawData.LocalTime > {ts '2011-08-01 11:41:45'}))
AND (IntData.IntInterval = '0:1')
The driver returns "No trace was specified".
Can I use IntData and RawData in the same query? Can I use subqueries like this above? Where to find documentation about SQL queries in citadel? Are citadel driver SQL-92 compliant?
09-01-2011 10:10 AM - edited 09-01-2011 10:11 AM
Good afternoon, Bruno,
Follow the links to help better understand the use of each function. Any questions please contact us.
Accessing Citadel 5 Data from Other Software
http://zone.ni.com/devzone/cda/tut/p/id/6668
Accessing Citadel 5 Data from Other Software
http://zone.ni.com/devzone/cda/tut/p/id/6668
Accessing Citadel 5 Data with Microsoft Excel 2007
http://zone.ni.com/devzone/cda/tut/p/id/2970
Sincerely,
Mauro Vera.
09-01-2011 01:47 PM
Hi Mauro
I read this articles and doesn't have what I want. I want make a query thats I will get start and stop time from RawData and then get interpolated data from IntData in this interval.
Many thanks for the help.
Bruno Costa