When using RAISERROR in a SQL trigger to prompt an error message, the message is not displayed through VRL. A generic "Error saving the record" appears while the real error message returned from the trigger is populated in DDAL. We either need the RAISERROR message passed through VRL, or for custom validation through Vista refined.
Submitted as CASE:30829811
Requested to be resubmitted as Suggestion
When using RAISERROR in a SQL trigger to prompt an error message, the message is not displayed through VRL. A generic "Error saving the record" appears while the real error message returned from the trigger is populated in DDAL. We either need the RAISERROR message passed through VRL,
Veronica Healey
| Company | Troy Life & Fire Safety Ltd |
| Job Title / Role | Process and Systems Development manager |
| I need it... | Yesterday...Come on already |
Dear Viewpoint Suggestion Box contributor;
We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs.
Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.
Understood and agree - we'll look to surface the full error message
The only way to see detailed error messages is to query the vDDAL table in SQL. This is not conducive to productivity as users can't see what they need to be able to do their work.