Obviously the problem was caused by incorrectly cobbling together theSQLite statement.
AFAICT the original code produces UPDATE RecordGrid SET LineNumber='<something>',self_empty_info_gender_PRect='<something>,<something>,<something>,<something>' WHERE RecordGridID=' Which is clearly invalid (the RHS of the WHERE condition is not terminated), with extraneous text after the end of the value ignored ( no & operators to concatenate the strings). This would have become clear if you had dumped the CommandText as previously suggested -----Ursprüngliche Nachricht----- Von: Wycliff Mabwai [mailto:wycliff.mab...@digitaldividedata.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.CommandText = "UPDATE RecordGrid SET LineNumber=@LineNumber, self_empty_info_gender_PRect=@self_empty_info_gender_PRect WHERE RecordGridID=@RecordGridID" SQLITEcmd200.Parameters.AddWithValue("@LineNumber",reade300.GetInt32(11)) SQLITEcmd200.Parameters.AddWithValue("@self_empty_info_gender_PRect",... SQLITEcmd200.Parameters.AddWithValue("@RecordGridID",... ... >> 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), String.Empty, reade20.GetString(23)) >> & "," & IIf(reade20.IsDBNull(24), String.Empty, >> reade20.GetString(24)) & "," & IIf(reade20.IsDBNull(25), >> String.Empty, reade20.GetString(25)) & "' WHERE RecordGridID='"chombo"'" ----------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: h...@scigames.at This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users