If I remeber well (I have no VFP on that computer to check) we are alert not to use a functions such as RECNO() in SELECT-SQL commands.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.