ＡＤＯ command對象使用疑惑

Question

使用Set recordset = command .Execute( RecordsAffected , Parameters , Options )模式，如果參數中有空的話，ＶＢ系統會自動將它轉換為8000個空格，而用 Parameters對像一個一個的給所有的非空參數賦值的話就不會有空格的問題，示例如下　：
        For i = 0 To UBound(pParams) Step 1
            If pParams(i) <> "" Then
            lCmd.Parameters.Item(i + 1).Value = pParams(i)
            End If
next i
我想弄清楚為什麼會這樣,有沒有更好的辦法解決空格的問題，請大家幫忙分析一下。
以下是用perfiler抓取的到數據，請參考。
exec aaa
'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
','51'

Answer 1

pParams是striing数组吧

command 会根据值转到可以接受的数据类型上

---

http://feiyun0112.cnblogs.com/

Answer 2

Ｐparams是變體類型數組
關鍵是它自動將空字符串自動轉變為８０００個空格了，我是想有沒有辦法解決它

Answer 3

指定Type & Size

---

http://feiyun0112.cnblogs.com/

Answer 4

能不能說的更詳細點呢？我在你的博客中沒有找到你說的內容。

Answer 5

http://www.w3school.com.cn/ado/ado_ref_parameter.asp

---

http://feiyun0112.cnblogs.com/