Re: can this reject bad data?

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

So on that basis Dieter you think that:

Test(DE) *YMD fieldName;

If %Error;
  // Set bad date indication;
EndIf;

Is harder to understand than that awful mess of SQL that we saw earlier? Sorry can't agree.

I've got nothing against SQL but I do dislike the "The answer is SQL - now what was the question?" approach.

 
On 2014-05-08, at 10:05 AM, D*B <dieter.bender@xxxxxxxxxxxx> wrote:

> <snip>
> Especially when a few lines of RPG can do the same thing, more
> readably, and probably execute faster?
> </snip>
>
> RPG? more readable? strange opinion!
> UDF? fast? Materializing the results will beat the UDF and save hours of runtime, If it is needed often, for large tables!  -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com