A trigger on a view would allow to monitor multiple tables without the need to create a trigger for each table.

Don't know if it is possible but if a trigger could be created on a stored procedure which do different tasks like insert, update and delete that would be an even better solution.

Mike,

<< A trigger on a view would allow to monitor multiple tables without the need to create a trigger for each table. >>

I've actually got "INSTEAD OF" triggers partially-implemented for views in EDB, but I need to finish it.  I'll looking at adding other trigger types at the same time.  I don't think there's any issues with allowing them all on views.

Procedures/functions, on the other hand, can't really support triggers because they aren't really tables in any sense.

Tim Young
Elevate Software
www.elevatesoft.com

Thanks Tim.

Supported triggers on views would be highly appreciated