Subject | problem with column names starting with number character |
---|---|
Author | Daniel |
Post date | 2010-10-08T19:05:46Z |
Hi,
I'm facing a problem creating a SQL to retrieve data from a table.
the table has two columns starting with number in the name the two columns are: 6mes, 12mes.
Then when I try to execute the folowwing SQL:
SELECT tb.6mes,tb.12mes from biz_table tb;
it gives me the following error:
GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 10
.6
How can I build this SQL, in order to get these data?
I'm using hibernate with jaybird JDBC driver. But even when I try to execute through a SQL executor problem it gives me same problem.
Setup:
Firebird 2.1 (x64)
Jaybird 2.1.6
Windows S.O.
Do you know how to deal with it?
Thanks,
I'm facing a problem creating a SQL to retrieve data from a table.
the table has two columns starting with number in the name the two columns are: 6mes, 12mes.
Then when I try to execute the folowwing SQL:
SELECT tb.6mes,tb.12mes from biz_table tb;
it gives me the following error:
GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 10
.6
How can I build this SQL, in order to get these data?
I'm using hibernate with jaybird JDBC driver. But even when I try to execute through a SQL executor problem it gives me same problem.
Setup:
Firebird 2.1 (x64)
Jaybird 2.1.6
Windows S.O.
Do you know how to deal with it?
Thanks,