TestProject Forum

Send An SQL query to an MSSQL Database

I am using the AddOn “Send An SQL query to an MSSQL Database”. I am using parameters in the query to pass in a string like ‘XXXXXXXX-13-337f-4aec-87f1-4bed0d938616’. When I run this step in the recorder I have no problem.

When I run this in the Test, the single quotes surrounding the string are being changed into " or ‘)’.

Unclosed quotation mark after the character string ‘7fde32cd-bbcf-4fc4-af63-8cf347268851’)’.

Unclosed quotation mark after the character string ‘7fde32cd-bbcf-4fc4-af63-8cf347268851’’

Hi @j.hudgins ,

I’d be happy to help, I would like to know a little bit more details:

  • What do you mean by “run this in the test” ?
  • Can you please elaborate on your intention?