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]
Here are my screenshots of what I'm seeing
Solved! Go to Solution.
sounds like it turned line feed character into some unreadable one and now it doesn't recognize it.
could you try with all the statement written on single line.