tmpConstr = "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=" & tmpHostN & ";" & _
"DATABASE=" & tmpDatabase & ";" & _
"UID=" & TmpLogin & ";PWD=" & tmpPwd & ";" & _
"OPTION=3" ';stmt=SET NAMES GB2312"
' 连接数据库
gCnMysql.Open tmpConstr
' 设置该属性, 使 recordcount 和 absolutepage 属性可用
gCnMysql.CursorLocation = adUseClient
strsql = " select udt_id,doc_id,flowname,field36,field19,field15,field35,field34,field33,field32,field31,field30,field29,field25 "
strsql = strsql & " from udtA"
strsql = strsql & " left join utmB on udtS.DOC_ID =utmB.flowid"
strsql = strsql & " left join utdC on utdC.masterid =utmB.id"
strsql = strsql & " where udtA.UDT_ID='10002'"
strsql = strsql & " and utmB.id is not null"
rs.Open strsql, gCnMysql, adOpenDynamic, adLockOptimistic
多表查询时出错。
单表查询时就没有问题。急啊。left join不用也不行啊。
"SERVER=" & tmpHostN & ";" & _
"DATABASE=" & tmpDatabase & ";" & _
"UID=" & TmpLogin & ";PWD=" & tmpPwd & ";" & _
"OPTION=3" ';stmt=SET NAMES GB2312"
' 连接数据库
gCnMysql.Open tmpConstr
' 设置该属性, 使 recordcount 和 absolutepage 属性可用
gCnMysql.CursorLocation = adUseClient
strsql = " select udt_id,doc_id,flowname,field36,field19,field15,field35,field34,field33,field32,field31,field30,field29,field25 "
strsql = strsql & " from udtA"
strsql = strsql & " left join utmB on udtS.DOC_ID =utmB.flowid"
strsql = strsql & " left join utdC on utdC.masterid =utmB.id"
strsql = strsql & " where udtA.UDT_ID='10002'"
strsql = strsql & " and utmB.id is not null"
rs.Open strsql, gCnMysql, adOpenDynamic, adLockOptimistic
多表查询时出错。
单表查询时就没有问题。急啊。left join不用也不行啊。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货