[fdo-users] RE: autocad 2011 commit changes problem

[vasjalebar]

Hi,

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],
[create_scope_local_id], [local_create_peer_key],
[local_create_peer_timestamp], [update_scope_local_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.

Base regards,
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.