Re: FORMS4.5: returning multiple rows?

Use an explicit cursor. Here's the syntax:

DECLARE
  cursor <NAME> is

    select ----
    from ---
    where ---;

BEGIN
  for <NAME>_rec in <name> loop

  end loop;

You can access the data the cursor returns you by using: <NAME>_rec.<COLUMN>

If this doesn't help, let me know.

-- 
Joe Strano
Dulcian, Inc.

----------------------
edwards_at_garland.dnr.state.sc.us wrote:



> 

> when a query is executed that returns more than one row,

> Forms4.5 allows the user to move through the returned rows

> with arrow keys or buttons.

>         However when I create a trigger on a button that executes

> a query which returns more than one row, I get the too_many_rows

> exception.

> 

> How can I allow the user to move through multiple rows?