General information
Category:
The Mere Mortals Framework
>Hi,
>
>I have a data entry app and need to do update procedures to the database every night.
>What is the cleanest way to do this? Do I need a program running in the background checking when it's midnight (sounds memory consuming to me) and then carry out the update? If so what's the best way to initiate the program?(as soon as I load the main form?)
Unless your app is already running 24/7, you'd probably be better served to do it outside the program. NT4 and Win2K both offer scheduling services to run programs at specified times. Our IT head set up several (one to kill leftover .TMP files, one to log out idle connections) and has had no problems with them. You'll have to set your update procedures to run straight up from a command prompt, but that's about it.
If you are running 24/7 already, then an application timer could fire off the procedure only when TIME() was greater than midnight, and make sure you only run it once...
Chris.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only