Client and Server

[dcstech]

I have a program that write information to a database. I'm currently in the
process of writing another program that monitors the database and everytime a
new entry is made this program will update its datagrid. I guess you could
call this program a monitoring program. The problem is that I am not sure
how to do this. How can I raise an event from the server that tells me that
data has been written? Is there a way that I could shoot out something over
the network from the program that writes to the database to the program that
monitors it. The program that sends data to the database is a program that
records weights of trucks and railcars that go in and out of a fertilizer
plant. I need the monitoring program so that the supervisor can watch what
is going on.

Thanks for any help,
DCSTech

[jam96-BuffaloJoe]

Set a timer event at the client.

Every minute the query executes and the screen repopulates.

Allow the user to adjust the period of the timer refresh.

If the floor is hot and they want to have more frequency. set the timer
refresh lower.
If they know there is no action on the floor. set it higher, as to not use
overhead.

Joe

"dcstech" wrote:

I have a program that write information to a database. I'm currently in the
process of writing another program that monitors the database and everytime a
new entry is made this program will update its datagrid. I guess you could
call this program a monitoring program. The problem is that I am not sure
how to do this. How can I raise an event from the server that tells me that
data has been written? Is there a way that I could shoot out something over
the network from the program that writes to the database to the program that
monitors it. The program that sends data to the database is a program that
records weights of trucks and railcars that go in and out of a fertilizer
plant. I need the monitoring program so that the supervisor can watch what
is going on.

Thanks for any help,
DCSTech

[dcstech]

That will work. Thanks for the help.

"jam96-BuffaloJoe" wrote:

Set a timer event at the client.

Every minute the query executes and the screen repopulates.

Allow the user to adjust the period of the timer refresh.

If the floor is hot and they want to have more frequency. set the timer
refresh lower.
If they know there is no action on the floor. set it higher, as to not use
overhead.

Joe

"dcstech" wrote:

I have a program that write information to a database. I'm currently in the
process of writing another program that monitors the database and everytime a
new entry is made this program will update its datagrid. I guess you could
call this program a monitoring program. The problem is that I am not sure
how to do this. How can I raise an event from the server that tells me that
data has been written? Is there a way that I could shoot out something over
the network from the program that writes to the database to the program that
monitors it. The program that sends data to the database is a program that
records weights of trucks and railcars that go in and out of a fertilizer
plant. I need the monitoring program so that the supervisor can watch what
is going on.

Thanks for any help,
DCSTech