column name alias problem

[2005 IR Help]

By: Augustin Boteanu - aboteanu

column name alias problem

2005-07-02 03:21

hi

 

i have a query like:

SELECT col_a AS first_column FROM the_table WHERE ...

 

What happens is that it tells me that there's no first_column. This happens when i use a real datasource (i use HSQLDB as the DB engine). If i use a empty datasource it works.

 

What's the problem and what can i do?