Using function with Citadel database

[FRRO]

Hi,



I tried to retrieve the Maximum Data from a column of a Citadel Database with Labview 7.0 Without success
The driver version of the Citadel databas is 4.05.00.204.

When I want to get all the data of a Column, it works very well. For this action, I'm using the following
SQL:
SELECT "\\48CKP9P693\Process1\Counter12W4BlowoffStops.W4_Blowoff_Stops"
FROM Points

To get the MAX, I tried many way to write it without succes. I tried

SELECT MAX ("\\48CKP9P693\Process1\Counter12W4BlowoffStops.W4_Blowoff_Stops")
FROM Points
I also tried
SELECT "MAX{\\48CKP9P693\Process1\Counter12W4BlowoffStops.W4_Blowoff_Stops}"
FROM Points

Any idea what can be my problem?

Tx

[Zvezdana S.]

Averna,

The second method:
SELECT "MAX{\\.......}"
should work, but you have to make sure you don't have any spaces in it.

Zvezdana S