Subject | RE: [ib-support] setting nullable column |
---|---|
Author | Riho-Rene Ellermaa |
Post date | 2003-04-14T06:35:40Z |
I found the following script
UPDATE RDB$RELATION_FIELDS
SET RDB$NULL_FLAG = 0
WHERE RDB$RELATION_NAME = 'EMPLOYEE'
AND RDB$FIELD_NAME = 'LAST_NAME';
It seemd to run ok and when looking with IBAdmin, it shows that column LAST_NAME is nullable.
But when I try to insert some values FB still says "validation error, column is null"?
Riho-Rene Ellermaa
senior programmer
Hansabank
UPDATE RDB$RELATION_FIELDS
SET RDB$NULL_FLAG = 0
WHERE RDB$RELATION_NAME = 'EMPLOYEE'
AND RDB$FIELD_NAME = 'LAST_NAME';
It seemd to run ok and when looking with IBAdmin, it shows that column LAST_NAME is nullable.
But when I try to insert some values FB still says "validation error, column is null"?
Riho-Rene Ellermaa
senior programmer
Hansabank