Error:(22, 439) Unable to resolve variable '@Priority_SHA256'

I am using mssqlserver and this code results in errors similar to the above for every @xxx variable.  It runs fine but how do I get rid of the errors?

case "Priority":
    stmt, err = db.Prepare("INSERT INTO [dbo].[Priority] ([Priority_SHA256], [moveAceAcross], [moveDeuceAcross], [move3PlusAcross], [moveDown], [moveEntireColumn], [flipWasteToStock], [flipStockToWaste], [movePartialColumn], [moveAceUp], [moveDeuceUp], [move3PlusUp], [badMove], [flipSt->W Max-0], [flipSt->W Max-1], [flipSt->W Max-2], [flipSt->W Max-3], [flipSt->W Max-4], [flipSt->W Max-5], [flipSt->W Max-6], [flipSt->W Max-7]) VALUES (@Priority_SHA256, @moveAceAcross, @moveDeuceAcross, @move3PlusAcross, @moveDown, @moveEntireColumn, @flipWasteToStock, @flipStockToWaste, @movePartialColumn, @moveAceUp, @moveDeuceUp, @move3PlusUp, @badMove, @flipStToW_Max_0, @flipStToW_Max_1, @flipStToW_Max_2, @flipStToW_Max_3, @flipStToW_Max_4, @flipStToW_Max_5, @flipStToW_Max_6, @flipStToW_Max_7); ")
    defer stmt.Close()
    if err != nil {
       if cfg.General.OutputTo != "console" {
          oW = os.Stdout
       }
       fmt.Printf("Table: %v   Verb: %v   Error preparing   Error: %v ", table, verb, err)
       os.Exit(1)
    }
    // Execute the prepared statement
    _, err = stmt.Exec(
       sql.Named("Priority_SHA256", string(cfg.General.PrioritySHA256[:])),
       sql.Named("moveAceAcross", moveBasePriority["moveAceAcross"]),

Note a small piece is attached so you can see the colors 

 

Here are my datasource properties:

 

Finally while I have you I do not understand these warnings and is there a way to get them eliminated???

 

Thank you very very much!

0

Please sign in to leave a comment.