You're welcome
>I see, thanks.
>
>>No it never worked in a select field list. It works in the WHERE and other clauses.
>>You've to assign the value to a local variable and use it in a query
>>
>>>I have a SQL statement where I use a class property to populate one of the resultant columns:
>>>
>>>select ....., this.objectname.property as ....
>>>
>>>it fails with
>>>Alias "objectname" is not found
>>>
>>>Seems to me it worked sometime in the past.
>>>Am I doing something wrong?
--sb--