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:[email protected]]
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: [email protected]
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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
