GoLand reports erros when I try to create a string of a query

Getting Help
1

The commented out statement works but when I try to break it up for readability it shows errors (see red):

image
image1207×531 61.6 KB

Also GoLand reports an error for all of the @xxx variables even when I use the commented out version (The code works though):

image
image909×239 56.5 KB

2

First you should check the error of db.Prepare. It should tell you if anything went wrong while parsing the statement. You can also debug and set a breakpoint on db.Prepare and look at the final value of q.
The first thing I can see is that your q is INSERT INTO ( while your commented out string is INSERT INTO [dbo].Priority (

3

Thank you for your response - It is NOT the actual breaking up that is the problem it is the error msgs from the unable to resolve variables such as “Error:(25, 439) Unable to resolve variable ‘@Priority_SHA256’”

I eliminated the breaking up with the q = and q += etc and still get the same errors. I believe this is related to the SQL database source!

See
image