I am using the following code to try and update a database entry, the UPDATE statement works when i am not using parameters but when i am using them it seems to do absolutely nothing. No error and no update either.
sqlString = "UPDATE table SET field1 = @value1, field2 = @value2, field3 = @value3 WHERE field1 = @currentValue"
Actually that was just a mistake when i was posting the code, i changed the parameter names from what i actually have in my code and accidentally put @field instead of @value. In my code they are actually correct. That wasnt the source of the problem.