Just be crafeul when there are dependencies on that field in (for
example) stored procedures.
Check these dependencies before you alter the domain.
If necessary alter the procedures to an empty body, change the domain,
change the procedure (and it's variables) according to your needs and
then re-add the procedure.

luc.

Jason Wharton schrieb:

>
> > most of the IB administration Systems do it right this way:
> >
> > update RDB$FIELDS set
> > RDB$FIELD_TYPE = xx
> > where RDB$FIELD_NAME = xx
> >
> > I never experienced any problem with this....
>
> Nor have I but in my case I am doing this:
>
> UPDATE RDB$RELATION_FIELDS
> SET RDB$FIELD_SOURCE = xx
> WHERE ...
>
> This takes a column and changes it from one domain to another domain.
> I cannot change the type of the domain because other columns defined with it
> need to remain as they are.
>
> Thanks for any additional comments.
>
> PS. It does seem to be working without any fireworks.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/