关于VFP-SQL 向数据库中表插入数据的问题

Question

请各位高数帮忙看一下：
 SQLEXEC(vsqll,"insert into cldmk (cldm,txm,pm,dw,cldmkk,ysmc,cd,ysmc1,ggmc,lsje,xszk,zkxsbj,xjbs,tej,tejxsbj,jfbz,jfbz_flag,zhcxtj,zsbj,qybs) values (?cldm1,?txm,?pm,?dw,?cldmkk,?ysmc,?cd1,?ysm1,?ggmcq,?lsje,?xszk,?zkxsbj,?xjbs,?tej,?tejxsbj,?jfbz,?jfbz_flag,?zhcxtj,?zsbj,?qybs)")运行有差误提示：“命令中含有不能识别的短语或关键词”但是我对上面的表达式去掉任一字段就没有错误提示，不知道错误出在那里。 帮忙给解决一下，急急！！ 谢谢                      

Answer 1

SQLEXEC(vsqll,"insert into cldmk (cldm,txm,pm,dw,cldmkk,ysmc,cd,ysmc1,ggmc,lsje,xszk,zkxsbj,xjbs,tej,tejxsbj,jfbz,jfbz_flag,zhcxtj,zsbj) values (?cldm1,?txm,?pm,?dw,?cldmkk,?ysmc,?cd1,?ysm1,?ggmcq,?lsje,?xszk,?zkxsbj,?xjbs,?tej,?tejxsbj,?jfbz,?jfbz_flag,?zhcxtj,?zsbj)") 不提示错误信息

Answer 2

你的SQL语句有多长，估计是超长了。

Answer 3

超长了，最长是255
你可以改成
SQLEXEC(vsqll,"insert into cldmk (cldm,txm,pm,dw,cldmkk,ysmc,cd,ysmc1,ggmc,lsje,xszk,zkxsbj,xjbs,tej,tejxsbj,jfbz,jfbz_flag,zhcxtj,zsbj,qybs)" + ;
" values (?cldm1,?txm,?pm,?dw,?cldmkk,?ysmc,?cd1,?ysm1,?ggmcq,?lsje,?xszk,?zkxsbj,?xjbs,?tej,?tejxsbj,?jfbz,?jfbz_flag,?zhcxtj,?zsbj,?qybs)")

Answer 4

当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴？
http://community.csdn.net/Help/HelpCenter.htm#结帖