I tried various combinations today in one of our views, and could not get it to work.

Are you able to get it to work? If so, what is the syntax you used?

Did not work:

* Syntax:
SELECT a.* ;
    ;
    FROM  ;
        (SELECT RECNO() as nRecno, * FROM addr) a ;
    ;
    WHERE  a.iaddrid = ( ?vp_iaddrid )

* Syntax:
SELECT a.* ;
    ;
    FROM ;
        (SELECT RECNO() as nRecno, * ;
             FROM addr ;
             WHERE  addr.iaddrid = ( ?vp_iaddrid ) ;
        ) a

I get "Not a character expression" on each attempt, and it asks me if I want to rebuild the view from the designer.

>>When I've needed RECNO() values, I've selected from the original table with something like:

SELECT RECNO() as nRecno, * FROM table INTO CURSOR c_table

>>
>>And then used that as the source for my subsequent query. Doesn't work well in views though, but can be a good workaround if it's manual code.
>
>I wonder if something like this would be working for a view. I have not used views in a long time but could be interesting.
>

SELECT Test.Inv_Recno, Inv.Invnum, Par.Parnum 
    FROM (SELECT RECNO() AS Inv_Recno, Invnum, Parnum 
        FROM Inv 
        WHERE Parnum== "000001") Test 
    JOIN Par ON Test.Parnum == Par.Parnum 
    JOIN Inv ON Inv.Invnum == Test.Invnum AND Inv.Parnum == Test.Parnum 
    INTO CURSOR cuResult