Re: Problem with Computed Column

Thanks JJ Reynolds,
I think u actually got my point there. Actually I am migrating my DB from ASA to Oracle.The SQL statement actually works perfectly well in ASA for some years.

The PD_TYPE column is indeed selected from dbo.party_dtl as a compute column. The resulting value is then being validated using the CASE section to produce the party_type column for the view. The intention of this view is to be displayed in Powerbuilder's datawindow.

However when i ran the SQL in ISQL Plus, the error occured at the CASE line indicating that PD_TYPE is an invalid identifier.

I somehow suspect that aliased columns might not be able to be referenced in functions such as CASE, NVL etc.. because i faced the same problem for my NVL functions in Oracle.

And thanks for the quotations thing, i will remember to remove it when my i start doing the real migration.

Please do advise
Kwan Received on Mon Feb 28 2005 - 02:34:23 CST