top of page

BVDL

Public·2 members

Tick boxes instead of a drop down to select Error Messages

Sometimes, the error message that is returned is not a user-friendly BVDL error message, but actually a SQL message, e.g.:


‘Procedure or function ‘USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_ORGTOORG_4’ expects parameter ‘@ISPARENTRELATIONSHIP’, which was not supplied.’


When this happens, although these error messages show up in the Errors window when you view the individual records, selecting them in the Error Message drop down returns no records. If I could exclude specific Error Messages then I could show the records that did not have those and return the records that do have the error message that I am trying to explore. Where records have multiple error messages, just excluding one of them might result in me also excluding the 'hidden' SQL error message, so with tick boxes like this I could determine where the SQL error corresponds to another error message as well to select the right ones.


Currently, when this happens in large imports, it can be frustrating to find the records with these SQL errors to work out what's causing the problem.

6 Views
Be the first to know...subscribe to the blog
Thank you!
Let's Connect (*please do not create customer support tickets here, log into the helpdesk or email support

THANK YOU! 

  • LinkedIn

BrightVine Solutions, Inc. (BrightVine) is a member of the Blackbaud partner network. BLACKBAUD®, THE RAISER'S EDGE®, BLACKBAUDINTERNETSOLUTIONS®, BLACKBAUD CRM®, and RAISER'S EDGE® are registered trademarks of Blackbaud.  BRIGHTVINE, the BRIGHTVINE® LOGO, BRIGHTVINE DATA LINK and DELIVERING EXCELLENCE FOR GOOD® are registered trademarks of BrightVine Solutions.

All other third-party trademarks mentioned on this website are the property of their respective owners. 

© 2025 BrightVine Solutions | All Rights Reserved

bottom of page