Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql syntax?
Message
From
15/12/2006 11:09:34
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
15/12/2006 11:03:57
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01177802
Message ID:
01178010
Views:
31
>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! :)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform