AnsweredAssumed Answered

Having a problem with SQL Request Control

Question asked by brianknight on May 18, 2018
Latest reply on May 18, 2018 by brianknight

I'm attempting to utilize a sql request control on my form.  My connection to the sql server tests out fine.  When I type in in the test query it will even test out fine.  However, as soon as I close the test and run, nothing will show up in the control.  When I go back into the run now and run a test query, I see the following error "Incorrect syntax near ' '.  My sql query is pretty simple.  Here is my query

SELECT TOP 1000 [PositionTitle]
FROM [Reporting].[dbo].[vwPositionTitle]

Here are my screenshots of what I'm seeing

 

 

Outcomes