access update query does not update

[pkc21]

Hello! I have been using ExecuteNonQuery() to update a few rows here and there no problem. Now I want to update 50,000+ rows and nothing happens...

So I want to update the value of field rxLabelID to the value in field silviculture, both integers. Works fine the access quiery gui. No luck if I swap silviculture out for a number, i.e., -1.

sql = " UPDATE fps_HarvSchdsRawRxs SET rxLabelID = silviculture;";
theCmd = new OleDbCommand(sql, theConn);
x = theCmd.ExecuteNonQuery();

The correct # of rows are returned via x.

And a similar query to a different table, with only one row, works fine.

A third query, for deleteing about a dozen records works, but takes over a minute to execute.

Thanks in advance for your input!

[finito]

x = theCmd.ExecuteNonQuery();

this will not return anything. and should give an error.

what is x defined as? int?

you need to do

theCmd.ExecuteNonQuery();
x = int.Parse(new OleDbCommand("Your Select Statement with Count()",theConn).ExecuteScaler().toString())

You may wish to get rid of the semicolon in your update string.