Subject new domain for field corrupts database
Author Dressel@AnnuityPeople.com
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