Academic Company Events NI Developer Zone Support Solutions Products & Services Contact NI MyNI

Document Type: Example Program
NI Supported: Yes
Publish Date: Nov 27, 2007

Subscribe

Add to Del.icio.us

DIGG this!


Feedback


Yes No

Related Categories

Products

Development Topic

Related Links - Developer Zone

Related Links - Products and Services

Querying Citadel Database and Exporting Data to Excel

4 ratings | 4.00 out of 5
Print

Downloads

Filename: citadel_export_to_excel.zip
Requirements: View

In this example, values from a Pot are logged into the Citadel database. The values are retrieved using an SQL query within a DataTable (Table1) object. The example process allows the user to specify the start and the stop time from the control panel itself, without having to modify the query each time. Another DataTable (Table2) is also populated with the queried results. These two DataTables are linked through DDE. The second DataTable is created so that the queried values can then be exported to an XLS file.

How to set up the example:

1) Create a new ODBC Data Source Name pointing to the Citadel database folder (an example Citadel database is zipped in the attachment). Refer to the "Setting up Lookout's Citadel Database as an ODBC Data Source" (LINKED BELOW) for more information on creating the data source.

2) Follow the instructions in the Readme.doc file zipped in the attachment.

Requirements


Filename: citadel_export_to_excel.zip

Software Requirements


Application Software: Lookout Development/Runtime Systems 5.1
Language(s): None

 
4 ratings | 4.00 out of 5
Print

Reader Comments | Submit a comment »

 

Legal
This example program (this "program") was developed by a National Instruments ("NI") Applications Engineer. Although technical support of this program may be made available by National Instruments, this program may not be completely tested and verified, and NI does not guarantee its quality in any way or that NI will continue to support this program with each new revision of related products and drivers. THIS EXAMPLE PROGRAM IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND AND SUBJECT TO CERTAIN RESTRICTIONS AS MORE SPECIFICALLY SET FORTH IN NI.COM'S TERMS OF USE (http://ni.com/legal/termsofuse/unitedstates/us/).