Citadel 4 SQL query

[jabesha]

Is there a method of requesting only the latest data from a Citadel database using SQL over ODBC?

I would like to include the latest data stored by Lookout 4.5.1 in a Citadel database on a web page.  I can access data from the points and traces tables but I can't figure out how to request just the latest data point or the latest trace.  For other databases I would use an sql statement like "Select columnName from tableName where timestamp=Select(Max(timestamp) from tableName)" unfortunately this will not work with Citadel.  Is there any way to retrieve only the latest point or trace for a column?

[Ryan.S]

I don't think you can do it directly by SQL. Citadel doesn't support nested SQL query.

If you use VC or VB, you can query a number of data, and then programmatically get the first row.  Or just query the data 1 sec ago?