Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql syntax?
Message
From
14/12/2006 16:24:14
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Sql syntax?
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01177802
Message ID:
01177802
Views:
61
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
Map
View

Click here to load this message in the networking platform