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