CallBack for autoupdate table

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
maciejw

CallBack for autoupdate table

Post by maciejw » Sun 20 Mar 2005 10:23

Is possible to use any callbacks which allow implementation of autoupdate table and query using sdac and MsSQLServer 2003/2005 ?

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Mon 21 Mar 2005 09:24

What do you mean on "autoupdate"? On execution Post UPDATE statement is generated automatically.

maciejw@icpnet.pl

a little bit more of situation

Post by maciejw@icpnet.pl » 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

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Tue 22 Mar 2005 11:50

MS SQL Server doesn't provide such functionality. However we could advise to use
instead of separate protocol table of messages at the server.

Post Reply