Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql syntax?
Message
De
15/12/2006 11:09:34
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
15/12/2006 11:03:57
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:
01178010
Vues:
32
>Hi Mike,
>
>Thanks for all the info. I have this in my code...
>
>StartDate = ctod(THISFORM.txtStartDate.Value)
>EndDate = ctod(THISFORM.txtEndDate.Value)

I'd change that to lose the ctod(). In the init of the form.

THISFORM.txtStartDate.Value = {//}
THISFORM.txtEndDate.Value = {//}

To make them be dates from the start.

>
>* get the order rejects
>SELECT * FROM rejects ;
>WHERE daterecv BETWEEN StartDate AND EndDate ;
>ORDER BY vendorname, daterecv ;
>INTO CURSOR OrderRejects
>

and then use the m.startdate and m.enddate and it will be perfect! :)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform