>I am getting "Operator/operand type mismatch" on line 21 (INTO CURSOR OrderRejects) and "Alias 'ORDERREJECTS' is not found" on line 26 (SELECT OrderRejects).
>
>* Free Table - rejects.dbf
>SELECT * FROM rejects ;
>WHERE daterecv BETWEEN StartDate and EndDate ;
>ORDER BY vendorname, daterecv ;
>INTO CURSOR OrderRejects
>
>* create a VendorPerfomance table to hold the report values
>CREATE CURSOR VendorPerf(VendorID c(5), VenName c(25), NumReceipts I, OnTime I)
>
>SELECT OrderRejects
>GOTO TOP
>
>Please advice.
>
>Thanks,
>Sam
I am not sure VFP6 has BETWEEN in SQL Select. Try:
WHERE BETWEEN(daterecv, StartDate, EndDate) ;
instead
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.