Hi,
I have a simple maintenance form with an UltraGrid (2008 Vol 2) bound to a BBS with a 2 field BO. I set RequiredFields on both fields and when I add a new record to the grid and populate both fields, a save reports that there is a broken rule. On further examination the broken rule reports a value is required for the last field entered. I can see the value in the grid but accessing the field directly from the BO shows it as empty during the save.
If I remove the Required Fields check then I am able to add and save new records.
The following sequence hightlights the problem:-
1. Click the New button to add a new row.
2. Click the first cell, enter a value.
3. Tab into the second cell and enter a value but do not leave the cell. This is the cause of the problem.
4. Click on the form save. The UltraGrid is still in editing mode so the active cell hasn't updated the BO which means it fails the Required Fields check as the BO believes the field to be empty.
I have tried to exit edit mode on the grid but there doesn't appear to be an event that will allow this before the Required Fields check has cached the blank value. I have tried the BeforeSave on the form and CheckRulesOnCurrentRow on the BO. While the grid does exit edit mode and I can see the BO field has been updated correctly in both of these events, it looks like the Required Fields check has already cached the original blank value before these events are fired as the check continues to report the broken rule.
Has anyone encountered this problem and found a way around it?
Thanks in advance.
Aaron