1 ratings:

5 out of 5

Rate this Document

[SQL Toolkit] SQL Statement Error "Unexpected text at end of SQL query : 'AS' "

Primary Software: LabWindows/CVI Add-ons>>Enterprise Connectivity Toolset
Primary Software Version: 1.1
Primary Software Fixed Version: N/A
Secondary Software: N/A

Problem: I am issuing an SQL Select command:

"SELECT A.Name, A.Address, EEPROMDescrip.Description FROM EEPROMTable AS A, EEPROMDescrip WHERE A.Value = '05' AND EEPROMDescrip.Description='VCO_ADJUST' "

which fails.

Solution: You are hitting an implementation issue with SQL. The underlying SQL package that we are using is from Intersolv and the "AS" keyword is not recognized, so just try "...FROM EEPROMTable A,...".

Related Links:

Attachments:





Report Date: 08/14/1997
Last Updated: 12/05/2004
Document ID: 10DDT8TL

Your Feedback!	Poor  |  Excellent							Yes	No
Document Quality?							Answered Your Question?
	1	2	3	4	5
Document needs work? Please tell us why.
Please Contact NI for all product and support inquiries.