Re: [sqlite] Exception at changing a row in .NET FW 4.7.1

2018-08-08 Thread Joe Mistachkin
Using the type name “DATETIME” with System.Data.SQLite activates some special handling, which is quite complex, since it has many options dealing with formats, time zone handling, etc. In your case, it may be better to use INTEGER instead. Alternatively, you could create a custom type

Re: [sqlite] Exception at changing a row in .NET FW 4.7.1

2018-08-08 Thread Rtm Rbtsk
> Rtm Rbtsk wrote: > > > > If I change the data in the first row with the 'id'='1' in the table > > 'leslie', I get a DBConcurrencyException at the Update-command: > > > > System.Data.DBConcurrencyException: 'Concurrency violation: the > > UpdateCommand affected 0 of the expected 1 records.' > >

Re: [sqlite] Exception at changing a row in .NET FW 4.7.1

2018-08-06 Thread Joe Mistachkin
Rtm Rbtsk wrote: > > If I change the data in the first row with the 'id'='1' in the table > 'leslie', I get a DBConcurrencyException at the Update-command: > > System.Data.DBConcurrencyException: 'Concurrency violation: the > UpdateCommand affected 0 of the expected 1 records.' > It's hard to

[sqlite] Exception at changing a row in .NET FW 4.7.1

2018-08-06 Thread Rtm Rbtsk
Hy, If I change the data in the first row with the 'id'='1' in the table 'leslie', I get a DBConcurrencyException at the Update-command: System.Data.DBConcurrencyException: 'Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.' By deleting the row it raises in