| Subject | Re: [firebird-support] Interested question |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-03-05T10:00:17Z |
At 11:31 AM 5/03/2004 +0200, you wrote:
invalid. But you need your client dialect to be 1 also.
Then you can go in to the database and do
ALTER TABLE ATABLE
ALTER MONTH "MONTH"
OR
ALTER MONTH MONTH_
or whatever you want.
/heLen
>Good dayIf it is a Dialect 1 database (as an IB 5.x database would be) it isn't
>=-0p==-0-
>
>I am asking this out of interest , as we have already made changes to get
>around it.
>
>The question :
>If a older database (Interbase 5.6) has invalid columns or table names as in
>MONTH and TYPE in the database, why does FireBird allow the database to be
>RESTORED
>without ANY errors and a database VALIDATION comes back with NO errors ??
>
>Does the system not suppose to stop a invalid database to be restored ??
invalid. But you need your client dialect to be 1 also.
Then you can go in to the database and do
ALTER TABLE ATABLE
ALTER MONTH "MONTH"
OR
ALTER MONTH MONTH_
or whatever you want.
/heLen