I am trying to create an instead of trigger that builds a unique key based on other items inserted into the table. My trigger works fine if I put any bogus/temp value into the unique key field, but gives a: 'Column can not be null.' error if I try to enter the data without anything in the field.
Is there a way around this, or do I always need to insert a temp value to satisfy the key field entry?
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.