I frequently make changes to system tables and started using Interbase
and then Firebird because I could do that. Mostly I extent the size of
char and varchar fields. It just requires knowing what you are doing.
You have to consider whether the change you are making could cause the
problem that you encountered.

homerjones1941 wrote:

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