any news to this problem?
I got the same error. The first query works fine, all other queries throw this error.
For example there is a button which calls a method to write data from a dictionary to the db.First call / button click works fine, second call throws the error at
cmd.Transaction = conn.BeginTransaction();
Another error I get within a while-loop where the program reads the data from the db via SqliteDataReader:
cmd.CommandText = "SELECT * FROM [table]";
using (SqliteDataReader reader = cmd.ExecuteReader())
for (int i = 0; i < reader.FieldCount; i++)
if (reader[i] != null)
First iteration of the loop works fine, the second one throws the error "Value does not fall within the expected range." at the first attempt to add data to the dictionary ( dicData.Add("name", reader["name"].ToString()); )
I also tried the two fixes for the wp7sqlite project I found on the web, but theres no difference to the effect.
Would be great if you can get this thing running. I like the sql syntax and don´t want to change to Sterling or something... :)
Thanks in advance