Post reply

Problems with Trigger

  • February 21, 2005 at 3:02 am

    #66570

    Hi,

    I have a procedure that opens a cursor for rows in a table say tableA and updates each record one by one, it sets a single column's value to itself. The tableA has an AFTER UPDATE trigger that performs a perticular task. I've noticed that it is often missed, i.e. not called. Like I have inserted some test values into a temporary table before the update statement in the procedure, and inside the trigger code, and after the update statement. can somebudy suggest me anything

    take care

    Rehan Ahmad

    - Rattu

  • February 21, 2005 at 3:25 am

    #543289

    select A.TaskTemplateId from OSL_TskTmpls_R B

    what does B mean in this SQL.

     

    Prasad Bhogadi
    www.inforaise.com

  • February 21, 2005 at 4:01 am

    #543293

    sorry my fault ... i removed a table from the select list for easy understanding ... consider A=B .

    - Rattu

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

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