Can someone tell me why this segment does not work?
Code:' CREATE COMMAND AND SET PARAMETERS invCmd = New OleDbCommand("UPDATE invMain SET Description2=@desc2, Type=@type, " & _ "Inventory=@inv, Trigger=@trig, LeadTime=@lead, Size=@size, Cartridge=@cart " & _ "WHERE (Description1=@part)", invCon) invCmd.Parameters.Add("@desc2", OleDb.OleDbType.Char) invCmd.Parameters.Add("@type", OleDb.OleDbType.Char) invCmd.Parameters.Add("@inv", OleDb.OleDbType.Char) invCmd.Parameters.Add("@trig", OleDb.OleDbType.Char) invCmd.Parameters.Add("@lead", OleDb.OleDbType.Char) invCmd.Parameters.Add("@size", OleDb.OleDbType.Char) invCmd.Parameters.Add("@cart", OleDb.OleDbType.Char) invCmd.Parameters.Add("@part", OleDb.OleDbType.Char) invCmd.Parameters("@desc2").Value = "d2" & Me.uiDescriptionTextBox.Text invCmd.Parameters("@type").Value = "ty" & Me.uiTypeTextBox.Text invCmd.Parameters("@inv").Value = Me.uiOnHandTextBox.Text invCmd.Parameters("@trig").Value = Me.uiTriggerTextBox.Text invCmd.Parameters("@lead").Value = Me.uiLeadTextBox.Text invCmd.Parameters("@size").Value = Me.uiSizeTextBox.Text invCmd.Parameters("@cart").Value = Me.uiCartridgeComboBox.Text invCmd.Parameters("@part").Value = "d1" & Me.uiPartNumberLabel.Text
It worked fine until I added the second and third items from the bottom. Now I am getting a message that says there is an error in the syntax of my update statement.




Reply With Quote