Re: How to retrieve StoredProc raiserror code?

Brian,

Since it does a raiserror, it wouldn't GET to the return. Unless I'm
missing something. It is just like doing a raise Exception.Create in a
function. The function isn't going to return a result if the exception is
raised. No?


"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote in message
news:obuv74l60n478hdvm1jv6eqs88gtrb4j5n@xxxxxxxxxx

I have a stored procedure that is failing and issues a raiserror. How to
determine that in my win32 app? And get the return code?

If your stored procedure uses a Return parameter you just examine the
value
after executing the storedProcedure with your TadoDataset or TadoCommand.
You can also look at the TadoConnectionn.Errors collection for more
information
generated by errors.


--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx


.

Relevant Pages

  • Re: RaiseError with @@ERROR as first parameter
    ... Why would you want to raise an error ... Also, even if RAISERROR ... SQL Server MVP ... > I can not change the stored procedure code.. ...
    (microsoft.public.sqlserver.programming)
  • Re: How to retrieve StoredProc raiserror code?
    ... I'm missing something. ... the stored procedure doesn't stop execution. ... Since it does a raiserror, it wouldn't GET to the return. ... If your stored procedure uses a Return parameter you just examine the ...
    (borland.public.delphi.database.ado)
  • Re: Now: @Original_parameters not set.
    ... almost looks like a column mapping is missing... ... Where "EmplNum" is the colummapping and the DataRowVersion.Original maps ... > Here's my error and the definition for the Stored Procedure. ...
    (microsoft.public.dotnet.framework.adonet)
  • Limit of 150 rows in a combobox?
    ... I can't find an answer to this in the newgroup postings, ... datasource is a SQL Server stored procedure. ... 200 rows when executed on SQL Server. ... Any advice on finding these missing rows would be most ...
    (microsoft.public.access.forms)
  • Re: SQLServer dosnt throw warning message !
    ... I believe it only throws that error for a missing stored procedure. ... SQL Server MVP ... > Is there any witch to turn ON in order to have this message, I'm pretty sure> I didn't change any setting in my server> ...
    (microsoft.public.sqlserver.programming)