For server-initiated synchronization, you can issue push requests by populating the PushRequest table directly, or making a change in the Dealer table. In the latter case, the Notifier begin_poll script detects the change in the Dealer table and populate the PushRequest table.
In either case, the PushRequest table supplies rows to the Notifier request_cursor script, which determines how remote devices receive messages.
From Interactive SQL, connect to the MLconsolidated.db database and type the following:
INSERT INTO PushRequest(mluser, subject, content) VALUES ('sis_user1', 'sync', 'not used'); COMMIT; |
Wait a few seconds for the synchronization to occur.
When populated, the PushRequest table supplies rows to the Notifier's request_cursor script. The request_cursor script determines what information is sent in the message, and which remote devices receive the information.
From Interactive SQL, type the following:
UPDATE Dealer SET RATING = 'B' WHERE name = 'Geo'; COMMIT; |
Wait a few seconds for the synchronization to occur.
In this case, the Notifier begin_poll script detects changes in the dealer table and populates the PushRequest table appropriately. As before, once the PushRequest table is populated, the Notifier request_cursor script determines what information is sent in the message, and which remote devices receive the information.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |