Navigating through records inside a FOR EACH loop

Within a stored procedure that returns multiple records, is there a way to move previous within the FOR EACH loop? Thanks in advance __________________________________________________ This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank You. ___________________________________________________

Far as I know, it can't be done with a FOREACH loop. You might try a FETCH. declare <cursorname> scroll cursor for <whatever> then fetch previous <cursorname> fetch next <cursorname> fetch relative <direction> <cursorname> John Carlson Informix DBA WHSmith USA nanson@paulweiss.com wrote: > > Within a stored procedure that returns multiple records, is there a way to > move previous within the FOR EACH loop? > > Thanks in advance > > __________________________________________________ > > This message is intended only for the use of the Addressee and may > contain information that is PRIVILEGED and CONFIDENTIAL. > > If you are not the intended recipient, you are hereby notified that any > dissemination of this communication is strictly prohibited. If you have > received this communication in error, please erase all copies of the > message and its attachments and notify us immediately. > > Thank You. > ___________________________________________________