> This showed the modified table with AlwaysMonitor set to 0 for all
> records, so the front-end software had made the changes correctly (it
> still shows this after disconnecting all clients and then reconnecting
> with FlameRobin). Then I tried to modify one of the other fields in
> the table using the FlameRobin table display interface, and that's when
> the error "validation error for column AlwaysMonitor, value
> "***null***"
> gets displayed. This happens even if all clients are completely
> disconnected and then reconnected.
>
> >> The insert failed because a column definition includes validation
> >> constraints.
> >> Engine Code: 335544347
> >> Engine Message:
> >> validation error for column AlwaysMonitor, value "***null***".
> >

so it's a flamerobin issue?
If you just use ISQL to issue this statement, do you get the exception?
Alan