>>Is there any way to have SELECT selects RECNO()? TO make it harder I have more then one table in this SELECT statement.
>>TIA Mark
>
>You could try:
>
>Select ..., Recno("Table1") as RecNo1, Recno("Table2") as RecNo2 ...
>
>Something like:
>
>Select table1.*, recno("Table1") as RecNo1, ...
>
>would most likely not work. You have to explicitly list all the fields you want.
Nope, putting RECNO('alias') will never work during the SELECT. Once the SELECT code kicks in, there is no guarantee that FP will use your alias internally. Edward's suggestion to do it in two passes will work.