Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Synchronization Model Deploy Script Trigger for Computed Columns
9 views
Skip to first unread message
Jason
Sep 22, 2011, 10:53:07 AM9/22/11
to
Mobilink 12.0.1.346
Synchrinizing to Ultralite 12.0.1.346
Consolidate Database: Mircrosoft Sql Server 2008 R2
I have a table in the consolidated database with a computed column. This column is excluded from the mobilink sync. However when I deploy the scripts for the Sync Model, the Update Trigger for that table checks if the computed column was updated: ie "IF updated(mycomputedcolumn) OR ....". This is not allowed and kills the script from running.
I work around it by just removing the computed columns from the update trigger script, but it does appear to be bug.
Also, if I exclude a column from synchronizing; why does mobilink still include that column in the "update" trigger. For purposes of synchronizing, the row was not "last_updated" if a non-sync'd column was update.
Thanks!
Synchrinizing to Ultralite 12.0.1.346
Consolidate Database: Mircrosoft Sql Server 2008 R2
I have a table in the consolidated database with a computed column. This column is excluded from the mobilink sync. However when I deploy the scripts for the Sync Model, the Update Trigger for that table checks if the computed column was updated: ie "IF updated(mycomputedcolumn) OR ....". This is not allowed and kills the script from running.
I work around it by just removing the computed columns from the update trigger script, but it does appear to be bug.
Also, if I exclude a column from synchronizing; why does mobilink still include that column in the "update" trigger. For purposes of synchronizing, the row was not "last_updated" if a non-sync'd column was update.
Thanks!
0 new messages