Sources for Exceptions When You Save Data into a Batch
When you save data into a batch table through the batch grid user interface, exceptions may arise from many sources:
-
Form Field Metadata
-
Database Constraints
-
RaiseError() within Save Implementations
-
Batch Event Handlers
Without some background, it can be hard to decipher where errors originate. So let's explore some of the ways that you can cause exceptions when you save rows to a batch.
Exceptions from Form Field Metadata
Form Metadata helps to ensure data integrity and can cause exceptions when you save a batch with form fields that contains built in validation metadata such as required. As a review, our batch table is named USR_BATCHFOODITEMADD. This table contains a NAME field that is required. The NAME field was created by the following field in the TableSpec:
<TextField Name="NAME" Length="100" Required="true" />