Hello,
I am developing an application using Visual Studio 2008 ( C# .NET 3.5SP1 )
and sqlite ( System.Data.Sqlite ).
Whole database interaction is written using strongly typed datasets. All
was fine while working with tables, but when i tried to
update views, it was brick wall. I was hoping to use sqlite view just like
any table trough the designer. Issue commands, and let instead of trigger
to do the logic.
try
{
this.katalogvBindingSource.RemoveCurrent();
}
catch (Exception exception)
{
}
try
{
this.katalogvTableAdapter.Update(fkasaDataSet.katalogv);
}
catch (SqliteException ex)
{
}
*Throws DBconcurrency violation. Affected rows 0 instead of 1.*
Even though i have turned optimistic concurrency off.
Delete command works fine. Executed the command trough VS dataset designer,
and everything was fine, instead of trigger did all buisness logic it was
designed for. Since i ' ve had the same problem testing on postgreSQL, i am
thinking this is probably typed dataset bug, and not sqlite problem. Since
no one replied to my question on official .NET forums, i am desperatly
trying here. Maybe someone helps. If not , oh well i will manualy code it.
But would like to keep coding style consistency.
Maybe someone knows how to bypass this.
Thank you in advance,
Alem Bišćan
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
