Re: Newbie cursor question

So don't indent them. You will not get an award for beautiful programming but it will work.

Remember, however, that a goto (yes, it is possible!) breaks the semantics of the program flow. For a clean design each block should have exactly one entry and one exit.

Perhaps you can modularize your program by putting the processing into a procedure.

Martin

Lisa Adcock wrote:
>
> I have a cursor and I would like to do some data validation on each row in
> the cursor before the "real" processing begins. I would like to organize my
> as follows but am having problems finding the right language
> construct/reserved word.
>
> for emp_record in cur_employees loop
>
> if this row has a data problem then
> continue onto next row in cursor
> end if
>
> -- start real processing here
>
> end
>
> I can solve my problem by putting the "real" processing in the elsif part of
> the if statement, but the processing logic already involves three nested ifs
> and I don't want to indent them another level by putting them in the elsif.
>
> Any ideas would be appreciated!
Received on Thu Aug 10 2000 - 00:00:00 CDT