Re: [sqlite] Problem with Update Statement

2014-08-20 Thread Wycliff Mabwai
ng(25)) & "', '" & IIf(reade300.IsDBNull(22), String.Empty, reade300.GetString(22)) & "," & IIf(reade300.IsDBNull(23), String.Empty, reade300.GetString(23)) & "," & IIf(reade300.IsDBNull(24), String.Empty, reade300.GetString(24)) & "," &am

Re: [sqlite] Problem with Update Statement

2014-08-18 Thread Wycliff Mabwai
This line* [SQLITEcmd2.Parameters.AddWithValue(chombo)]* isn't actually used, I had just added it trying to figure out how to use parameterized queries. You can comment it or ignore it out of the problem. Thanks On Mon, Aug 18, 2014 at 9:54 PM, Wycliff Mabwai < wycliff.

[sqlite] Problem with Update Statement

2014-08-18 Thread Wycliff Mabwai
Hi, (Don't know as yet who to salute) I have a problem, am populating data into a db3 file. Inserts, Replace all work fine. But when I update with a condition, it fails and tells me to check the syntax near "Where". The code itself is VB.Net, am trying to update certain fields. Below is the full