Hi Sergey,

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

My example was hurried ( i have not many time ),
but the problem is that VFP tries to optimize the SELECT.

However, this would have to resolve the problem.

CLEAR
CREATE CURSOR ccc ( ff I DEFAULT RECNO())
APPEND BLANK
APPEND BLANK
APPEND BLANK
APPEND BLANK
APPEND BLANK
APPEND BLANK
APPEND BLANK
GO TOP

SELECT RECNO('B'),RECNO('C'),* FROM ccc B,ccc C WHERE myCall(B.ff,C.ff)

USE
USE IN ccc

FUNCTION MYCALL(xx,yy)
RETURN RECNO('B')=RECNO('C')+1
ENDFUNC

I repeat, it is possible to control these commands ( RECNO(),... ) on a SELECT.

Fabio