in 2.6x yes but no dice in 6.0


>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