Re: create trigger statement

[Peter Brawley]

So it's homemade merge-synchronisation. A shadow row (2 1 I) indicates that a row referring to device 1 needs to be inserted in main. A row in the user's local table? If so, what's the point of the shadow table echo? Then, "the delete trigger change the action from 'I' to 'D'". Why? And "device 1 look on the server for the changes, he will see that A_id 2 is deleted". Is 'device 1' a user of the application? "He'll try to delete the record in his copy." A trigger can fire only on updates inserts & deletes. "BUT the record never has been inserted in the copy of device 1" You seem to have found holes in your merge synchronisation logic, which is famously difficult to get right. Have you flowcharted this, and worked out all the use case logic? Seems to me you should do that before writing any code at all.

PB



Edited 1 time(s). Last edit at 06/13/2006 11:55AM by Peter Brawley.