MSSQL - Execute query module - fails in assembly editor

1

Been working with the “Execute INSERT, UPDATE, or DELETE SQL statement” for SQL Server. When I run a statement in the assembly editor, it errors saying it needs a semicolon even though one exists in the statement. I am assuming it is the way action input handles variable arrays in the test data separated by a semicolon and drops it or something. When I use the exact same statement in the automation, works fine.

Just wanted to point it out so you could take a look at it.

2

Sorry, it’s a known limitation of the action module in the way it uses semicolons as a way to delineate array values for test data:

image
image2534×446 68.2 KB

So by placing a semicolon in the test data field the module thinks it is an array and won’t emit the semicolon in the test data output when testing in the assembly editor.