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
>