G
Guest
Hi to you all,
I need to pass a GUID to a stored procedure. The value I want to pass is
the value of a text box in a subform (see Form.Subform1.Form.setid.Value)
When I execute the following code, I get an error "Invalid character value
for cast specification".
Can't figure this out.
Any help appreciated !
Dim cn As ADODB.Connection
Dim cmd As ADODB.Command '
Set cn = CurrentProject.Connection
Set cmd = New ADODB.Command
With cmd
.ActiveConnection = cn
.CommandText = "sp_GetSetRunID"
.CommandType = adCmdStoredProc
.Parameters.Refresh
.Parameters("@mSetID").Value = Form.Subform1.Form.setid.Value
.Execute
End With
Set cmd = Nothing
cn.Close
Set cn = Nothing
I need to pass a GUID to a stored procedure. The value I want to pass is
the value of a text box in a subform (see Form.Subform1.Form.setid.Value)
When I execute the following code, I get an error "Invalid character value
for cast specification".
Can't figure this out.
Any help appreciated !
Dim cn As ADODB.Connection
Dim cmd As ADODB.Command '
Set cn = CurrentProject.Connection
Set cmd = New ADODB.Command
With cmd
.ActiveConnection = cn
.CommandText = "sp_GetSetRunID"
.CommandType = adCmdStoredProc
.Parameters.Refresh
.Parameters("@mSetID").Value = Form.Subform1.Form.setid.Value
.Execute
End With
Set cmd = Nothing
cn.Close
Set cn = Nothing