Forms 4.5 - Too Many Rows

Hi everyone,

I am having a problem with a Too_Many_Rows exception which arises because of the following:

I supply a ref no in a control text item and have a button which has a When Button Pressed event that searches the database and populates a block of display items.

The block is set to display 10 items, and I am using a reference which I know returns 8 rows. The problem is that the Too_Many_Rows exception comes up because the trigger is trying to populate all matches into one line of the display block. Is there a way that I can get it to automatically move to the next line of the display block each time a record is found?

Many thanks in advance,

Nick Lehane Received on Thu Aug 06 1998 - 08:18:46 CDT