Message
From
14/12/2006 16:36:33
To
14/12/2006 16:24:14
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01177802
Message ID:
01177810
Views:
29
>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
Also check that StartDate and EndDate really contain dates, not datelike strings nor numbers, in case you still get that error after using between() as a function.
back to same old
the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
>
>* 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
Also check that StartDate and EndDate really contain dates, not datelike strings nor numbers, in case you still get that error after using between() as a function.
back to same old
the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.