Comments by RZ50 - CodeProject

RZ50 3-Mar-20 12:41pm View

After read your suggestion I found this note "This causes the rows affected count returned to be zero, which the DataAdapter interprets as a concurrency conflict. In this event, a DBConcurrencyException will be thrown."

So in my Driver I change the option "Return matched rows instead of affected rows" to true and the problem is SOLVED!

Thank you for all...

RZ50 2-Mar-20 13:01pm View

With keyboard.
Pk nome
1 abc --> I changed to AB and then I delete with keyboard to stay the same abc
2 xyz --> I changed to AB this is to stay
after save give me the error on record 1 and lost the information of rec2

RZ50 2-Mar-20 12:45pm View

my table (test) is simple:
pk INT(11)
nome VARCHAR(45)

my CommandText:
UPDATE test SET nome =? WHERE (pk =?)

if I change the wrong record in the DataGridView and reset the initial information and then I change the correct record and when updating it gives me this error and I lose the information of the correct record...

RZ50 2-Mar-20 11:59am View

MySQL ODBC 5.1 Driver

Comments by RZ50 (Top 4 by date)