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]