karenmierkalns
Programmer
I am try to execute a simple update stored query (using Access with VB). One of the fields happens to be a memo datatype. What TYPE (DatatypeEnum) can I use for creating the parameter? Do I need to specify a field size? I haven't been able to find examples using memo fields.
I've tried adVarChar, adVariant, adVarWChar, etc. None seem to work, or I am omitting the size (but I don't know what to put in size)..
Here is the basic idea of what I'm working with:
<code snippet>
Dim comEdit As New ADODB.Command
With comEdit
.ActiveConnection = connFinAid
.CommandText = "updateStudent"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter("Comments", adVariant, adParamInput, , strComments)
.Execute
End With
Set comEdit = Nothing
</code snippet>
Thanks. - Karen
I've tried adVarChar, adVariant, adVarWChar, etc. None seem to work, or I am omitting the size (but I don't know what to put in size)..
Here is the basic idea of what I'm working with:
<code snippet>
Dim comEdit As New ADODB.Command
With comEdit
.ActiveConnection = connFinAid
.CommandText = "updateStudent"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter("Comments", adVariant, adParamInput, , strComments)
.Execute
End With
Set comEdit = Nothing
</code snippet>
Thanks. - Karen