Hi /heLen
-=-==-=-=
I understand what you are saying in regard to connect, whe do connect with
Dialect 1. (Using IBX that is) and I have made sure
the database dialect is 1. I believe the isql will default to the databases
dialect. But do I understand correctly that
in dialect one it is suppose to work with MONTH (table and column) and TYPE
(column) names or do you mean
I can connect via dialect one and THEN change to valid names and go on from
there ??

Thanks for your reply and patience

Johannes Pretorius


At 12:00 05/03/2004, Helen Borrie wrote:

>At 11:31 AM 5/03/2004 +0200, you wrote:
> >Good day
> >=-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 ??
>
>If it is a Dialect 1 database (as an IB 5.x database would be) it isn't
>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
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.613 / Virus Database: 392 - Release Date: 04/03/2004

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.613 / Virus Database: 392 - Release Date: 04/03/2004


[Non-text portions of this message have been removed]