It doesn't change the fact, that result returned by RECNO() function in such query isn't guarantied to be correct. You just got lucky. :)

>Hello Sergey
>
>"The Recno(), Reccount() and other alike function return incorrect result when used in multiple-table queries."
>
>in foxpro 2.6x (DOS) I have a multiple-table querie where the recno() just so happens to be returned from the table that I want and it works fine.
>
>same SQL as before then while browsing the queried table ;
>m = cursor.exp_1
>select receipt
>goto m
>
>it works great and has for 3 years
>
>
>>Hi Stephen,
>>
>>The Recno(), Reccount() and other alike function return incorrect result when used in multiple-table queries. Also, you cannot specify alias in those function even if they used in one table query because SELECT doesn't use your work areas; it performs the equivalent of USE ... AGAIN.
>>It's documented in 'SELECT - SQL Command' topic in help file. (look for RECNO).
>>
>>>Hello Everybody
>>>
>>>I have a SQL statement (The SQL statement works fine)
>>>
>>>IF pl_show = .F.
>>> l_str = "receipt.recon = CTOD(' / / ') "
>>>ELSE
>>> l_str = "receipt.recon <> CTOD(' / / ') "
>>>ENDIF
>>>frmWait.RELEASE()
>>>DEFINE WINDOW sql_win FROM 0,0 TO 1,1
>>>SET TALK WINDOW sql_win
>>>SET TALK ON
>>>SET SAFETY OFF
>>>SELECT *, (receipt.receipt_qty * receipt.receipt_cost), RECNO() ;
>>> FROM receipt, purchase_head ;
>>> WHERE purchase_head.order_numb = receipt.order_numb AND ;
>>> BETWEEN(receipt.receipt_date, pd_start, pd_end) AND ;
>>> purchase_head.cc_name = lc_name ;
>>> AND &l_str ;
>>> ORDER BY purchase_head.vendor_id, ;
>>> purchase_head.ven_invoice, ;
>>> receipt.pack_slip ;
>>> INTO TABLE (gcOld_Dir)+'recon.DBF'
>>>
>>>ok now how do be sure that I am getting the recno() from the receipt table?? I can't say receipt.recno()?? Can I, I get a error "Object receipt not found"
>>>
>>>
>>>Thanks for any help