Mark,

Multitable selects can not use functions that accept alias arguments. The function is not evaluated like you think it should be.

>I tried manually assigning an alias with:
>
>select a.field1, a.recno("a") as RecNo1,... from table1 a, table2 b where ...
>
>That only returned the correct recno() for alias B, the recno returned for alias A was always 1. Interesting. I tried doing this with deleted() as well trying to resolve another problem with parameterized views not bringing over the deleted marker if set deleted is off. :(