con=SQLConnect("sjy1","sa","123456789")
If con<0
    messagebox('连接失败,请稍后再试！',0+16)
    retu
endif

 con1="SELECT "
 con1=con1+"X销售分类任务.时间, X销售分类任务.警,"
 con1=con1+"X销售分类任务.数量, X销售分类任务.车牌号,"
*con1=con1+"X销售分类任务.备注, X销售分类任务.经手人,"
*con1=con1+"X销售分类任务.客施, X销售分类任务.合积分,"
*con1=con1+"X销售分类任务.大类, X销售分类任务.MR修改,"
*con1=con1+"X销售分类任务.物流, X销售分类任务.项目名称,"
*con1=con1+"X销售分类任务.车间, X销售分类任务.责任部门,"
*con1=con1+"X销售分类任务.库管, X销售分类任务.施工备注,"
*con1=con1+"X销售分类任务.物料, X销售分类任务.项目编号,"
*con1=con1+"X销售分类任务.施工, X销售分类任务.施工部门,"
*con1=con1+"X销售分类任务.编号, X销售分类任务.销售编号,"
*con1=con1+"X销售分类任务.销售, X销售分类任务.营销认责任,"
*con1=con1+"X销售分类任务.营销, X销售分类任务.开发认责任,"
*con1=con1+"X销售分类任务.开发, X销售分类任务.其它认责任,"
*con1=con1+"X销售分类任务.其它, X销售分类任务.公司认责任,"
*con1=con1+"X销售分类任务.公司, X销售分类任务.月施工统计,"
 con1=con1+"X销售分类任务._Identify, X客户库表.车型"

con1=con1+" FROM x销售分类任务 LEFT OUTER JOIN X客户库表  ON  x销售分类任务.车牌号 = X客户库表.车牌号 "

lnRe1=SQLExec(con,"&con1","x销售分类任务_ls")
If lnRe1<0
    messagebox('运行失败,请再试！',0+16)
    retu
EndIf
brow

现在上面语句能通过，但打*号的去掉任何一行的*却通不过，错误提示：“命令中含有不能识别的短语或关键字”
把*行上面两行打上*号，下面去掉任何两行的*号也能通过
是有长度限制？请大侠指导。

多谢sdta！

我已经回家了，没法连sql，明天试试

[ 本帖最后由 YTZN 于 2014-4-2 21:56 编辑 ]

多谢指导，我慢慢试。

说得对，第二个参数不要引号及宏代换通过了。

多谢各大侠费心！