Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql syntax?
Message
De
14/12/2006 16:36:33
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
14/12/2006 16:24:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01177802
Message ID:
01177810
Vues:
28
This message has been marked as the solution to the initial question of the thread.
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform