update error

Syntax error in UPDATE statement

Submitted by admin on

While I was working with Visual Basic .NET by adding a form to manage user account in my system I found an error called “Syntax error in UPDATE statement”. After figuring out what’s the cause of this error I found out that it was the name of the field that is causing the problem.

In my Users table I have the following fields:

UserID
Password
CompleteName

As you can see all of these fields are valid. The statement to save a record back to its database is:

Subscribe to update error