Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by PaulLai
-
Using Count() in a select statement?
Assume saleshead.dbf contains the sales of one week only. You should have a field which stores the sales total of a transaction, say SaleTotal. Try this: select cdow(dSaleStamp) as weekday, sum(SaleTotal) as DayTotal; from saleshead; group by weekday The result would look like this Weekday...- PaulLai
- Post #5
- Forum: Microsoft: FoxPro
-
anybody knows how to send email thr
Mike You are right. Thanks for the remind! Paul- PaulLai
- Post #5
- Forum: Microsoft: FoxPro
-
anybody knows how to send email thr
To send email from VFP, try "Blat". It is free. I have done it in one of my test program. Regards, Paul- PaulLai
- Post #3
- Forum: Microsoft: FoxPro
-
need help converting VB to VFP
I think the % sign stands for integer. In VFP, simply declare: Public Total Assign 103 to Total: Total = 103 Paul Lai- PaulLai
- Post #2
- Forum: Microsoft: FoxPro
