把它改成SQL = "Insert Into tKc_StockInfo(fStockNO,fQuantity,fWarningQuantity)Values('"&StockNO&"',"&Quantity&","&WarningQuantity&")"
conn.Execute SQL就行了
是数字的变量就不要单引号了。把VALUES()中后面两个的单引号去掉
rs.addnew
rs("fStockNO")=trim(Request("fWarningQuantity"))
rs("fQuantity")=cint(trim(Request("fWarningQuantity")))
rs("fWarningQuantity")=cint(trim(request("fWarningQuantity")))
rs.update
数字类型去掉单引号