I have the following stored procedure which is always returning a NULL output
parameter (which is incorrect).
I've used this method before and everything has worked fine.
Has anyone got any idea why the code returns NULL.
(When I run the same stored procedure, with the same parameters, in Query
Anaylzer, it works fine)
thanks,
Angelo
Set cnn = CurrentProject.Connection
Set cmd = New ADODB.Command
With cmd
.ActiveConnection = cnn
.CommandType = adCmdStoredProc
.CommandText = "dbo.prcTTOCreateTimetable"
.Parameters.Append .CreateParameter("@IDValue", adInteger, adParamInput)
.Parameters.Append .CreateParameter("@IDType", adVarChar, adParamInput,
20)
.Parameters.Append .CreateParameter("@TTTypeID", adInteger,
adParamInput)
.Parameters.Append .CreateParameter("@StopNameType", adInteger,
adParamInput)
.Parameters.Append .CreateParameter("@WebsiteFormat", adInteger,
adParamInput)
.Parameters.Append .CreateParameter("@DescShort", adVarChar,
adParamInput, 10)
.Parameters.Append .CreateParameter("@OutputColumns", adInteger,
adParamInput)
.Parameters.Append .CreateParameter("@StartDate", adDate, adParamInput)
.Parameters.Append .CreateParameter("@EndDate", adDate, adParamInput)
.Parameters.Append .CreateParameter("@MaxColumns", adInteger,
adParamOutput)
.Execute Parameters:=Array(intIDVAlue, "'" & strIDType & "'",
intTTType, intStopName, intWebsite, Null, 200, Null, Null)
End With
lngNbrServices = cmd.Parameters("@MaxColumns") ' get result
------------------------ Yahoo! Groups Sponsor --------------------~-->
1.2 million kids a year are victims of human trafficking. Stop slavery.
http://us.click.yahoo.com/.QUssC/izNLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
