I'll try that. I'm worried about those users who have entered time values in that field after I changed from Date to Time. I'll test it and see.

Thanks for the catch. I hadn't thought of the domain change.

--- In firebird-support@yahoogroups.com, Ted Miglautsch <theomigs@...> wrote:
>
> Change it back and you should be fine.
>
> > 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
> >>
> >
> >
> >
> >
> > ------------------------------------
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups Links
> >
> >
> >
> >
>