Clearing at midnight

[EscapeUK]

I want to recent the some values to 0 in my table. However this has to be done just after midnight when no one is about.

Any advice [sig][/sig]

 

[EscapeUK]

sorry that sould have said....

I want to reset the some values to 0 in my table. However this has to be done just after midnight when no one is about.

Any advice [sig][/sig]

 

[foxdev]

If you are running NT/2K, you could schedule a job to run at 12:01am, and this job would invoke a FoxPro program that resets the data values. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[jnicho02]

Rob, why do it in FoxPro? You can write a stored procedure and then have a scheduled task that runs a line of SQL to call it. [sig]<p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/jnicho02/>my

home</a><br> [/sig]

 

[EscapeUK]

sorry I am we bit think,

how do I schedulr a task and how should the line of text be constructed [sig][/sig]