Pardon my ignorance, but I am trying to update a database table, and have tried to use the book to help me, and I've typed everything exactly as it's shown (except for my DB variables that I've changed) but it's erroring telling me the following:

Exception Details: System.Data.OleDb.OleDbException: Syntax error in query. Incomplete query clause. Line 21.

Line 19:
Line 20: oCmd = New OleDbCommand(sSQL, oConn)
Line 21: oCmd.ExecuteNonQuery()
Line 22:
Line 23: lblStatus.Text = "Command Run"

My code is pretty simple (I think) What is wrong with the syntax of the oCmd.ExecuteNonQuery() command?

-If seeing the entire code would be more helpful I can provide.

Thank you VERY much in advance.

J

My guess is that the SQL string is incomplete. What is the value of sSQL when you execute oCmd? That could tell you what the "Incomplete query clause" error is from. Perhaps just a little bit more of this code would be helpful.

yes more codes will sure help us to help.

Always:),
Hovik Melkomian.

Post your SQl query clause please!