我定义了Dim strSLCPODQry As String * 1000或者Dim strSLCPODQry As String然后给赋值 strSLCPODQry = " SELECT a.OrderNo, a.ShipOrderNo, a.Field1, b.CustPONo, b.SkuNo, b.RequestQty " & _
" FROM sdShipOrder a, sdShipSku b " & _
" WHERE a.ShipOrderNo = b.ShipOrderNo " & _
" AND a.ShipDate BETWEEN '" & p_MatchFromDate & "' AND " & " '" & p_MatchEndDate & "'" & _
" AND a.UserCategory IN ('MB' , 'Chassis') " & "AND a.ShipOrderNo LIKE 'ERT%'" & _
" AND a.Cancelled = '0' AND a.o_customercode = 'DELL'" & _
" AND a.Field1 IS NOT NULL AND a.field1 <> '' " & _
" AND a.Discrepancy <> '2'" & _
"ORDER BY a.ShipDate "我在DEBUG的时候,发现strSLCPODQry的长度只有250,超过的部分就给截掉了,这是怎么回事呢?麻烦高手帮忙,谢谢!!!
" FROM sdShipOrder a, sdShipSku b " & _
" WHERE a.ShipOrderNo = b.ShipOrderNo " & _
" AND a.ShipDate BETWEEN '" & p_MatchFromDate & "' AND " & " '" & p_MatchEndDate & "'" & _
" AND a.UserCategory IN ('MB' , 'Chassis') " & "AND a.ShipOrderNo LIKE 'ERT%'" & _
" AND a.Cancelled = '0' AND a.o_customercode = 'DELL'" & _
" AND a.Field1 IS NOT NULL AND a.field1 <> '' " & _
" AND a.Discrepancy <> '2'" & _
"ORDER BY a.ShipDate "我在DEBUG的时候,发现strSLCPODQry的长度只有250,超过的部分就给截掉了,这是怎么回事呢?麻烦高手帮忙,谢谢!!!
是不是DEBUG的问题
但是如果sql执行有问题,那我要想在debug的时候看到我完整的sql,要怎么办呢?你们一般是怎样处理的呢?
msgbox 遇到chr(0)的时候后面的就不能显示了