Syntax Error on UPDATE statement
Access.ExecQuery("UPDATE record " & _
"SET (Time_Out=@timeout) " & _
"WHERE Employee=@emp AND Punch_Date=@date " & _
"ORDER BY Time_In ASC LIMIT 1;")
whats wrong with my syntax?
Asked
Active
Viewed 50 times
0
John Mark
- 73
- 11
-
is `record ` table name ? – Mahesh Karia Nov 06 '17 at 06:08
-
yes record is a table name – John Mark Nov 06 '17 at 07:09
-
can you remove **ORDER BY** clause – Mahesh Karia Nov 06 '17 at 07:17
-
@JohnMark - Did you check my answer, is your problem solved? – Md. Suman Kabir Nov 06 '17 at 12:53
-
@MaheshKaria i just want to update a row where the WHERE clause has two conditions. `"WHERE Employee=@emp AND Punch_Date=@date "` – John Mark Nov 07 '17 at 02:34
1 Answers
0
The query should be like this :
Access.ExecQuery("UPDATE record " & _
"SET (Time_Out=@timeout) " & _
"WHERE Employee=@emp AND Punch_Date=@date;")
You can not use ORDER BY clause in UPDATE query.
Md. Suman Kabir
- 5,243
- 5
- 25
- 43