Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Divide table monthwise
Message
 
To
21/02/2005 13:15:43
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00988879
Message ID:
00989010
Views:
49
>>Dear Sir,
>>
>>When I run your codes it shows following error message
>>
>>Invalid path or file name
>>
>>Please help again
>
FOR p_count = 1 TO 12
sMonth= LTRIM(STR(p_count))
SELECT * FROM weights WHERE MONTH(date1) = &sMonth INTO TABLE "d:\ahsan"+m.sMonth
NEXT
CLOSE ALL

May be quickly is:
>FOR p_count = 1 TO 12
>    sMonth= "d:\ahsan"+LTRIM(STR(p_count))
>    SELECT * FROM weights WHERE MONTH(date1) = p_count INTO TABLE (m.smonth)
>NEXT
>CLOSE ALL
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform