Results 1 to 2 of 2

Thread: About Trigger

  1. #1
    Join Date
    Dec 2009
    Location
    Chennai, India
    Posts
    7

    Unanswered: About Trigger

    Hi All

    i have 3 fields
    1. starting date
    2. planned days
    3. ending date
    i just want enter the starting date and planned days then calculate ending date = starting date + planned days
    update the ending date when i insert or update the starting date and planned days.
    i wrote one trigger but i cant perform this operation
    i got some error like ERROR: stack depth limit exceeded
    how can i rectify this problem ? or
    is any other option available please tell me

  2. #2
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    how can i rectify this problem ? or
    is any other option available please tell me
    The problem is that you are storing redundant information. Given any two of the data points you can always calculate the third. Pick which two make the most sense to store and calculate the third.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •