OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » multiple rows select in interactive grid using FOR LOOP

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » multiple rows select in interactive grid using FOR LOOP (Application Express 21.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

multiple rows select in interactive grid using FOR LOOP [message #689109]

Sun, 24 September 2023 07:42

hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN

Senior Member

Dear Experts,
we Need to show multiple rows in interactive grid using FOR LOOP.
somebody can help please? how to define the code please.

Thankful

Report message to a moderator

Re: multiple rows select in interactive grid using FOR LOOP [message #689110 is a reply to message #689109]

Sun, 24 September 2023 11:48

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Apex <> Forms.

In Forms, you'd write a trigger which loops through some data source and puts values into block fields. I don't see a point in doing that in Apex's Interactive Grid. Why would you want to do that? Interactive Grid works best in a (let's just call it) MS Excel mode, where you can view and edit data directly on the same page (as opposed to combination of Interactive Report + Form). That also means that Apex automatically generates process which handles modifications to the grid.

You could - for example - create a collection, a view on that collection, instead-of trigger (to handle modifications), your own Apex DML process and see what will turn out of that. I never tried it so I can't offer any suggestion based on my own experience, but - if I were you - I'd think twice whether that's something I'd really want to do, or switch to something else which is natively supported by Apex and - thus - simpler to implement and use.

Report message to a moderator

Re: multiple rows select in interactive grid using FOR LOOP [message #689138 is a reply to message #689110]

Thu, 28 September 2023 03:50

hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN

Senior Member

Thanks for reply Dear Littlefoot,
Actually we want to fetch rows on Button click and populate in Interactive grid using loop, because there are more than one records to populate for example we need to populate the number of products or items with UOM, qty and rate from another table.
therefore I requested.

Thankful..

Report message to a moderator

Re: multiple rows select in interactive grid using FOR LOOP [message #689163 is a reply to message #689138]

Fri, 29 September 2023 01:36

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

OK.

So, you have two tables: one that already contains rows you need, and another one which will "accept" rows from the 1st table. The 2nd table is (I presume) base table for the interactive grid region.

How about the following approach?

create a button (let's call it P1_BTN_COPY)
create a process which will "copy" data from one table to another; I presume that there should also be some page items which will help in identifying rows that should be copied. Process should fire only when P1_BTN_COPY is pressed

write code which does that, e.g.

insert into table_2 (id, name, address, amount) 
select id, name, address, amount
from table_1
where code = :P1_CODE
  and year = :P1_YEAR;

submit would refresh the page and cause interactive grid to be populated; make sure to include appropriate WHERE clause in grid's properties, otherwise you'll get all rows from the 2nd table, and that's probably not what you want

Report message to a moderator