The following SQL query is a simplified test to use a temporary table. Select ClassifierID, Well Into #temp From tblClassifierResults Where ClassifierID LIKE 'CNTR0015316%' Select * from #temp When I ran this query from the 'SQL management studio', I could get the correct results. However when I ran it in LabView, no results were returned. If I took the temporary table out of the query, it worked fine in LabView. Anybody has idea what I did wrong in the first query with temporary table? I appreciate your thoughts and help.

Hi! This is applies to MS SQL server, but may apply to others in a similar way, too. If you execute two SELECTs in a single query, you will get two results, each followed by some statistics about the query, which also mark the end of the current result. See for example this screenshot from my DB client "DBeaver" : (OK, this is boring, two times the same query and the same result, but yet, two results) The point is, when the first query does not return anything, there is still an empty result plus statistics sent back to the client. Most clients suppress empty results automatically, and only display non-empty results. Labview... does not. Instead, it stops reading the result when it recognizes the first statistics information. The solution is to disable those statistics by sending SET NOCOUNT ON; at the beginning of the query:

LabVIEW

SQL query does not return results

Solved!

Author

Hi, David,

sorry to bother, but I just posted another question about a query time out error here

https://forums.ni.com/t5/LabVIEW/SQL-query-time-out-error/td-p/4142892

can you please take a look and share your idea? Thanks much.

Message 11 of 11

(531 Views)

LabVIEW

SQL query does not return results

Re: SQL query does not return results