Home > Archive > Visual Basic > November 2004 > How to periodically update MYSQL database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to periodically update MYSQL database
|
|
| weetat 2004-11-29, 3:56 pm |
| Hi all ,
I am using VB 6 , MYSQL database and Window 2000 Pro.
My application need to do an update/insert in the MYSQL database
periodically.
Let me explain :
Our customer close shop time is 9:00 pm . The user will shutdown
the application ,then the updating and inserting will start to execute
and when is done , is will automatically shutdown the PC .
Anybody have any ideas or suggestions how to do it ?
Thanks.
| |
| tlviewer 2004-11-29, 3:56 pm |
|
"weetat" <test@wavex-tech.com> wrote in message =
news:OU$b8Wb1EHA.2716@TK2MSFTNGP14.phx.gbl...
> Hi all ,
>=20
> I am using VB 6 , MYSQL database and Window 2000 Pro.
>=20
> My application need to do an update/insert in the MYSQL database=20
> periodically.
> Let me explain :
>=20
> Our customer close shop time is 9:00 pm . The user will shutdown =
> the application ,then the updating and inserting will start to execute =
> and when is done , is will automatically shutdown the PC .
>=20
> Anybody have any ideas or suggestions how to do it ?
>=20
> Thanks.
Use the Windows Task Scheduler.
If you are storing your data gathered during the day in text
files, then this would work.
Starting at 9:00 PM or slightly before, launch your Update/Insert=20
Applet in the background. If the main App is not resident, then
start parsing the data and doing the SQL executes. Call shutdown.exe
when done.
I have no idea how you have stored the daily data. Obviously
you are storing it somehow, or you would be doing dynamic updates
and inserts throughout the day.
hth,
tlviewer (AIM:YahooIM)
|
|
|
|
|