Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Raise an exception from within a SP
Message
 
 
To
15/09/2006 11:54:21
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01076224
Message ID:
01154165
Views:
23
>Try,
>
>SP side-
>   if @@error<>0 return -1
>or
>   if @@error<>0
>   begin
>    raiserror(' Customized error message here',19,1) with log
>    return -1
>   end
>-----------------------------------------------------------------
>VFP side -
>   if sqlexec(nsqlhnd,"exec SP_name")<0
>      AERROR(a_err)
>  *   DISPLAY MEMORY LIKE a_err
>      lcerr=STREXTRACT(a_err(2),"[SQL Server]")
>      Messagebox(lcerr,16,"")
>   endif
>
Thanks.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform