I have an application that requires the addition of a required textfield in a separate component for addition to a grid table.
If the user attempts to add a record from a grid without filling in the external textfield there's obviously a response of not accepting a 'null field'. Filling in the textfield and hitting 'Post' comes back with the same error.
I have added an 'OnUpdateData' to fill in the field if it's mistakenly left blank but this approach is somewhat 'inelegant' (from my perspective).
Similarly, making changes to a record and updating the data with a blank textfield has the same issues - one has to use the 'OnUpdateData' route when hitting 'post' again.
Is there a way to ensure that the insert/update Post works with all the fields (i.e. will 'accept' the input from the textfield when it's properly filled in)? Seems that Post ignores changes to the external textfield after an Insert or Update has failed.
I tried 'UpdateAllFields' in the TQuery but this doesn't work either.
I am using a DevExpress DBGrid - not sure if this has anything to do with this?
Suggestions?