Re: How to update all users when one makes a change

Doesn't Sql Server 2005 have an event model that will notify subscribers of
changes to data?

-
THESE are the times that try men's souls. The summer soldier and the
sunshine patriot will, in this crisis, shrink from the service of their
country; but he that stands by it now, deserves the love and thanks of man
and woman. Tyranny, like hell, is not easily conquered; yet we have this
consolation with us, that the harder the conflict, the more glorious the
triumph.


> -----Original Message-----
> From: Discussion forum for developers using Windows Forms to build apps
> and controls [mailto:[email protected]] On Behalf Of
> Greg Robinson
> Sent: Friday, March 16, 2007 13:46
> To: [email protected]
> Subject: Re: [DOTNET-WINFORMS] How to update all users when one makes a
> change
>
> Polling of some kind.  You could have a background thread on your UI
> that
> checks for changes top open record every 30 seconds or so.  We do
> something
> similar with one of our lookup tables that gets cached. We have a 60
> second
> 'poller' that checks for changes, if found the cache is updated.
>
>
>
>
> Greg Robinson
> Custom Data Systems, Inc.
> www.cds-am.net
>
> -----Original Message-----
> From: Discussion forum for developers using Windows Forms to build apps
> and controls [mailto:[email protected]]On Behalf Of
> Steve Abaffy
> Sent: Friday, March 16, 2007 2:37 PM
> To: [email protected]
> Subject: [DOTNET-WINFORMS] How to update all users when one makes a
> change
>
>
> Hello,
>
>         I am sure that there is an easy answer to this, just not sure
> how it
> is done using best practice. The problem I have an invoicing system and
> when
> someone adds a new item to someone's order or makes a payment against
> an
> invoice, how do you push that information to all the users who
> currently
> have that record open? Or is it better to not let others open the
> record
> while it is open by someone else? Just looking for a bit of guidance on
> this.
>
> Thanks