It depends on your architecture. If you are in a n-tier structure, AND all 
of you updates are done via the n-tier structure, you could use messaging 
to announce that a change is being made. 

If you are not already using an n-tier architecture, this isn't the reason 
to start as it would probably be a large undertaking.

> 
Hello

I could be wrong here, but i feel that you can write a DTS Package and
call it in a trigger. You might have to settle down to VBscript rather
than pure-VB. Also I  think it depends on what you want to do when the
refreshing process kicks in...

vasu

-----Original Message-----
From: Peter N. Kipe [mailto:pkipe@c...] 
Sent: Tuesday, March 18, 2003 3:44 PM
To: professional vb
Subject: [pro_vb] RE: Auto refresh in multi user apps


The only reasonable way to do it would be to put a timer in each client
form
that requires refreshing.  Each time the timer event fires, you could
re-read the data, compare it to the last data read, and refresh the
screen
if necessary.  The timer interval could be set according to the urgency
of
the data being perfectly up-to-date.

Pete

-----Original Message-----
From: Matt Morgan [mailto:mattmorgan@p...] 
Sent: Tuesday, March 18, 2003 3:47 PM
To: professional vb
Subject: [pro_vb] Auto refresh in multi user apps


Hey all -

In my app, I have several screens that are accessed by several users at 
the same time. I currently have a refresh button; I don't like it; but
it 
was the way to go at the time I put it in. Now my users are having to
hit 
refresh more and more; and I'd like to change the app so that it 
automatically refreshes when the DB (MS SQL) content changes.

Back in my Informix days, I would write a trigger that fired some 'C'
code 
to do this.

Can SQL triggers fire VB code? Or is there a better way to accomplish
this?

Any pointers to articles discussing this would be most appreciated.

Thanks
Matt

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to 


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to