Re: How do I do this (SQL & Triggers)??

> I need to have an insert trigger which checks to see if a particular > field is NULL. If this field is NULL, I need to have it made equal > to the value of another field from the same row. Having putzed > around with this for a while using a combination of triggers and > stored procedures, I am beginning to believe that it is not possible. > Tell me it ain't so. Well, I could tell you it ain't so, but it is. A trigger can't faff with a record being inserted (to the best of my knowledge). Sorry. -- Ciao, Billy +------------------------------------------------------------------------------+ | Billy Wheeler Junior Programmer / Director The West Solutions Group | +------------------------------------------------------------------------------+ | Oracle isn't the answer. Oracle is the question, and the answer is "no". | +------------------------------------------------------------------------------+