Hi Nick,

AFAIK there is a bug when using ALTER TABLE table ALTER field TYPE domain on
CHAR, VARCHAR fields. There are always two characters added to a CHAR,
VARCHAR definition.

Thomas

> -----Original Message-----
> From: Kaputnik [mailto:delphi@...]
> Sent: Tuesday, July 10, 2001 9:07 AM
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] Direct modification to system tables to...
>
>
> This shouldn't be a problem....
> Just tried it with a 4GB database, and everything seems fine here
> (queries on the affected table were running smoothly)
> Don't know how indizes on the affected columns could be affected,
> though.
> Other question:
> Why don't you do this with simple ddl, as changing the domain of a
> table's field is part of standard ddl? (ALTER TABLE table ALTER field
> TYPE domain)
>
> > -----Original Message-----
> > From: Jason Wharton [mailto:jwharton@...]
> > Sent: Tuesday, July 10, 2001 8:55 AM
> > To: ib-support@yahoogroups.com
> > Subject: Re: [ib-support] Direct modification to system tables to...
> >
> > > 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/
>
>
>