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!
Please sign in to leave a comment.