473,508 Members | 4,712 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

RaiseError and VB .Net

I am developing to an application in VB .Net that is due to connect to a data
base SQL Server 2000. When carrying out a validation for the insertion to a
table through trigger that when not being fulfilled certain conditions it
shoots an error by means of instruction RAISERROR; this trigger it works
perfectly from the Query Analyzer, nevertheless when trying to capture this
exception from application VB Net the same one does not go off, that is to
say, when executing the insertion from the application this culminates
outside as if successful.

Please I need that they indicate to me if instruction RAISERROR works for
the technology Net, since, for Visual BASIC 6,0 this works perfectly.
Aug 30 '05 #1
0 1310

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1874
by: Mark Vuksani | last post by:
Hi, I have a trigger like this (simplified to illustrate the problem): -------- CREATE TRIGGER Test ON . FOR INSERT, UPDATE, DELETE AS RAISERROR( 'test trigger error !', 16, 1)
17
7440
by: Steve Jorgensen | last post by:
If you've ever employed custom error numbers and messages in you programs, you've probably ended up with code similar to what I've ended up with in the past something like... <code> public...
0
348
by: Edgar Rodriguez | last post by:
I am developing to an application in VB .Net that is due to connect to a data base SQL Server 2000. When carrying out a validation for the insertion to a table through trigger that when not being...
17
4299
by: Lauren Wilson | last post by:
Does anyone know if it is possible to capture FTP responses to various FTP commands when managing an FTP session from a VBA procedure? For example, if we try to login to an FTP server and the...
0
1059
by: Daniel | last post by:
will a client application using ado.net get an exception if the command is executing a stored procedure that does a RAISEERROR in its tsql?
0
1834
by: vbnetguy | last post by:
Hopefully someone has an answer for this or maybe I am missing something. I have a stored procedure - this stored procedure is used as my main insert for a tableadapter I am doing something...
1
3714
by: Bit of a dummy | last post by:
Hi Maybe I've got the wrong end of the stick, I sort of thought that I could user raiserrror in an SQL statment to write to the SQL error Log: i.e. hittin f5 in Qery analyser with the statement ...
2
2679
by: shapper | last post by:
Hello, I am raising an error on my SQL 2005 procedure as follows: RAISERROR(@ErrorMessage, @ErrorSeverity, 1) How can I access it in my ASP.NET code? I am using Enterprise Library Data...
3
2666
by: slowdance | last post by:
Hi! Im new in this forum.. Obviously I need help, Is there a way I can make a Custom Error Message using RaiseError statement? This is the problem, I want an error message whenever a user...
0
7128
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7332
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
7058
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7502
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5635
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4715
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
1565
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
769
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
426
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.