insert error

system analysis · Post by **system analysis** » Fri Sep 04, 2015 1:29 pm

I try to execute this statment for insertion but when im arrive " ew_Execute(employeessql);" it give me error in insertion

string employeessql = "INSERT INTO EmpEvaluation (Emp_ID,Year) VALUES (" + theActiveEmployeesRs["EMP_ID"].ToString() + "," + rsnew["ActionYear"].ToString() + ")";
ew_Execute(employeessql);

help me plz

vincenthung · Post by **vincenthung** » Fri Sep 04, 2015 5:25 pm

You can output the SQL as below and test it directly in the SQL manager to make sure it is running as expected.

string employeessql = "INSERT INTO EmpEvaluation (Emp_ID,Year) VALUES (" + theActiveEmployeesRs["EMP_ID"].ToString() + "," + rsnew["ActionYear"].ToString() + ")";
ew_Response.Write(employeessql); //*** output the SQL
ew_Response.End(); //***
ew_Execute(employeessql);