請教各位先進,如何對備忘資料型態(remark in access,or text in sql server 7.0)的DataTypeEnum,到底是
使用adVarChar參數,還是其他的。
Public Function InsertBank(ByVal strRemark As String,
ByRef objConn As ADODB.Connection, _
ByRef objCmd As ADODB.Command) As Long
On Error GoTo InsertBank_EH
Dim intIndex As Integer
Set objCmd.ActiveConnection = objConn
objCmd.CommandText = "dbo.up_parins_bankall"
objCmd.CommandType = adCmdStoredProc
'Append the parameters
objCmd.Parameters.Append objCmd.CreateParameter("Remark", adVarChar, adParamInput, 50, strRemark)
...