Loading

Error in Update Command

Jagjit Saini

Hi

MySqlCommand =

I am using MySql database.

Thanks

myCommand = new MySqlCommand("update hs_hr_attendance set punchout_time = " + "SubTime(Now(), '03:30:00')" + " where DATE_FORMAT(punchin_time,'%d/%m/%Y') = '" + _dt.ToString("dd/MM/yyyy") + "' and employee_id = " + empno + ")", con);

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Prasant Jinaga15y ago
Accepted answer
Hi Jagjit,

You are using one more bracket in the Query over here...

empno + ")", ---> Remove this extra bracket..It will work.

Thanks,
Prasant

Mark it Correct if it helps U :)
0