CODEWITHSUNDEEP
oracle-databaseoracle-apex
yaya30001996
yaya30001996

Reputation: 39

Oracle Apex 19.1 (how to add, edit, delete data through a form)

I'm new to oracle apex so this might be simple.

I have an application that i'm currently building. I have an 'employee' table in the SQL workshop. When i attempt to create a form linked to the table there is no option to edit, delete, or add entries into the table ,once the form is completed?

This is essentially what i need help with. I need to be able to manipulate the 'employee' table through the form created rather than through anything within the sql workshop. Just for context i am not the workspace admin, however i am a contributor.

I would appreciate if anyone could provide me with a quick step by step guide into creating this desired form accurately.

Upvotes: 0

Views: 1974

Answers (1)

Littlefoot
Littlefoot

Reputation: 142733

I'd suggest you to create (using the Wizard, of course) Report with Form on Table. It will create

  • interactive report you'd use to view data stored in that table
  • form which will be used to insert/update/delete data
    • the same form will be called when you push
      • the "Create" button in order to create new rows, or
      • icon at the beginning of every line in the report in order to update/delete rows

This combination (report + form) works nicely for ages, so ... try it. I hope you'll find it useful.

Upvotes: 2

Related Questions