Re: 4GL Programming tidbit

In <E79Fwu.9MH@nonexistent.com>, Jacob Salomon wrote: >Conclusion: the FOREACH loop internal mechanism does not like working >on a scroll cursor. (IMO It's unlikely that it is barfing on the WITH >HOLD.) I am not prepared to argue that this a product deficiency; >after all, a foreach loop has no need for a scroll cursor. But it >might be nice if the reference manual warned me about this. And it >might be nice if I had the ability to reuse the scroll cursor in a >WHILE loop after using it in the FOREACH loop. > Jake, Declaring a corsor as "scroll" + "with hold", will not / should not create any trouble in foreach. There is something else going wrong, please double check. If you are VERY sure there is nothing else wrong in your code, then it could be a problem with the version of 4GL are you using. As you have mentioned, you should not be waisting additional resources, by declaring a scroll-cursor, if it is not going to use scroll-features. Cheers Felix K. Mathews ( fmathews@systems.dhl.com )