>>>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.
Einar,
Ignore 'BTW' part. I missed you already had CommandType.StoredProcedure there. I'll try to locate and point the code to you.
Cetin