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
--sb--