> You are correct Alan,
>
> I recently purchased IB/Firebird development studio to help with my
> projects, and I note in the metadata it is Delimited, ie "VERSION"
>
> I Cannot edit any of the records.

what do you mean? how are you editing? what is the error?

>
> If I drop all the records, then try to insert new records, I get
> constraint
> errors that are constraints for other tables!

I'd keep looking if I were you. This doesn;t make sense and it's easy to
misunderstand the messages when you're in a state of panic.

>
> In more than 8 years I've never had a corrupt production database with
> firebird, and it would appear this one is now corrupt??
>

I doubt it. be patient, keep looking. do a backup and attempt restore
without overwriting any producton database.

>
>
> I checked the docs for FB2.0, and no mention of VERSION being a reserved
> word, but from what I see here it appears so.
>

it's been reserved for a very long time - since before V4 as I remember.
Up until dialect 3 came about you were prevented from using it at all.
Since dialect 3, you were permitted to use it as long as you delimited it.
Most tools now don't even tell you that you are trying to use a reserved
word, they delimit it for you end of story.
Alan

>
>
> Thanks
>
>
>
> Adrian
>
>
>
> _____
>
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Alan McDonald
> Sent: 23 November 2006 12:39 PM
> To: firebird-support@yahoogroups.com
> Subject: RE: Re[2]: [firebird-support] Is VERSION a reserved word in
> Firebird 2.0?
>
>
>
> > > Adrian Wreyford wrote:
> > >> I'm experiencing strange behaviour with a table called
> > VERSION. I cannot
> > >> edit the records of this tables, nor from my previously
> > working apps, while
> > >> running Firebird2.0
> > >
> > > IIRC, it's reserved at least since IB 6.0.
> > >
> > > Dmitry
> >
> > In my database (FB 1.5) I have table fiel with name VERSION
> > without any problem.
> > Some days ago I restored this database under Firebird 2.0
> without errors.
> >
> > My question is:
> > Should I change field name ? Is there any reason for than?
> >
> >
> > Thanks in advance,
> > Agibov Dmitry.
>
> take a look at it closely - it's probably delimited - "VERSION" in which
> case it's fine, albeit inconvenient.
> Alan
>
>
>
>
>
> [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
>
>
>
>
>