When user clears all contents on numeric data column in Grid. using delete key and then presses elsewhere on the UI in a different control. System throws a message Unable to update the data value but never returns control back to that field with null value. One dismisses this message and the error returns. Since the control is no longer back to that field, there is no way to put a valid value there.
The only way to get out of this infinite loop is to terminate the application.
Can I fix this using a combination of Nullable and NullText to address this problem?
Hi,
This sounds like a bug in that older version. There's not much you can do without upgrading to either the latest service release of a new version in which the bug does not exist.
One thing you could try, though, is to trap the CellDataError and/or the Error event and use the events args to cancel the Error Message. This kind of problem usually occurs because the MessageBox itself interferes with the cell as it is losing focus. So not displaying the MessageBox may help get you out of the loop.
If that does not work, see if you can reproduce the infinite loop in a small sample project and post it here and I will see if I can find another workaround for you.