how to query the citadel database

[frank me]

Is there a way using Lookout to query the citadel data base?

I have value that is being saved every second say, into the citadel database

a specific record may look like this for the field   

MON_DS  = "7:57"  

Local Time  =  "2/19/06 15:59"

I want to have the user enter a date and then lookout to query the citadel database and find the

maximum value for MON_DS for that date.

Is this possible in lookout?

I can download the data to a spreadsheet but that is alot of work to load each of the fields & local time records

frank

[Khalid]

Hi Frank,

It's been a while since I have done this, but it is (was??) doable.  You will need to use the SQLExec Object.  I must further warn you that the query syntax used is rather esoteric. 

The following KB articles may come in handy:

Syntax For SQL Commands For The DataTable And SQLExec Objects In Lookout

How Do I Format SQL Commands in Lookout?

Good luck!

-Khalid

[frank me]

Thanks Khalid,

I understand the structure of the SQLExec object, but how do i display the number that i am looking for?

The query should retrieve a value from the field defined in the SQLExec object but how do i display it?

frank

[Khalid]

Hi Frank,

You would use the "c" datamembers (see below), of the right datatype:

SQLExec Data Members

Data Member	Type	Read	Write	Description
c1 – c65535	numeric	yes	no	Value of the nth column in the row returned by ODBC.
c1.logical – c65535.logical	logical	yes	no	Value of the nth column in the row returned by ODBC.
c1.txt – c65535.txt	text	yes	no	Value of the nth column in the row returned by ODBC.

-Khalid