I'm using OnValidateField for a TIB_Query connected to a TIB_Grid.
The grid has only 1 line of data.
I put in a bad value and click the OK button which calls 'if
query.needtopost then query.post'
The error is displayed and the value in the grid returns to its original
value.
Clicking OK again raises the error again even thought the grid is showing
the old (acceptable) value.
The only way to get out is to press Esc, which doesnt change anything
visually (including the indicator column), then click OK again.

This is very confusing for the user.

I could post a message in OnValidateField handler which calls query.cancel
but this seems somewhat cumbersome.

Is there a better way of doing this?

Regards
Paul


[Non-text portions of this message have been removed]