FB7 error executing SQL

FinalBuilder Discussion
1

Hey all,

This is a strange one.

I have a MSSQL Execute SQL task that contains the following SQL:

sp_change_users_login 'auto_fix', 'ecobomuser'

This fails when run with:

Msg 105, Level 15, State 1, Server MARKEV07D, Line 1
Unclosed quotation mark after the character string 'ecobomuser
'.
Msg 102, Level 15, State 1, Server MARKEV07D, Line 1
Incorrect syntax near 'ecobomuser
'.
Execute failed, return code: 1
 

However, if I put a space at the end of the line, after the closing ' - it works!

2

Thanks Mark, the fix will be in the next test build of FinalBuilder 7. I’ll let you know when it’s available.

Regards,
Paul.

3

Hi Mark,

Here is the new test build of FinalBuilder 7:

URL: https://www.finalbuilder.com/forum.aspx?aft=10062

Regards,
Paul.