Oracle APEX: Update Table based on changes in an Interactive Grid

0
votes


currently i am facing a problem on how to update a single row in an interactive grid. am trying to update the table (Interactive Grid) based on the changes the user has made.
I followed the guide from APEX 5.1.
Unfortunately the rowid function didn't work.

My code:

update poc_sofortmassnahme  
    set BESCHREIBUNG_SOFORT  = :BESCHREIBUNG_SOFORT,  
        BEARBEITER_SOFORT = :BEARBEITER_SOFORT,
        ZIELDATUM_SOFORT = :ZIELDATUM_SOFORT,
        WIRKSAMKEIT = :WIRKSAMKEIT
  where rowid  = :ROWID; // doesn't update the row.

Any help is appreciated.

Sample Code from Oracle APEX 5.1

1
sqloracleoracle-apex

1 Answers

0
votes

Interactive Grid can be editable (as tabular forms used to be in previous versions), so I'd suggest you to use that functionality instead of reinventing the wheel. Because, it seems that you're trying to do your own row processing while there's no need to do that.