I have a wingrid bound to a dataset (columns are KEY, VERSION, CODE, DESC). I have an event which is DATASET-NAME.TABLE-NAME.ColumnChanging. Each column cannot be empty and will fire this event except VERSION. It fires the Error event of the wingrid. If I remove the ColumnChanging event and try to trap for cellchanging events, all columns will fire the events when left empty except VERSION. It will fire the wingrids Error event.
Why is this column not behaving like the others? It is a NUMBER field.
I load the grid, change the CODE to be empty, it fires the columnchanging event and the IDataError for the grid will put an icon in the cell. If I change the VERSION column to be empty, it does not fire the columnchanging event but fires the wingrid_error event instead.
What's the error being reported in the Error event?
Unable to update the data value: Value in the editor is not valid
I am guessing this is because the field cannot be null according to the database but shouldn't the columnChanging event fire so I can catch this error instead of the grid's error event? Thanks for your response.
If the grid can't even update the editor, then it is never updating the data source and therefore, the data source can't know that anything has happened. I'm not entirely sure what the ColumnChanging event is or when it fires, but I can't see how it could possible fire if the value of a field fails to be set.