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.