Hi Ed,

For support question, better send e-mail to firebird-support@yahoogroups

Anyways...

> 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:

You cannot change to and from BLOBs.

> 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>).

Yeah, that's a common error with IBExpert. Great tool ;-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com