views:

28

answers:

0

Hello:

I have a table with an after update trigger in SQL 2005. If I update directly with SQL QUERY the trigger runs ok.

This table is connected using a dataset and tableadapter to a DXDBGrid (Dev. Express).

If the user updates the grid, the underlying data is updated, but the trigger is not launched.

I've a PK on table, auto-generated UPDATE command in the table adapter, etc. Everything works fine except the trigger not launching...

Why, oh why!?

Thanks in advance.

Franklin.

EDIT: The trigger code:

ALTER TRIGGER [dbo].[trgUpdateZonasAsignadas] ON [dbo].[ZonasAsignadas] AFTER UPDATE AS BEGIN

IF NOT(UPDATE(ActualizadoPDA))
BEGIN
   UPDATE ZonasAsignadas SET ActualizadoPDA=0
      WHERE IdUsuarioZona IN (SELECT Inserted.IdUsuarioZona FROM Inserted)   
END

END