detect changes in database

[Guest]

I have an application that is used by multiple people. They all see the same
table contents from a sql-db. If a user adds/changes or removes a record the
other users must refresh there dataset manually to see the changes. How can I
make my application aware of db-changes automaticly so that the users don't
have to manually refresh the screen.

Thanks,
Frank

 

[necroph]

The most easiest way should be a timer. Use the OnTick event to read
from the database. Now you can just refrech automaticaly your form by
calling the function or sub that you use, to update manually.

 

[m.posseth]

Hello Frank

if you use SQL 2000 or 2005 you can use notfication services to acomplish
this ( great new feature ) for sql 2000 this is a ( free ) adon you need
to install to get this working SQL 2005 has this functionality standard
onboard ... the database performs then a callback to your app when the
subscribed dataset changes

search on MSDN for notification services


regards

Michel Posseth [MCP]

 

[Guest]

Thank you very much. This is what I was looking for.

Cheers,
Frank

Hello Frank

if you use SQL 2000 or 2005 you can use notfication services to acomplish
this ( great new feature ) for sql 2000 this is a ( free ) adon you need
to install to get this working SQL 2005 has this functionality standard
onboard ... the database performs then a callback to your app when the
subscribed dataset changes

search on MSDN for notification services


regards

Michel Posseth [MCP]

I have an application that is used by multiple people. They all see the
same
table contents from a sql-db. If a user adds/changes or removes a record
the
other users must refresh there dataset manually to see the changes. How
can I
make my application aware of db-changes automaticly so that the users
don't
have to manually refresh the screen.

Thanks,
Frank