Academic Company Events NI Developer Zone Support Solutions Products & Services Contact NI MyNI
This Document is not yet Rated  Rate this Document

Using Tag Names In MS Access To Retrieve Data From Citadel

Primary Software: Lookout
Primary Software Version: 6.0
Primary Software Fixed Version: N/A
Secondary Software: N/A

Problem:
I am trying to use Microsoft Access to retrieve data from a Citadel database, but when using a tag name in the Criteria Field, I get an error that says "Not a valid truth condition". How can I use tag names to retrieve data from Citadel?

Solution:
The Citadel database is not indexed by tags, so tags cannot be used in the Criteria Field.

After creating an ODBC data source for Citadel, you can query the database using native members like "Interval", "LocalTime" and "Resolution".

Please refer to the following NI Developer Zone tutorial for more information.

Related Links:
Developer Zone: Accessing Citadel Data with Microsoft Access


Attachments:





Report Date: 10/31/2002
Last Updated: 07/20/2007
Document ID: 2QUB99VS

Your Feedback! poor Poor  |  Excellent excellent   Yes No
 Document Quality? 
 Answered Your Question? 
  1 2 3 4 5
Please Contact NI for all product and support inquiries.submit