2 Replies Latest reply: Jul 30, 2013 6:28 AM by Nicolette RSS

    Automatic Row Processing (DML) - Return Key Into Item

    LT.ora

      Hello,

       

      This question is on Apex 4.2:

       

      I'm Displaying the [UNIKEY] column value after the record is inserted into the table using :

      page process > process row table_name > Source: Automatic Row Processing (DML) > Return Key Into Item > "Item Name"

      This works fine while inserting records, my question is why this does not respond on update / delete ?

       

       

      ϯ LT

        • 1. Re: Automatic Row Processing (DML) - Return Key Into Item
          LT.ora

          The page process returns [unikey] while inserting and null while updating; please help

          Guru's please put on some light here

          • 2. Re: Automatic Row Processing (DML) - Return Key Into Item
            Nicolette

            LT

             

            Check your branches.

            What might be happening is that on insert and update an other branch is followed.

            Where the branch of the insert either isn't clearing the cache of the page or is setting the item with it's own value.

            The branch on the update on the other hand is clearing the cache of the page and not setting the item.

             

            With a delete there is a clear cache process generate by the wizard. Check if this process is only running on the delete and not on the update.

            From memory the process is called something with reset.

             

            If the above doesn't help try to replicate the problem on apex.oracle.com and give access with a guest developer account so we can have a look.

             

            Nicolette