Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Synchronization Model Deploy Script Trigger for Computed Columns
10 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