[Andro-general] Crazy Idea

[Kenneth D. <ke...@se...>]

Well, there is one way to simulate the replacement of values if the 
trigger will not allow it.

You can create a view for each table, disable table access and require 
access through the view.  The view then assembles the changes and writes 
to the base table.

Kind of a pain, to say the least, at many levels, and I'm still hoping I 
just haven't found the right Google term for getting MS SQL Server to 
allow replacement values in a trigger.

Or, this could be done only on SQL Server. 

I don't think I realized how powerful postgres was until I tried doing 
things on other platforms.

-- 
Kenneth Downs
Secure Data Software
ke...@se...  www.andromeda-project.org www.secdat.com
Office: 631-689-7200
Cell: 631-379-0010
Fax: 631-689-0527