cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Having a problem with SQL Request Control

Jump to solution

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

0 Kudos
Reply
2 Replies
Workflow Hero

Re: Having a problem with SQL Request Control

Jump 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.

0 Kudos
Reply
Workflow Hero

Re: Having a problem with SQL Request Control

Jump to solution

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

Reply