The goal of this paper is to provide a rigorous methodology for enhancing VBA software application users’ experience when faced with attempts to violate the underlying SQL Server database constraints. The original contribution is a pseudo-code algorithm for assisting developers in this process. We exemplify the results of using it with a full code example for a class taken from a genealogy database software application designed and developed using this methodology. Consequently, it replaces all context-independent and developer jargon standard system error messages with context aware and natural language ones. Moreover, it also synchronizes combo-box instances after each update or delete. We also show that the proposed algorithm works fine not only for other relational database management systems, but even with NoSQL platform backends, and that the modifications needed to adapt it to other similar SQL embedding frontend platforms are minimal. This algorithm main merit is that it may serve as the basis for developing a tool for performing this important task through automatic code generation.
%0 Journal Article
%1 diana_christina_mancas_2023_7931942
%A Mancas, Diana Christina
%D 2023
%J Global Journal of Engineering and Technology Advances
%K Relational constraints database
%N 3
%P 172–187
%R 10.30574/gjeta.2023.14.3.0062
%T On replacing standard system error messages for relational database constraints with context aware natural language ones
%U https://gjeta.com/content/replacing-standard-system-error-messages-relational-database-constraints-context-aware
%V 14
%X The goal of this paper is to provide a rigorous methodology for enhancing VBA software application users’ experience when faced with attempts to violate the underlying SQL Server database constraints. The original contribution is a pseudo-code algorithm for assisting developers in this process. We exemplify the results of using it with a full code example for a class taken from a genealogy database software application designed and developed using this methodology. Consequently, it replaces all context-independent and developer jargon standard system error messages with context aware and natural language ones. Moreover, it also synchronizes combo-box instances after each update or delete. We also show that the proposed algorithm works fine not only for other relational database management systems, but even with NoSQL platform backends, and that the modifications needed to adapt it to other similar SQL embedding frontend platforms are minimal. This algorithm main merit is that it may serve as the basis for developing a tool for performing this important task through automatic code generation.
@article{diana_christina_mancas_2023_7931942,
abstract = {The goal of this paper is to provide a rigorous methodology for enhancing VBA software application users’ experience when faced with attempts to violate the underlying SQL Server database constraints. The original contribution is a pseudo-code algorithm for assisting developers in this process. We exemplify the results of using it with a full code example for a class taken from a genealogy database software application designed and developed using this methodology. Consequently, it replaces all context-independent and developer jargon standard system error messages with context aware and natural language ones. Moreover, it also synchronizes combo-box instances after each update or delete. We also show that the proposed algorithm works fine not only for other relational database management systems, but even with NoSQL platform backends, and that the modifications needed to adapt it to other similar SQL embedding frontend platforms are minimal. This algorithm main merit is that it may serve as the basis for developing a tool for performing this important task through automatic code generation.},
added-at = {2023-07-16T10:12:06.000+0200},
author = {Mancas, Diana Christina},
biburl = {https://www.bibsonomy.org/bibtex/28295d89e9077528ec2e8075a7e3450c0/gjetajournal},
doi = {10.30574/gjeta.2023.14.3.0062},
interhash = {65e7b3d1bd3b86ee46e4435fa45d703e},
intrahash = {8295d89e9077528ec2e8075a7e3450c0},
issn = {2582-5003},
journal = {{Global Journal of Engineering and Technology Advances}},
keywords = {Relational constraints database},
month = mar,
number = 3,
pages = {172–187},
timestamp = {2023-07-16T10:12:06.000+0200},
title = {On replacing standard system error messages for relational database constraints with context aware natural language ones},
url = {https://gjeta.com/content/replacing-standard-system-error-messages-relational-database-constraints-context-aware},
volume = 14,
year = 2023
}