大家好，
我程式后臺用的是access資料庫，采用Microsoft.Jet.OLEDB.4.0的方式連接資料庫。select查詢時，有一個欄位的值是通過字串拼接得到的，現發現，如果結果字串的長度大于255，賦值給recordset后，結果是不對的，會被截斷。
同樣的select陳述句在access資料庫中執行，回傳的結果正常，說明select陳述句本身沒問題。請問，長度大于255的字串計算結果如何賦值給recordset，謝謝！
程式如下：
Dim Conn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim strConn$, strSQL$, strExpression$
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\try.mdb;Persist Security Info=False"
Conn.CursorLocation = adUseClient
Conn.Open strConn
'這里本應為字串計算運算式，為了簡化問題，我用固定字串替代，總長度為554
strExpression = "'1,2,3,4,5,6,7,8,9,11,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,201,203,204,205,206'"
strSQL = "Select *," & strExpression & " as MayViewFields from SheetList"
With rst
.CursorType = adOpenStatic
.LockType = adLockOptimistic
.CursorLocation = adUseClient
.Open strSQL, Conn
End With
Debug.Print rst.Fields("MayViewFields")
'列印的字串，只有255個字符：1,2,3,4,5,6,7,8,9,11,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,
'也就是說，總長度為554的字串，通過sql select陳述句賦值給欄位后，只剩下255個字符，其它被截斷丟失
rst.Close
Conn.Close
uj5u.com熱心網友回復：
access最長只能是255uj5u.com熱心網友回復：
據說引號要轉換。你這種情況，不如試試用陣列來處理資料。uj5u.com熱心網友回復：
access最長只能是255，建議換一個資料型別，附件，可以解決問題uj5u.com熱心網友回復：
什么樣的查詢會鍵入這么長的關鍵詞？ 實際應用中我是沒碰到過這樣的需求。是不是可以嘗試從源頭去更改解決這個問題的思路，而不要局限于在資料庫端。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/30036.html
標籤：Access