主题：sql语句传入int型参数出错

Tables("入库表_Table1").Fill("SELECT a.HP_BH AS '序列号',a.HP_Name as '设备名称',b.MX_SQR as '申请人',b.MX_SQRPhone as '联系电话',b.MX_SQTime as '入库时间',b.MX_LY as '设备来源' from CK_MX AS b left join CK_HP as a on a.HP_ID = b.HP_ID  where b.userID=" & userId, "ck",True)

foxtable中，字符串用&连接起来：

http://www.foxtable.com/help/topics/0221.htm