SQL89 field alias

[Denillenium]

Hello to all,
I'm using a SQL89 ODBC driver and i want to create a alias for my fields name. Like : SELECT job.job AS 'Test' FROM job

But, it seems that SQL89 doesnt take the 'AS' for my alias. Does anyone know how to create an alias in SQL89? Is it possible?

Thanks

 

[paulr]

SQL89 does not support the use of Aliases.

Hello to all,
I'm using a SQL89 ODBC driver and i want to create a alias for my fields name. Like : SELECT job.job AS 'Test' FROM job

But, it seems that SQL89 doesnt take the 'AS' for my alias. Does anyone know how to create an alias in SQL89? Is it possible?

Thanks

 

[fleites]

Hi.

I want to use the SELECT statement in progress in this way:

SELECT COUNT(*) FROM ctemp

Where ctemp it’s a variable CHARACTER which contains, for example:

ctemp = "empleado WHERE empleado.rfc = "fesv8202068w5""

That means that I want my statement like this:

SELECT COUNT(*) FROM empleado WHERE empleado.rfc = "fesv8202068w5"

How could I do it?? I already try use an .i file sending one parameter (CHARACTER ONE (ctemp)) to complete the instruction:

SELECT COUNT(*) FROM

So, the instruction became:

SELECT COUNT(*) FROM {1}

But doesn’t work either, I don’t know what to do. The version of Progress that im using is 9.1D.

If someone can help me I’m gonna be very glad.

Thanks.