error on ExecuteNoQuery()

Question

i'am trying to update a row in a table using :

command.ExecuteNoQuery()

it's not giving me an error but it's not updating the row

This is my code :

Dim req As String = "Update Table Set Id= 5"
Dim cmd As New OleDb.OleDbCommand(req, connect())
cmd.ExecuteNonQuery()
disconnect()

thanks

You know that sql query will update _every_ row in your table, and do you have a plan for reclaiming connections if an exception is thrown by your query (right now your disconnect() function wouldn't be called) — Joel Coehoorn, May 28 '10 at 17:47
I know but this query is not doing anything, even if it's working with INSERT command. — Wassim AZIRAR, May 28 '10 at 18:10
what is the error being thrown? Have you tried running that sql directly against the db? — earthling, May 28 '10 at 20:24

score 0 · Answer 1 · answered May 28 '10 at 18:29

0

Make sure that ID isn't an IDENTITY column.

answered May 28 '10 at 18:29

kervin

score 0 · Answer 2 · answered May 31 '10 at 21:13

0

the problem is that the query was too slow with MS Access.

Now it's working fine MS SQL Server.

answered May 31 '10 at 21:13

Wassim AZIRAR

2 Answers2