On 18 Aug 2014, at 7:54pm, Wycliff Mabwai <wycliff.mab...@digitaldividedata.com> 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". > 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"'" I don't know what language you're using but that looks weird. Shouldn't it end something like > IIf(reade20.IsDBNull(25), String.Empty, reade20.GetString(25)) & "' WHERE > RecordGridID='" & chombo & "'" ? If that doesn't fix it, can you insert a line into your program to make it send to the console (dump/display/whatever) the command before it sends it to SQLite ? It would help us to know exactly what it's trying to execute. I don't think SQLite has anything to do with your problem. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
