查询出编号长度大于4的code_请问SQL查询语句有长度限制吗?

我用下面查询语句在SQL企业管理器查询能正常得出查询表:selectiperiod会计期间,ino_id凭证编号,iflag,cdigest摘要,ccode科目,md借方金额,mc贷方金额,cdept_id部门,ccus_id客户,ccode_...

我用下面查询语句在SQL企业管理器查询能正常得出查询表:select iperiod 会计期间,ino_id 凭证编号,iflag ,cdigest 摘要,ccode 科目,md 借方金额, mc 贷方金额,cdept_id 部门,ccus_id 客户,ccode_equal 对方科目 from UFDATA_005_2008.dbo.GL_accvouch WHERE (iflag Is Null) AND (iperiod Between 1 AND 12 ) AND ( ccode =10101) AND ( ccode_equal LIKE '%52102%') order by iperiod,ino_id但在VBE中用下面代码:Sub AA() Dim str As String, SQLstr As String str = "ODBC;DRIVER=SQL Server;SERVER=DXGSZ;UID=sa;PWD=;APP=Microsoft Office XP;WSID=DXGSZ;DATABASE=UFDATA_005_2008" SQLstr = "select iperiod 会计期间,ino_id 凭证编号,iflag ,cdigest 摘要,ccode 科目,md 借方金额, mc 贷方金额,cdept_id 部门,ccus_id 客户,ccode_equal 对方科目 from UFDATA_005_2008.dbo.GL_accvouch WHERE (iflag Is Null) AND (iperiod Between 1 AND 12 ) AND ( ccode =10101)AND ( ccode_equal LIKE '%52102%') order by iperiod,ino_id" With ActiveSheet.QueryTables.Add(Connection:=str, Destination:=ActiveSheet.Range("b65536").End(xlUp).Offset(1, 0)) .CommandText = Array(SQLstr) .Refresh BackgroundQuery:=False End WithEnd Sub运行到 .CommandText 语句时提示"类型不匹配"减少字条串SQLstr的长度,该查询宏能正常应用请问如何解决 .CommandText 类型匹配问题?

展开