Hi,
Now we are trying to synchronize two databases through coding. For that we have created Flags in each table. If we insert a new value to one table, the flag of that table will be NULL. and once the synchronization starts and the same inserted value gets updated into the next database then the flag will automatically Turn to True. While updating a particular row. The flag will turn to FALSE.
But now we want to update the flag through a trigger. How can we update the Flag of a row, if any of the row column gets updated. How can we use a trigger to update the same
Thanking you
Sandeep
Now we are trying to synchronize two databases through coding. For that we have created Flags in each table. If we insert a new value to one table, the flag of that table will be NULL. and once the synchronization starts and the same inserted value gets updated into the next database then the flag will automatically Turn to True. While updating a particular row. The flag will turn to FALSE.
But now we want to update the flag through a trigger. How can we update the Flag of a row, if any of the row column gets updated. How can we use a trigger to update the same
Thanking you
Sandeep
Comment