Hi !

I get experience in this problem:

Check this table:

CREATE TABLE "TEST"
(
"A" INTEGER NOT NULL,
"B" INTEGER,
"C" VARCHAR(10) CHARACTER SET WIN1250,
"X" INTEGER
);

INSERT INTO TEST (A, B, C, X) VALUES (1, 1, 'a', NULL);
INSERT INTO TEST (A, B, C, X) VALUES (2, NULL, NULL, NULL);
INSERT INTO TEST (A, B, C, X) VALUES (3, NULL, NULL, NULL);
INSERT INTO TEST (A, B, C, X) VALUES (4, NULL, NULL, NULL);
INSERT INTO TEST (A, B, C, X) VALUES (5, NULL, NULL, NULL);

Ok.

If I open this table in IBOConsole/IBOQuery, or in IBExpert, then it
show the records/fields correct (as is).

But when I modify the B,C,X fields to NOT NULL in IBxpert...

update RDB$RELATION_FIELDS set
RDB$NULL_FLAG = 1
where (RDB$FIELD_NAME = 'B') and
(RDB$RELATION_NAME = 'TEST')

... and then I reload the table, it is changed.

The IBExpert/FibPlus shows the correct field contents, NULL-s.

The IBX/IBO/IBOConsole shows the default field values, integers as 0,
strings as '', etc.

Why ?


Thanx:
KK