Re: [sqlite] Problem with Update Statement

2014-08-20 Thread Hick Gunter
.com] Gesendet: Dienstag, 19. August 2014 20:26 An: sqlite-users Betreff: Re: [sqlite] Problem with Update Statement Solved the problem with parameterized queries as below, without parameterized queries the update statement doesn't work on SQLite. ... SQLITEcmd200.Command

Re: [sqlite] Problem with Update Statement

2014-08-20 Thread Wycliff Mabwai
Solved the problem with parameterized queries as below, without parameterized queries the update statement doesn't work on SQLite. Private Sub ReplaceRGrid() ''On Error Resume Next Dim SQLITEcons As New SQLite.SQLiteConnection Dim SQLITEcmd As New SQLite.SQLiteCommand

Re: [sqlite] Problem with Update Statement

2014-08-19 Thread Clemens Ladisch
Wycliff Mabwai wrote: > syntax near "Where". > > SQLITEcmd2.CommandText = "UPDATE RecordGrid SET > LineNumber='" & reade20.GetInt32(11) & "',self_empty_info_gender_PRect= '" > & IIf(reade20.IsDBNull(22), String.Empty, reade20.GetString(22)) & "," & > IIf(reade20.IsDBNull(23),

Re: [sqlite] Problem with Update Statement

2014-08-18 Thread Simon Slavin
On 18 Aug 2014, at 7:54pm, Wycliff Mabwai wrote: > 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". >

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 <

[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

[sqlite] Problem with UPDATE-statement

2004-08-20 Thread Kent Karlsson
Hi, This is the relevant information in the database: /* Contains most of the info static on a player. FirstUpdate and LastUpdate is a convenience to avoid JOIN if I can, the information will be presented very often with the static info. */ CREATE TABLE Player ( ID integer primary key,