Fabio,

You cannot control those functions because you don't know know what aliases FoxPro will assign tables opened in SQL. Your second SELECT confirms that because RECNO('B') and RECNO('C') return 1 for all rows or other incorrect results depending on what tables are already open.

>Hi David,
>
>I want not to open a discussion, but,
>if onebody known like VFP implement SELECT-SQL then,
>your affirmations are not true
>
>

>CLEAR
>CREATE CURSOR ccc ( ff I DEFAULT RECNO())
>APPEND BLANK
>APPEND BLANK
>APPEND BLANK
>APPEND BLANK
>APPEND BLANK
>APPEND BLANK
>APPEND BLANK
>GO TOP
>
>* you write
>* 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.
>
>* Next SELECT return 7 Records !!! Then problems exists
>SELECT * FROM ccc WHERE RECNO("ccc")<=3
>
>* You write
>* If the SELECT-SQL involves two or more tables then these functions can not be used.
>
>* BUT i can control and use these functions within a SELECT with multimple tables
>
>SELECT RECNO('B'),RECNO('C'),* FROM ccc B,ccc C WHERE RECNO('B')=RECNO('C')
>
>USE
>USE IN ccc
>
>

>
>