Hi,
Suppose this scenario,
you have two grids ,
master (relates to a student information row and has a field that tells how many subjects he can enrolls in)
detail ( information of subjects to be enrolled in and not exceed the total count defined in master)
I've created a process for some calculation on columns on the detail IG beside the normal DML process also I've created a validation on detail grid to check the rows already stored in DB and raise an error if the newly record will exceeds the maximum count.
This works fine when handling one row at a time, but when adding too many rows ( exceeds the maximum defined in master ) and press save for them all, the validation fails raise the error.
What is the behavior of validation and DML process related to IG, because I assume that the validation is done for all records before doing the DML processing (inserting bulk records), but that should be combined in a way as:
validate a row - any processes related to IG for a row - DML process for a row
rather than
validate rows - any processes related to IG for rows - DML process for rows
I hope that I explained the problem clearly.
Thanks
@ed-jones-oracle