>Hi friends
>i've quick question, in our app users can create a sql report and export to excel.we've request from client asking to schedule a report to run once every week and export to excel. at the moment ,we dont have any plans to include such a option (ie. scheduling) but just wondering whether it is possible do this any other way like thru some batch file etc.,
>
>Thanks for advise.
Of course, you could program something in Visual FoxPro - you would do this with a Timer object, that regularly checks whether it is time to do something, or that is set up, from the beginning, to fire once at the desired time.
But this would require some programming, and a program that is running all the time.
All in all, I consider the option pointed out by Sergey as superior, and that is what I use myself.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)