Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Do while problem
Message
 
To
03/06/2005 01:01:38
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows '98
Network:
Windows 98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01019676
Message ID:
01019692
Views:
17
SELECT DISTINCT Date, Vou_No, Vou_Type, D1;
       FROM Vou_Sum;
       GROUP BY Date, Vou_No, Vou_Type, D1;
       INTO CURSOR cVouSum

SELECT cVouSum
INDEX ON Vou_Type+STR(Vou_No)+DTOS(Date) TAG cVouSum

SELECT Vou_Sum
SET RELATION TO Vou_Type+STR(Vou_No)+DTOS(Date) INTO cVouSum

REPLACE ALL D1 WITH  cVouSum.D1

USE IN cVouSum
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform