System.Data.SQLite

I've got a SQLite db set up as follows:

create table processes (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name varchar,
    source varchar,
    destination varchar,
    copy bool,
    copy_folder varchar,
    delete_days int,
    created datetime,
    modified datetime
);

I have a DataSet (dsProcesses), BindingSource (ProcessesBindingSource), and a TableAdapter (ProcessesTableAdapter). When I try to edit a row and write the data back to the database using this code (VB.NET):

Me.ProcessesBindingSource.EndEdit()
Me.ProcessesTableAdapter.Update(Me.DsProcesses)

I get the following error:

Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.

Any ideas on why it won't write the changes back to the database?

Thanks,
Dustin

Hrm.  I'll see if I can duplicate the error locally.  If not, I may need you to send me a sample app so I can debug it.

Robert

 

Any luck on this? Do you want all the code?

I haven't had time to try it out yet.  I just got back from vacation with the family :) 

Robert

 

Hi,

looks like "Optimistic Concurrency" is turned on in your TableAdapter. Try to turn it off under "Advanced Options..." in the
TableAdapter Configuration Wizard.

Also, Google-ing for your error message returns numerous helpful links.


Regards,
Alexander

I found the issue. There was a field on my form that would sometimes contain a string value when it should alwasy be an integer value.

Sorry! Thanks for the help.