we have two database servers. one with Adaptive Server 11.9.2, the other
with Adaptive Server 126.96.36.199.
On both are exactly the same databases. In one table there is a char(1)
column bound to a user datatype including a rule, which allows only a "Y"
or a "N". The column is allowed to have NULL values
If I try to insert a row under 11.9.2 nothing happens, I can insert a NULL
value in this column.
Under 188.8.131.52 I get the error 522 "A column insert or update conflicts
with a rule bound to the column ..... "
I cannot explain that for myself. Is there a significant difference between
the two versions regarding rules and NULL values?
Since this is urgent, I would appreciate if anyone could give me an answer
about that "funny" behavior.