While: System.Last_Record

[bessa_lucas]

Gentlemen,

I have a very beginner doubt here, but in my company in almost all "whiles" are done so

Select all

while :system.last_record   != 'TRUE' loop 
 
SOME CODE  
 
end loop 
 
MORE CODE

The staff here uses :system.last_record to scroll through a list, but the last line is not executed. So we have to put the same loop code outside to run one more time.
Question:
Would it have any more practical form for him to perform everything within the loop?

[tiago_pimenta]

You could put it like this if I'm not mistaken:

Select all

loop 
<código> 
exit when :system.last_record = 'TRUE'; 
end loop;

[bessa_lucas]

tiago_pimenta then I'll test and let you know if it worked!
Thanks!

[tiago_pimenta]

Bessa,

Only a correction, I forgot the NEXT_RECORD

So it would be like this:

Select all

loop 
<código> 
exit when :system.last_record = 'TRUE'; 
next_record; 
end loop;

[bessa_lucas]

tiago_pimenta

Perfect! Tested and approved!

[tiago_pimenta]

Show: