Skip to main content

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].tdbo].[vwPositionTitle]

Here are my screenshots of what I'm seeing

215523_pastedImage_1.png

215524_pastedImage_2.png

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.


Ok that worked.  Odd error.  Thank you for your help.


Reply