>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 > >>