Lookout

cancel
Showing results for 
Search instead for 
Did you mean: 

SQL queries from a Citadel database

We are retrieving data with third-party package SQL queries from a Citadel database. Certain queries for some object members will not return data, but the SQL search application software returns an "error". An analysis of the error from the SQL end does not find problem on SQL side. I suspect corruption of Citadel database. The link to database is good, as most tags do return a value as expected. 
This problem occurred at the time of re-location of the database to a replacement computer.  Any ideas on how to fix such a problem?

0 Kudos
Message 1 of 2
(5,752 Views)

Can you give an example of the "bad" SQL statement and a good one?

Ryan Shi
National Instruments
0 Kudos
Message 2 of 2
(5,736 Views)