Re: SQR cycle

["\"Fernando Villaamil" <FVillaamil@AOL.COM>]

In a message dated 97-04-30 03:19:25 EDT, you write:

<< I am running an SQR that does a begin-select from a table.  I then want to
 process those records selected but I do not want the select to continuously
 run every time a new record is needed.  For example:

 Begin-Select

 Customer,
 Customer_Number

   Do Main-Processing  (which includes a commit statement)

  From
   Customer_Table

  Where  Customer_Number = 0

 End-Select >>

The select is being processed for every record that matches the WHERE
statement.... thing of it as a DOWHILE loop.  For every record matching the
criteria you are doing MAIN-PROCESSING