Looping On Block Data

From: Greg James <g.c.james_at_worldnet.att.net>
Date: Fri, 13 Aug 1999 08:30:48 -0600
Message-ID: <7p1ae4$i08$1_at_bgtnsc02.worldnet.att.net>

[Quoted] I'm migrating an app to oracle ( forms 4.5 ) and I have a rookie question.

I have a block that displays ten rows of table data (same base table). The 'WHERE' clause property for the block may return any number of records.

I need to process each record, row by row, in a pushbutton trigger. What is the easiest way to Loop through the records without knowing how many records will be present?

Could I trap a FRM-40352 error within the loop so that if I hit the last record, the code would drop out of the loop? Thanks. Received on Fri Aug 13 1999 - 16:30:48 CEST