General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2000 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only