Re: Every day a school day.

On 2018-07-31 05:49, Alan Bourke wrote:

On Tue, 31 Jul 2018, at 5:57 AM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:

...

I pretty much only use it with arrays. What else would you use it for??? Collections I guess?

I only use it for collections, due to the fact that I avoid arrays if possible.

I only use FOR EACH with arrays on functions like AFIELDS where it automatically creates arrays. The only time I ever use arrays other than those scenarios is where I just use it for a SUM query:

select sum(MyValue) FROM MyTable into array laSum

return nvl(laSum[1],0)

Stuff like that.