Post reply

Check Constraint or Update Trigger?

  • March 16, 2011 at 5:59 pm

    #236421

    Hi,

    I have a database table for storing complaints records and I do not want users to be able to edit any records where the ComplaintResolvedOn Date is less than the date of the last Invoice Run.

    I would rather stay away from triggers so I'm just wondering if there is a way to action this with a check constraint?,

    Cheers!

  • March 16, 2011 at 6:40 pm

    #1299749

    Have you considered creating a VIEW which would contain only those records that could be edited?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • March 17, 2011 at 12:43 am

    #1299802

    you can create procedure and your business logic to edit the records.

    www.sqlsuperfast.com

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply