* 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 ) ; ) aI get "Not a character expression" on each attempt, and it asks me if I want to rebuild the view from the designer.
SELECT RECNO() as nRecno, * FROM table INTO CURSOR c_table>>
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