Fabio,

In any SELECT-SQL that involves only a single table the native functions that take a table alias as an argument can all be used without any problems. Provided that you are not trying to use an alias that differs from the table involved in the SELECT-SQL.

If the SELECT-SQL involves two or more tables then these functions can not be used.

>On SELECT-SQL VFP not resolve context alias on DELETED(alias),RECNO(alias),RECCOUNT(alias)... functions.
>Then is hard to use they.
>
>For simple one table ( without grouping ) you can use RECNO(),
>then ( the select code is orrible, but do the operation ):
>

>SELECT * FROM myDBF X WHERE recno() = recno('myDBF')
>

>recno() && this refer to X
>recno('myDBF') && this refer to myDBF workarea and is fixed during the select