SQL with fields that have spaces in the title

[JoaoPinto]

Hi

Can anyone help.

I have a database table with fields like this
RouterCallKey, DateTime, Time in Q, TalkTime, After Call Work

How do I refer to 'Time in Q' and 'After Call Work' within WebFOCUS SQL?

In SQL Server I would use [Time in Q] and [After Call Work] this way does not work in Webfocus
i.e

SQL
SELECT [Time in Q], [After Call Work]
FROM T_CS_Report;
TABLE ON TABLE HOLD AS HOLDER
END

 

[kaeserea]

Hi JoaoPinto,

My guess is to try either of these two things:
[tt]
SQL
SELECT 'Time in Q', 'After Call Work'
FROM T_CS_Report;
TABLE ON TABLE HOLD AS HOLDER
END
[/tt]

or
[tt]
SQL
SELECT TIME IN Q, AFTER CALL WORK
FROM T_CS_Report;
TABLE ON TABLE HOLD AS HOLDER
END
[/tt]

I haven't tried it myself. But it's what I'd expect from WebFocus. Try it and let me know if it works.

Eva