No - it's not a FlameRobin issue. Here's the output from ISQL, which
as you can see mirrors the FlameRobin response:

SQL> SELECT "ReaderID","Direction","AlwaysMonitor" FROM "Readers";

ReaderID Direction AlwaysMonitor
============ ========= =============
1 0 0
2 0 0
3 0 0
4 0 0
5 0 0

SQL> UPDATE "Readers" SET "Direction"=1 WHERE "ReaderID"=5;
Statement failed, SQLCODE = -625
validation error for column AlwaysMonitor, value "*** null ***"

Regards,

Robert.

Alan McDonald wrote:

>> 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
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.339 / Virus Database: 270.12.34/2122 - Release Date: 05/19/09 06:21:00
>

----------


----------


No virus found in this outgoing message.
Checked by AVG - www.avg.com
Version: 8.5.339 / Virus Database: 270.12.34/2122 - Release Date: 05/19/09 06:21:00


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