ADO error handling

Thread View: borland.public.cppbuilder.database.ado

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by vavan Wed, 31 Jan 2001 12:51

#5842

Author: vavan
Date: Wed, 31 Jan 2001 12:51

20 lines
1807 bytes

Here's snippet from simple stored procedure in MSSQL7:

RaisError('Message',10,1)
select SomePredefinedValue
return

If I run that sp using TADOStroredProc on my AppServer I can see
SomePredefinedValue in the grid on the client side. But if I change severity
code (the second parameter in raiserror) from 10 to 11 it throws an
exception 'Message' on client side and no result are shown in the grid. That
exception happens in ADODB.PAS TCustomADODataSet.OpenCursor on the following
line:

Recordset.Open(Source, ActiveConnection,CursorTypeValues[FCursorType],
LockTypeValues[FLockType],CommandTypeValues[CommandType] +
ExecuteOptionsToOrd(ExecuteOptions));

But if I run that sp within the SQL Profiler then I can see both error
message and resultset. Is there a way to suppress or ignore that error
message and show resultset anyway?

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads