I'm getting an error on the insert... I recently when to switch over from the @.param.Oledb type and am now using the ? for the values... Well I switched my updates and now am working on the inserts, but I am getting the error from this statement. I tried taking off the VALUES portion, but that didn't work either...
queryString = "INSERT INTO [griff30_24_stats] ([W_Rec], [Opponent], [L_Rec], [points], [done]) VALUES(?, ?, ?, ?,)"
Dim cmd as new OleDbCommand(queryString,dbConnection)
cmd.Parameters.Add("W_Rec",OleDbType.VarChar).Value = "Y"
'''It looks like you have 5 columns but only 4 question marks. Add afinal question mark (?) after that last comma and that should help.|||
Thats a copy paste error. I have 5 "?'s" in the code, but I was going wild with the backspace. I still don't see why it's giving me the error is there a different style??
|||Can you show us a little more of the code as well as the exact error message?|||Man, it was a little syntax error, I was missing a '(apostrophe in a statement). The little things I look over.
No comments:
Post a Comment