>Probably I wasn't clear. Recno() has alias parameter and it works reliably under VFP9.
>Cetin
>
>>There's no way to specify from which table RECNO() will come from and no guaranty that it'll be correct. In general, the functions that can accept an alias as parameters are not guaranteed to work correctly when select involves more than one table. More details at
http://www.berezniker.com/content/pages/visual-foxpro/queries-and-functions-which-accept-alias-parameter.
>>
>>>(at least under VFP9) recno() works perfectly well even with joins but it is deleted() that you shouldn't use with joined selects. Better do not use both for easy controlling of SQL. You didn't say what is your intention (or yuou did but I didn't get) so I don't have an idea what the SQL might look like. From the two SQLs I see I can't derive anything.
Sure, but the Alias is out of the SQL job, then it is a fixed value.
CLOSE TABLES ALL
CREATE CURSOR cetin ( a i)
APPEND BLANK
SKIP
SELECT * FROM Cetin WHERE RECNO('Cetin')= 1
SELECT * FROM Cetin X WHERE RECNO('X') = 1