| form message [message #237329] |
Mon, 14 May 2007 03:05  |
u263066
Messages: 47
Registered: March 2007
|
Member |
|
|
there is one procedure in the database, I need to call this procedure from some button in the form.
There is some debug message written in the procedure,since earlier it was called by database end only.
Is there any way to retrive the message from procedure and syconize with form message,
|
|
|
|
| Re: form message [message #237477 is a reply to message #237329] |
Mon, 14 May 2007 11:02  |
lavallee_g
Messages: 22
Registered: May 2005
Location: Quebec
|
Junior Member |
|
|
You can trap the messages that comes from the database in a on-error trigger at for level. You can catch any type of messages like constraints failure or primary key failure. It will even give you the name of the constraint that failed so you can even display a specifi message for each constraint on you table.
To be able to display your message in form, you need to raise your error using something like raise application error...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
