.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
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
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),
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".
>
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 <
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
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,
7 matches
Mail list logo