Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to fix IG Delete Bug - "Delete Row" always deletes last row

jacklessNov 16 2021

I have an IG and when using the automatically generated "Delete" function from the apex_rowaction column it doesn't delete the selected row but instead always deletes the last row from the table.
Thanks in advance
Jack

Comments

Hamza Al-abbasi Nov 16 2021

Hello User,
Can you reproduce this on apex.oracle.com ?

InoL Nov 16 2021

This isn't normal for an IG, so you probably have some customisation in the IG. You need to give more information about your situation, like:
What is your APEX version?
Did you create the page with the wizard?
Did you create any custom code (either JavaScript or PL/SQL)?
Is the IG based on a table or a view? In case of a view: are there instead of triggers on this view?
Etc.

fac586 Nov 16 2021

I have an IG and when using the automatically generated "Delete" function from the apex_rowaction column it doesn't delete the selected row but instead always deletes the last row from the table.

This isn't normal for an IG
No. but it is a long standing and—as far as I can tell—so far unexplained problem.

Tom R Sep 27 2023

Dont know if this would help but just had the same problem. I included ROWID on the row and didn't show on IG but this seemed to fix the problem. The child table had a composite key.

Hope this helps.

Tom

1 - 4

Post Details

Added on Nov 16 2021
4 comments
612 views