为什么我的String 的最大长度只有 310 个字符?
Private Function GetSQL() As String
Dim strSQL As String
If Combo_JSLX.Text = "到货" Then
'查询到货
strSQL = "select a.cgjsbh 结算编号, b.ghsmc 供货商名称, a.cgbh 采购编号, a.jsrq 结算日期, a.jszl 结算种类," & _
"a.jssl 结算数量, a.jsmy 结算码洋, a.jssy 结算实洋, c.ygmc 结算人 " & _
"from cgjs a, ghsbm b, tsygbm c " & _
"where a.ghsbh = b.ghsbh and a.ysrbh = c.ygbh "
Else
strSQL = "select a.thjsbh 结算编号, b.ghsmc 供货商名称, a.thbh 退货编号, a.jsrq 结算日期, a.jszl 结算种类," & _
"a.jssl 结算数量, a.jsmy 结算码洋, a.jssy 结算实洋, c.ygmc 结算人 " & _
"from thjs a, ghsbm b, tsygbm c " & _
"Where a.ghsbh = b.ghsbh And a.ysrbh = c.ygbh "
End If
'确定期间
strSQL = strSQL & "where trunc(jsrq) >= to_date('" & sRQ.Value & "','yyyy-mm-dd') and trunc(jsrq) <= to_date('" & eRQ.Value & "','yyyy-mm-dd') "
Dim nLen As Long
nLen = Len(strSQL) '字符丢了!!!!!!!!!!!!!!1
GetSQL = strSQL
End Function