Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Trigger causing Update error

    No can do. Not all order  types have a sub type so not all order types will be in the sub_type table. Therefore, I need the order_type foreign key to...

  • RE: Trigger causing Update error

    Thanks, Stephanie. I realized that when I tried implementing the trigger. I think the sql I'm going to go with is:

    SET NOCOUNT ON
  • RE: Trigger causing Update error

    Thank you - I think that should work. Here's my table structure, which hopefully explains why a simple foreign key isn't enough.

    Order_Master - contains all order fields including order_type_id (int)...

  • RE: Trigger causing Update error

    How would that help? Then I'd be assigning multiple values to a single variable.

Viewing 4 posts - 1 through 4 (of 4 total)