试试这样写:
With cmd
.ActiveConnection = Cn
.CommandType = adCmdStoredProc
.CommandText = "table_insert"
.Parameters("@aa") = "9"
.Parameters("@bb") = 123.45
.Execute
End With
With cmd
.ActiveConnection = Cn
.CommandType = adCmdStoredProc
.CommandText = "table_insert"
.Parameters("@aa") = "9"
.Parameters("@bb") = 123.45
.Execute
End With
那你在vb端prm.createparmase("@aa"..)
中对应的ado数据类型选择那个.我选adnumric不行,老是报精度有误.
就算cdec()转换后,还是老样子,后来我用了addouble就成功了,不知我这样设置有无问题啊!还有sql server的deciaml数据类型明明对应ado的adnumric,但就是报精度这个问题。真的搞不懂.