请大虾帮我看看这段代码有什么问题,调试时老说"insert into 语句的语法错误"

来源：百度知道 编辑：UC知道 时间：2024/05/09 14:16:31
代码如下:
Public Sub Insert()
SqlStmt = "INSERT INTO Wages

(EmpId,EmpName,Year,Month,Jibengz,Gangweigz,Jibiegz,Gonglinggz,Teshugzbt,Gongqinzujb,Chuchaibt,S

ijijsbt,Zhiwugz,Baoanhuoshibt,Leijijbgz,Heji,Sxjhjkc,Sfje) Values(" _
+ Trim(EmpId) + ",'" + Trim(EmpName) + "'," + Trim(Str(Year)) + "," + Trim(Str(Month)) +

"," + Trim(Str(Jibengz)) + "," + Trim(Str(Gangweigz)) + "," _
+ Trim(Str(Jibiegz)) + "," + Trim(Str(Gonglinggz)) + "," + Trim(Str(Teshugzbt)) + "," +

Trim(Str(Gongqinzujb)) + "," + Trim(Str(Chuchaibt)) + "," _
+ Trim(Str(Sijijsbt)) + "," + Trim(Str(Zhiwugz)) + "," + Trim(Str(Baoanhuoshibt)) + "," +

Trim(Str(Leijijbgz)) + "," + Trim(Str(Heji)) + "," + Trim(Str(Sxjhjkc)) + "," + Trim(Str(Sfje))

分开写嘛。非要写成一行吗？？搞得自己都看不懂。
再不行就把生成的SQL输出来看看。

<%
Public Sub Insert()
SqlStmt = "INSERT INTO Wages (EmpId,EmpName,Year,Month, "
SqlStmt = SqlStmt + " Jibengz,Gangweigz,Jibiegz,Gonglinggz, "
SqlStmt = SqlStmt + " Teshugzbt,Gongqinzujb,Chuchaibt, "
SqlStmt = SqlStmt + " Sijijsbt,Zhiwugz,Baoanhuoshibt,
SqlStmt = SqlStmt + " Leijijbgz,Heji,Sxjhjkc,Sfje) "
SqlStmt = SqlStmt + " Values("+ Trim(EmpId) + ",'" + Trim(EmpName) + "'," + Trim(Str(Year)) + "," + Trim(Str(Month)) + ","
SqlStmt = SqlStmt + Trim(Str(Jibengz))+ "," + Trim(Str(Gangweigz)) + ","+ Trim(Str(Jibiegz)) + "," + Trim(Str(Gonglinggz)) + ","
SqlStmt = SqlStmt + Trim(Str(Teshugzbt)) + "," + Trim(Str(Gongqinzujb)) + "," + Trim(Str(Chuchaibt)) + ",&quo