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