主题：SQL相关，不可保存编码-提示字符常量必须以双引号结束

如下编码保存时提示：

此主题相关图片如下：qq截图20120424155604.jpg

'狐表帮助中示例语句： Tables("窗口1_Table1").Fill("Select * From 订单 Where 日期 = '" & Date.Today & "'","nwnd",True)

1. jr_zb为外部数据源名

2.dbo.fun_GetTelReplyIntro为自定义函数

3.SQL语句运行在数据库查询分析器中运行是正常的

Tables("客户统计_Table1").Fill("

Select   a.ord, a.name,c.sort2,d.menuname,a.address,a.phone,a.fax,a.zdy1,a.zdy2,a.zdy3,a.zdy4,e.name,e.mobile,e.mobile2 ,  dbo.fun_GetTelReplyIntro(a.ord),a.email    from   tel a left JOIN   reply b on 1=1

    left JOIN   sort5 c on c.id=a.sort1

    left JOIN   menuarea d on d.id=a.area

    left join   person e on e.ord=a.person

    group by a.ord, a.name,c.sort2,d.menuname,a.address,a.phone,a.fax,a.zdy1,a.zdy2,a.zdy3,a.zdy4,e.name,e.mobile,e.mobile2 ,  dbo.fun_GetTelReplyIntro(a.ord),a.email ","jr_zb",True)