SQL

[JackSkellington]

I have a SQL stored procedure but can't seem to catch the return value if I do a return 1 etc. The code I have is;

objRequest.Command = USP_
objRequest.PopulateParams(a,stra)
objRequest.PopulateParams(b,strb)

Dim objDS AS New DataSet()

objDS = objFactory.ExecuteDataSet(objRequest)

objDS is empty even when the procedure hits a return 1 etc. Any suggestions?

 

[AlexCuse]

If you are returning an output parameter (and not a resulstset) you need to handle it differently than you would a reslutset. Check this out: Long URL

particularly the part with the heading "Using the Parameters Collection to Pass Parameters To and From Stored Procedures"

Hope this helps,

Alex



[small]----signature below----[/small]
Now you can go where the people are one!
Now you can go where they get things done!

 

[JackSkellington]

Sometimes the query will be returning reslutset.

 

[mmilan]

It should always return one or the other... Never either...