Page 1 of 1
CallBack for autoupdate table
Posted: Sun 20 Mar 2005 10:23
by maciejw
Is possible to use any callbacks which allow implementation of autoupdate table and query using sdac and MsSQLServer 2003/2005 ?
Posted: Mon 21 Mar 2005 09:24
by Ikar
What do you mean on "autoupdate"? On execution Post UPDATE statement is generated automatically.
a little bit more of situation
Posted: Mon 21 Mar 2005 10:07
1. Imagine yourself a following situation.... The same database table is displayed on few computers connected to the same sql server.
2. One of them make any kind of record modification (delete, edit or append).
3. Goal of problem is to update data displaying on others host immediately after its modified by one of them.
I have this problem resolved using additional communication basic on tcp/ip messages, but question is: Is possible to prepare any form of "WAKE UP" functionality, that automaticaly informs application: "YOUR DATA TABLE IS CHANGED - PLEASE UPDATE" immediately after change was made by one of other hosts
Posted: Tue 22 Mar 2005 11:50
by Ikar
MS SQL Server doesn't provide such functionality. However we could advise to use
instead of separate protocol table of messages at the server.