DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Procedure Help

  1. #1
    Join Date
    Apr 2002

    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?


  2. #2
    Join Date
    Aug 2000
    One useful way to do this is to create input fields for the columns you wish to populate, but don't display them on your form. When the onchange event fires, have it set these "hidden" fields. Then if the user saves, this data is saved also, and if the user rolls back, these changes are rolled back too.
    Oracle DBA and Developer

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