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.

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



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 checked the docs for FB2.0, and no mention of VERSION being a reserved
word, but from what I see here it appears so.



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]