Why does this query fail?

[Richard Freggi]

In query editor:

Code: [Select]

SELECT Version from t_object
Microsoft OLE DB Provider etc. etc.
Column unknown VERSION

Sparx 13.10, on Firebird DB on my own PC (integrity check and index update all OK)

[Richard Freggi]

DAAAAMN
Version is a reserved word, this works

Code: [Select]

SELECT [Version] from t_object
Can't believe I spent 1/2 hour on this.....

[Geert Bellekens]

DAAAAMN
Version is a reserved word, this works

Code: [Select]

SELECT [Version] from t_object
Can't believe I spent 1/2 hour on this.....

I was just gonna reply with the same answer

Geert

[Richard Freggi]

Beat you to it this one time Geert... one time only