User Profile

Collapse

Profile Sidebar

Collapse
BJerolimic
BJerolimic
Last Activity: Jun 28 '07, 09:18 PM
Joined: Jun 27 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • BJerolimic
    replied to Trigger help
    in Oracle
    ah-ha... you are right, it returns 20 rows!

    how do I get it to only return values from the new records in exercise & tax that are being created by the front-end?

    can I do something like:

    and e.exer_num = :new.exer_num ???
    See more | Go to post

      Leave a comment:

    • BJerolimic
      started a topic Trigger help
      in Oracle

      Trigger help

      Trying to build a trigger that will update fed_paid only when tax.taxrec_typ = 13 (which is equivalent of exercise.exer_t ype = 4). Please note that data comes from exercise, grant & tax table

      Select statement returns correct info, but user gets error when trying to put in new record via front-end


      And FYI the Front-end is s C++ app called EOWin

      Error message is: ORA=01422: exact fetch returns...
      See more | Go to post
      No activity results to display
      Show More
      Working...