When we need to change a field type we create a new field with the new
type, move the old data to the new field and then drop the old field. Then
You can rename the new field name by the old.
I know there is too much effort... But I do not know a better approach.
Em 17/05/2013 17:42, "homerjones1941" <homer@...> escreveu:

> **
>
>
> The application is in beta, and I suspect there may be other times when a
> change of domains is needed. Is there a way to do that without touching
> system tables? My users are scattered all over the USA, so it isn't
> reasonable for me to personally make such changes. I must do it via an
> application that is distributed to the users.
>
> --- In firebird-support@yahoogroups.com, fabianoaspro@... wrote:
> >
> > Simple: do not touch system tables unless you know exactly what you are
> > doing!
> > This will avoid problems at all. There are no problems associated with
> > reading system tables with less frequency.
> > Em 17/05/2013 17:25, "homerjones1941" <homer@...> escreveu:
> >
> > > **
> > >
> > >
> > > I ran verbose and found the table. But, being a novice, I did alter the
> > > data type. It had been a date field, and I changed it to a Time field.
> I
> > > thought changing the domain was all I needed to do. I was wrong. What
> is
> > > the best way to fix my error?
> > >
> > > BTW, this was done via a Delphi app, that has been distributed to
> about a
> > > dozen beta testers.
> > >
> > > Here's how I made the change. Any suggestions about how to do something
> > > like this in the future without getting myself into trouble?
> > >
> > > update RDB$RELATION_FIELDS
> > > set RDB$FIELD_SOURCE = 'D_TIME'
> > > where (RDB$FIELD_NAME = 'EFFECTIVETIME')
> > > and (RDB$RELATION_NAME = 'DETF')
> > >
> > > --- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@> wrote:
> > > >
> > > >
> > > >
> > > > > Overflow occurred during data type conversion.
> > > > > conversion error from string "2013-04-11".
> > > > > gds_$receive failed.
> > > >
> > > > Run Gbak with verbose, it will identify the table which has the
> problem.
> > > >
> > > > Did you alter the data type/domain of any columns of the problem
> table?
> > > >
> > > >
> > > > Sean
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>

[Non-text portions of this message have been removed]