Sign Up

Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then this place is just for you and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About
Home/Questions/Q 5587
In Process
Wayne
Wayne

Wayne

  • 4 Questions
  • 5 Answers
  • 0 Best Answers
  • 47 Points
View Profile
  • 1
WayneContributor
Asked: February 24, 20212021-02-24T18:18:01+05:30 2021-02-24T18:18:01+05:30

Oracle Apex 20.1 Insert, Update, Delete values from one Interactive Grid to another Interactive Grid

  • 1

Hi,

on one of my page I a have a Interactive Grid which gets created by selecting a project from a Popup LOV. Based on the selection different data gets loaded in the IG. In this IG I have pre-filled two columns project_name and project_result.

My goal is to when loading the data in the IG to save the changes into a second table (i.e. Interactive Grid). So that the first IG doesn't get changed with the pre-filled columns or overwritten, and the data with the rows gets loaded in the second table for further processing.

I also have the problem that the pre-filled data from the IG doesn't get saved into the second table.

Any ideas on how to achive this goal?

I already tried it with removing the Interactive Grid Row Processing and custom PL/SQL but the data doesn't get saved or itt says no ROWID found.

Thank you.

Kind regards.

 

apex
  • 2
  • 104
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
Answer

    2 Answers

    1. Bill

      Bill

      • 2 Questions
      • 2 Answers
      • 0 Best Answers
      • 36 Points
      View Profile
      Bill Contributor
      2021-02-24T21:23:55+05:30Added an answer on February 24, 2021 at 9:23 pm

      Is what you want to do in my question "How to insert if IG is the result of a cross join?"

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
    2. Wayne

      Wayne

      • 4 Questions
      • 5 Answers
      • 0 Best Answers
      • 47 Points
      View Profile
      Wayne Contributor
      2021-02-25T17:16:08+05:30Added an answer on February 25, 2021 at 5:16 pm

      I want to populate the entries with the pre-filled values into a second table from the IG.

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter

    You must login to add an answer.

    Forgot Password?

    Sidebar

    Ask Question
    Write a Post

    Recent Blog Posts

    • Vinish

      Oracle Apex - Display External File in Region

    • Vinish

      Oracle PL/SQL Download BLOB File to Disk

    • Vinish

      Oracle Convert External File to BLOB

    • Vinish

      Oracle Apex Calendar Example

    • Vinish

      Oracle Apex - Open Modal Dialog Page Using JavaScript

    Explore

    • Home
    • Blog
    • New Questions
    • Tutorials
      • Oracle
      • Oracle Apex
      • Python
    • Tags
    • Users
    • Badges & Points
    • About

    © 2021 OrclQA.Com. All Rights Reserved. Privacy Policy