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