New and Old Values
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: New and Old Values

  1. #1
    Join Date
    Apr 2002
    Posts
    17
    I have the following questions.

    Where :New and :Old reads the beign inserted or updated values from?
    Can I gain access to this values from a procedure or function?

    Thanks

    Sezgin


    [Edited by sezgin on 04-08-2002 at 06:13 AM]

  2. #2
    Join Date
    Mar 2002
    Posts
    5

    Hi ,

    i don't hink you can use :new and ld inside procedures and functions .its used in triggers .

  3. #3
    Join Date
    Apr 2002
    Posts
    17
    Agreed!

    Situation is following.
    My procedure fires on "OnChange" event on one field.I want to give some values to fields in the same table there is the field that fires procedire.Because "OnChange" event doesn't commit the former changes, I cannot update them with standart Update.The following Update statement doesn't work, because empID doesn't exist in table.

    Update ZBG_Ins_Corrections
    set startday1=sday(1) --sday is collection variable
    where empID=AEmpID --aempID is parameter of my procedure

    That I want to know is whether exists the way to read the data that will be inserted into table like :New (or :Old) have this access?

    thanks

Posting Permissions

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


Click Here to Expand Forum to Full Width