"Tim Marsden" <TM@UK.COM> wrote in message
news:utbdLhFBFHA.2012@TK2MSFTNGP15.phx.gbl...
> Hi,
>
> I am using ODBCNET to update a mySQL table.
> I update the table using a DataAdapter. Setting the Update, Insert and
> Delete commands manually.(Optimistic updates)
>
> If I change a row in the datatable, changing the value of a column to the
> same value as the original.
> The changed row appears in the DataTable.Getchanges result.
> When I run the DataAdapter.Update command I get and error,
> DBConcurrenyException 0 rows updated.
>
> Why?, the same code works with MS SQL server.
>
> Is there a way of ensuring I only update the changed records, The
> datatable.GetChanges returns the row even if changed to the same original
> value.
>
> I am a bit confused.
>
> Thanks
>
>