| Subject | Integration questions (escaped alias, spaces, etc.) |
|---|---|
| Author | ramona.grissom |
| Post date | 2013-04-17T21:29:44Z |
We have a client that is trying to integrate software. Their questions are:
Do you know whether escaped aliases are supported in Firebird?
In MSSQL for example you can SELECT column AS [column name]. The "column name" can contain spaces and be named a reserved word because it's escaped with the square brackets.
We know this works in FB 2.5,
select DESC from
(select c.company_name || c.street_address1 as desc from cusmain c)
order by DESC
But not sure about
SELECT CustomerName AS "Customer Name"
FROM Customers
Thank you in advance for your help.
Do you know whether escaped aliases are supported in Firebird?
In MSSQL for example you can SELECT column AS [column name]. The "column name" can contain spaces and be named a reserved word because it's escaped with the square brackets.
We know this works in FB 2.5,
select DESC from
(select c.company_name || c.street_address1 as desc from cusmain c)
order by DESC
But not sure about
SELECT CustomerName AS "Customer Name"
FROM Customers
Thank you in advance for your help.