[fdo-users] RE: autocad 2011 commit changes problem
vasjalebar at gmail.com
Mon Mar 21 05:36:06 EDT 2011
We have managed to solve the problem. The trigger that was made by MS Sync
framework 2.1 was faulted. The code behind the trigger was:
UPDATE [side] SET [sync_row_is_tombstone] = 0, [local_update_peer_key] = 0,
[restore_timestamp] = NULL, [update_scope_local_id] = NULL,
[last_change_datetime] = GETDATE() FROM [inf_v_cev_ekc_5000_tracking] [side]
JOIN INSERTED AS [i] ON [side].[exp_id] = [i].[exp_id]
INSERT INTO [inf_v_cev_ekc_5000_tracking] ([i].[exp_id],
[local_update_peer_key], [sync_row_is_tombstone], [last_change_datetime],
[restore_timestamp]) SELECT [i].[exp_id], NULL, 0, @@DBTS+1, NULL, 0, 0,
GETDATE() , NULL FROM INSERTED AS [i] LEFT JOIN
[inf_v_cev_ekc_5000_tracking] [side] ON [side].[exp_id] = [i].[exp_id] WHERE
[side].[exp_id] IS NULL
We found that if we add SET NOCOUNT ON before and SET NOCOUNT OFF after the
code, the trigger works as it should. Our testing trigger was also faulted
becouse it contained only SELECT 1; statement. As we found, the SELECT
statement causes problem (even if surrounded by SET NOCOUNT statemtes).
Thank you for the help.
Vasja Lebar & Kaliopa team
View this message in context: http://osgeo-org.1803224.n2.nabble.com/autocad-2011-commit-changes-problem-tp6180452p6191588.html
Sent from the FDO Users mailing list archive at Nabble.com.
More information about the fdo-users