Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
|
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 19th, 2005, 03:19 PM
Authorized User
 
Join Date: Apr 2005
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default Can I return error codes if I am not using rs?

I don't know if this is possible. My program works for the most part except for when my stored procedure (which calls another stored procedure which calls yet another stored procedure) returns an error code (which is actually being returned by the 3rd stored procedure). My VB code is NOT using a recordset because I am not retrieving data from a query. Rather I am calling a stored proc that updates a table. The output is returned through my program for the most part. That is, unless there is a certifiable error (decided by the third stored proc). If an error is returned (anything other than the typical 'The command(s) completed successfully.'. Being that I am not using a recordset, how can I get this error and use it in my error processing so that my program doesn't bomb out, as it currently does in this case. Help!





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to hide RS error from cliant? roy_mm Reporting Services 0 July 24th, 2008 07:43 AM
object reqiured:rs error hastikeyvan Classic ASP Professional 1 March 14th, 2006 02:47 AM
RS Manager and RS Server on 2 different computers Choose File BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 1 July 22nd, 2004 10:56 AM
SQL Return codes PaulL BOOK: ASP.NET Website Programming Problem-Design-Solution 6 May 20th, 2004 03:15 AM
Error msg on rs.MoveNext jeff_M Classic ASP Databases 4 August 13th, 2003 10:38 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.