SQL Remote User's Guide
Principles of SQL Remote Design
Replication errors and conflicts
Replication conflicts are different from errors. Properly handled, conflicts are not a problem in SQL Remote.
Conflicts A user updates a row. A second user updates the same row at another site. The second user's operation succeeds, and SQL Remote allows a trigger to be fired (Adaptive Server Anywhere) or a procedure to be called (Adaptive Server Enterprise) to resolve these conflicts in a way that makes sense for the data being changed.
Conflicts will occur in many installations. SQL Remote allows appropriate resolution of conflicts as part of the regular operation of a SQL Remote setup, using triggers and procedures.
For information about how SQL Remote handles conflicts as they occur, see the following chapters.