Re: [sqlite] C# pragma integrity_check call throwing exception

2017-10-26 Thread Roberts, Barry (FINTL)
Simon, > Your text makes it look like you think that that kind of corruption affects > only existing rows. This is not the case. If you continue to write to a > database which shows this problem, you can lose more of the existing rows > and/or the new data you're trying to write. The

Re: [sqlite] C# pragma integrity_check call throwing exception

2017-10-24 Thread Keith Medcalf
ginal Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Roberts, Barry (FINTL) >Sent: Tuesday, 24 October, 2017 09:04 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] C# pragma integrity_check call throwing exception >

Re: [sqlite] C# pragma integrity_check call throwing exception

2017-10-24 Thread Simon Slavin
On 24 Oct 2017, at 4:03pm, Roberts, Barry (FINTL) wrote: > Our system would get a list of the rowid problems allowing it to log them and > inform the user. I am currently testing using the 1.0.105.1 driver, however > the ExecuteReader() call (above) throws an exception

[sqlite] C# pragma integrity_check call throwing exception

2017-10-24 Thread Roberts, Barry (FINTL)
Hi, I asked the following question a few weeks ago, but did not get any responses, hoping someone may have an idea. We are currently running System.Data.SQLite.dll 1.0.80.0 and would like to upgrade to a newer version. However there are a variety of issues we have run into, most of which I