how can i get a message in the application itself when i want to insert data into the database

Question

0.00/5 (No votes)

See more:

Sir,

Actually i have written a trigger on a table.when we want to insert data into that table the trigger fires based on the condition given.here is the point what i want to do is i have to display the message( what the trigger gives) in a message box in the application(which is running).

Thank you,

Posted 5-Apr-11 22:23pm

lakshmanriz

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

*dan!sh* · Answer 1 · 2011-04-05T22:32:00

This doesn't looks like a correct design to me. You cam modify the insert stored procedure and return the message from there. Or, your trigger must be writing that message in an audit table or something similar. So once the insert is done, read the audit table and get the message from there.

BTW what does this trigger do? And what kind of message you want to display?

Update: Bad design. Sorry. This should be checked in the UI and in the BusinessLogic before doing the save. This check should also be placed in the stored procedure doing the insert. Both BusinessLogic and SP should throw an exception to tell that the price is not correct. Something custom preferably like BusinessValidationException.

Your UI should then handle this exception and show the message to the user.

You do not need and cannot use trigger for that (assuming values over 1000 are not stored in the column).

Update 2: You do not have to wait till incorrect data reaches DB. Check it in the UI, check it in the BusinessLayer and then check it in the DB as well. This is how it should be done. UI can show the validation message to the user. BusinessLayer and DB have to tell the UI that the data is wrong. This can either be done through a return value from the methods or through exceptions. Triggers are not for this purpose.

Wendelius · Answer 2 · 2011-04-06T09:00:00

One way is that you use a separate table. Add the messages to this table in the trigger, for example:

INSERT INTO Messages (...) VALUES (.., 'Something from the trigger')

And after the operation is done, read the contents of the table from the client.

However, based on your example you should not create a design like this to get confirmations from client. The basic rules of ACID is that conversations with the user go like this:
1. Validity checks, possible questions
2. start transaction
3. execute dml operations
4. commit/rollback
5. inform the user

So there's no conversation, never, with the user while the transaction is active. If this golden rule is broken, you'll end up to serious locking based problems.

how can i get a message in the application itself when i want to insert data into the database

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0