>Hi,
>We need to include a "caller id" popup in our application. When a call is answered, a record is added to a foxpro table in New Jersey. Our applications run from servers in New York. We don't want to have a timer that queries the foxpro table remotely. Nor do we want to write the record to the server in New york and have the timer query locally.
>The form needs to popup as quickly as possible so any timer would need to fire every 1/2 second and we have many apps running.
>
>My thinking is to raise an event in our appplication when a record is added to the foxpro table in New Jersey. No timer would be involved.
>Could I use web services for this?
>Any ideas would be gretly appreciated.
>Thanks, Mark.
How these two servers are connected? One idea would be to use an insert trigger (if your tables are part of the database) to, say, create some file or message, which would initiate some action (a form) in your other site.
If it's not broken, fix it until it is.
My Blog