有这样一个命令不能正常执行，好像是字符超过255个了，随便舍弃某一两个字段，则可以执行。可是每个字段都很必要，不能省略。该怎么解决？
   SQLEXEC(_SQL,"INSERT INTO t_inventory (id,agricultureNo,goodsName,companyName,specification,goodsType,goodsNo,goodsType,cgunit,cgnum,saleunit,relationNum,saleprice,salenum,restricpesticides,separateType) VALUES (?a8,?a1,?a2,?a3,?a4,?a9,?a8,?a13,?a12,?a15,?a16,?a18,?a14,?a17,?a10,?a11)")

TEXT TO cSql NOSHOW TEXTMERGE
SQLEXEC(_SQL,"INSERT INTO t_inventory (id,agricultureNo,goodsName,companyName,specification,goodsType,goodsNo,goodsType,cgunit,cgnum,saleunit,relationNum,saleprice,salenum,restricpesticides,separateType) VALUES (?a8,?a1,?a2,?a3,?a4,?a9,?a8,?a13,?a12,?a15,?a16,?a18,?a14,?a17,?a10,?a11)")
ENDTEXT
EXECSCRIPT(cSql)

替换后好像不行

检查一下你自己的代码

[此贴子已经被作者于2019-3-31 20:26编辑过]

TEXT TO cSql NOSHOW TEXTMERGE
SQLEXEC(_SQL,"INSERT INTO t_inventory (id,agricultureNo,goodsName,companyName,specification,goodsType,goodsNo,goodsType,cgunit,cgnum,saleunit,relationNum,saleprice,salenum,restricpesticides,separateType) VALUES (?a8,?a1,?a2,?a3,?a4,?a9,?a8,?a13,?a12,?a15,?a16,?a18,?a14,?a17,?a10,?a11)")
ENDTEXT
EXECSCRIPT(cSql)

SQLEXEC(_SQL,"INSERT INTO t_inventory (id,agricultureNo,goodsName,companyName,specification,goodsType,goodsNo,goodsType,cgunit,cgnum,"+" ;
saleunit,relationNum,saleprice,salenum,restricpesticides,separateType) VALUES (?a8,?a1,?a2,?a3,?a4,?a9,?a8,?a13,?a12,?a15,?a16,?a18,?a14,?a17,?a10,?a11)"

SQLEXEC(_SQL,"INSERT INTO t_inventory (id,agricultureNo,goodsName,companyName,specification,goodsType,goodsNo,goodsType,cgunit,cgnum,"+ ;
"saleunit,relationNum,saleprice,salenum,restricpesticides,separateType) VALUES (?a8,?a1,?a2,?a3,?a4,?a9,?a8,?a13,?a12,?a15,?a16,?a18,?a14,?a17,?a10,?a11)"

后面少一个括号“ ) ”

对，确实少一个括号