Table Columns containing spaces

[2002 JI Open Discussion]

By: Mark Smith - ubbogus

Table Columns containing spaces

2003-06-12 17:14

Trying to use simple query report and I'm having problems when my database's table's column name contains whitespace.

If my table's column name contains whitespace is it possible to specify a valid "field" element which will map to the column in my ResultSet?

I believe this may be a bug but I wanted to know if anyone else has encountered/overcame this issue.

 

Any help would be greatly appreciated.

 

Thanks

Mark

 

 

 

 

By: Teodor Danciu - teodord

RE: Table Columns containing spaces

2003-06-15 13:29

 

Hi,

 

This is not a bug.

Is just that report fields, parameters, groups and variables cannot

have spaces or dots in their name.

 

To overcome this you can use aliases for the columns

returned by your SQL query:

 

SELECT MyTableColumn AS MyReportFieldName FROM MyTable

 

I hope this helps.

Teodor