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