Hi Leshel.

>> Can someone offer any suggestions on how to clean up this code? My problem is that the customer number can have more than the allowed do nesting level occurrances of a specific sales order number. Below is the code for my DO WHILE. Note that the code is in a function called l_upddtl, and this code is calling that function, so there is a recursive call to that function within itself. HELP!!! <<

I did not have the time or the patience to wade through this line by line, but the most common cause for this sort of error when a routine is calling itself recursively is that you have neglected to declare one or more variables as local inside the recursive routine.

Variables that are not explicitly scoped as LOCAL ( or PRIVATE or < gasp! > PUBLIC ) are, by default, PRIVATE. This means that they can be "seen" by all routines that are called from the one in which they are created.