Missing semicolon (;) at end of SQL statement. Semicolon already exists

Question

I keep getting this error Missing semicolon (;) at end of SQL statement. when I run this code:

Dim cmd3 As OleDbCommand = New OleDbCommand("INSERT INTO Tickers (Quarter_Balance_Sheets) VALUES (Scrapalbe) WHERE Ticker = A;", con)
cmd3.ExecuteNonQuery()

What am I doing wrong?

Esselans · Accepted Answer · 2013-11-20T19:51:04.790

4

Edited..

Sorry. After reading again you cannot use WHERE on an INSERT statement, loose the WHERE clause or make an UPDATE statement.

INSERT INTO ... WHERE is not a valid query.

If the insert you've posted has correct values and columns, the update should be:

Dim cmd3 As OleDbCommand = New OleDbCommand("UPDATE Tickers SET Quarter_Balance_Sheets = 'Scrapalbe' WHERE Ticker = 'A';", con)
cmd3.ExecuteNonQuery()

edited Nov 20 '13 at 19:51

answered Nov 20 '13 at 19:39

Esselans

1,540
2
24
44

What would the UPDATE statement look like? – gromit1 Nov 20 '13 at 19:48
1

Thanks. First think if you need an insert or an update. Then write the query. – Esselans Nov 20 '13 at 19:57
Wow, can't believe I missed that – Eric Petroelje Nov 21 '13 at 20:58

Konstantin · Answer 2 · 2013-11-20T19:50:45.997

3

Missing quotes WHERE Ticker = 'A' and in VALUES ('Scrapalbe')

edit: @Engerlost is right, where is not applicable to insert; you still need quotes but drop where... completely

edited Nov 20 '13 at 19:50

answered Nov 20 '13 at 19:24

Konstantin

3,254
15
20

I tried your suggestion and I got the same error. `Missing semicolon (;) at end of SQL statement.` – gromit1 Nov 20 '13 at 19:26
@LarsTech I'm using Microsoft Access. Is that what you mean? – gromit1 Nov 20 '13 at 19:29
@EricPetroelje I still get the same error when I try `WHERE Ticker = 'A'` and in `VALUES ('Scrapalbe')` – gromit1 Nov 20 '13 at 19:43

score 0 · Answer 3 · answered Jun 09 '15 at 18:26

0

the problem in your query is you're using where in your insert statement.

the query is,

insert into Tablename (val1, val2, ...) values(val1, val2,....)

answered Jun 09 '15 at 18:26

SMHasnain

696
4
13

Missing semicolon (;) at end of SQL statement. Semicolon already exists

3 Answers3