1

Topic: How to use a field "CORR"

Good afternoon!
There is a heap of tables with field CORR. To version FB 2.5.7 all worked.
Started to try FB 3.0.2 and learned that this word is reserved now.
How it is possible to work with it without renaming this field?
How to write idle time  with such field?
select corr from od_table does not work.

2

Re: How to use a field "CORR"

RTFM delimited identifiers.

3

Re: How to use a field "CORR"

alex342;

SELECT "CORR" FROM...

?

4

Re: How to use a field "CORR"

DarkMaster;
Does not transit...
select "corr" from od_face
Column does not belong to referenced table.
Dynamic SQL Error.
SQL error code =-206.
Column unknown.
corr.
At line 1, column 8.

5

Re: How to use a field "CORR"

DarkMaster;
And capital letters "CORR" transited!!!
Thanks.