Subject | new domain for field corrupts database |
---|---|
Author | Dressel@AnnuityPeople.com |
Post date | 2004-09-08T18:33:52Z |
I have a very simple database where I
(1) create a new domain:
CREATE DOMAIN DM_MEMO AS
BLOB SUB_TYPE 1 SEGMENT SIZE 100 CHARACTER SET NONE
(2) change a field's definition from varchar(100) field to the the
new domain:
update RDB$RELATION_FIELDS set
RDB$FIELD_SOURCE = 'DM_MEMO',
RDB$COLLATION_ID = -1
where (RDB$FIELD_NAME = 'PROPERTIES') and
(RDB$RELATION_NAME = 'REPORTS')
but when I try to do a Select from the table the field belongs to I
get the following exception:
Unsuccessful execution cause by a system error that precludes
successful execution of subsequent stateemnts. internal error.
Am I not allowed to issue the above updates? (IB Expert let me do it
real easy<g>).
Thanks
Ed Dressel
(1) create a new domain:
CREATE DOMAIN DM_MEMO AS
BLOB SUB_TYPE 1 SEGMENT SIZE 100 CHARACTER SET NONE
(2) change a field's definition from varchar(100) field to the the
new domain:
update RDB$RELATION_FIELDS set
RDB$FIELD_SOURCE = 'DM_MEMO',
RDB$COLLATION_ID = -1
where (RDB$FIELD_NAME = 'PROPERTIES') and
(RDB$RELATION_NAME = 'REPORTS')
but when I try to do a Select from the table the field belongs to I
get the following exception:
Unsuccessful execution cause by a system error that precludes
successful execution of subsequent stateemnts. internal error.
Am I not allowed to issue the above updates? (IB Expert let me do it
real easy<g>).
Thanks
Ed Dressel