Insert and update on duplicate values in C# for access database

Question

I have seen other version of this problem in stack over flow and when I use it, I get error stating:

"Missing semicolon (;) at end of SQL statement."

I am learning just now C# and I don't know what I am missing, I am using the following commandtext. Suggest me where I am wrong.

"Insert into weightsofsalts(ID,WeightOfSalts) values(@id,@weightofsalts) on duplicate key update WeightOfSalts =@weightofsalts";

Have you tried putting a semicolon at the end of the SQL statement? — Steve, Apr 07 '16 at 03:57
Yes, I tried by putting semicolon at the end of the sql statement, I still get the same error — KamalSubodh, Apr 07 '16 at 03:58

Vignesh Kumar A · Answer 1 · 2016-04-07T04:26:25.163

0

MS Access won't support ON DUPLICATE KEY UPDATE

You have to insert statement first and then check to see if error 3022 occurred, which indicates the row already exists. So you have to update.

edited Apr 07 '16 at 04:26

answered Apr 07 '16 at 04:11

Vignesh Kumar A

@KamalSubodh MS Access won't support ON DUPLICATE KEY UPDATE – Vignesh Kumar A Apr 07 '16 at 04:27

1 Answers1