>>I am having some problems capturing the return value from a SP after I excecute it. Here is the code I use:
>>
>>
>>SqlConnection oCon = new SqlConnection(this.ConnectionString);
>>SqlCommand cmd = new SqlCommand("mySP", oCon);
>>cmd.CommandType = CommandType.StoredProcedure;
>>SqlParameter oParam = cmd.Parameters.Add("@Id", SqlDbType.UniqueIdentifier);
>>oParam.Value = myID;
>>oCon.Open();
>>cmd.ExecuteNonQuery();
>>oCon.Close();
>>
>>
>>I have been raising exceptions within SPs to notify the client that something was not cosher, but I would also like to know how to evaluate the return value from a SP.
>>
>>Let us assume that for this example the SP looks something like this:
>>
>>UPDATE myTable SET Name = 'Einar' WHERE Id = @Id
>>RETURN @@ERROR
>>
>
>Einar,
>I don't know if I posted it also on .Net section, search VFP section for ADO and return parameter. Same applies to .Net I think. In .Net it should be easier since a return parameter to return a value recordset needs to be closed.
>BTW: You specify commandtext and commandtype to be a stored procedure.
>Cetin
Cetin,
Thank you for your reply. I don't have PUTM (I can justify it for myself, but I am having a hard time justifying it to my bosses {the VP and my wife <s>}), so I can't search. If you could link the message it would be great.
What do you mean by:
You specify commandtext and commandtype to be a stored procedure? I do specify that it is a SP in the commandtype, and I specify the command text in the contructor of the command.
Semper ubi sub ubi.