locked
How does Sync FW deal with changing complex primary key? RRS feed

  • Question

  • Hello))

    I got entity (table) with three filelds (columns). And all of that three columns are part of complex primary key.

    So, if I will change a value in one columnes - can I expect that Sync FW will operate with changes correctly?

    Thanks.

    Thursday, June 23, 2011 6:17 AM

Answers

  • i believe so. and this will actually send two changes to the client, one for the delete and one for the new insert.

    • Marked as answer by Nina H Thursday, June 23, 2011 6:06 PM
    Thursday, June 23, 2011 8:24 AM

All replies

  • my guess is not. if you look at the Update trigger on the table you're synching, Sync Fx does not update the primary key(s) in the tracking table. try updating a key and see how it goes.
    Thursday, June 23, 2011 6:37 AM
  • Wow...

    It's a big problem.

    Is there any special rules for primary keys? 

    But I can workaround probably..

    If I always DELETE with record (with complex PK), and then INSERT new one?

    Is this a way? 

    Thursday, June 23, 2011 7:42 AM
  • i believe so. and this will actually send two changes to the client, one for the delete and one for the new insert.

    • Marked as answer by Nina H Thursday, June 23, 2011 6:06 PM
    Thursday, June 23, 2011 8:24 AM