Re: (SQR 7100) The use of an edit mask or the keywords NUMBER, MONEY or DATE

[Nathan Stratton Treadway <nathant@ONTKO.COM>]

On Tue, May 18, 1999 at 12:56:08PM -0400, Mark Boyd wrote:
> I get the following SQR error when running PeopleSoft delivered
> PAY013.SQR:
>
> (SQR 7100) The use of an edit mask or the keywords NUMBER, MONEY or DATE
> is not legal when storing numeric variables.
> move #AsOfYYYY  to #PreAsOfYr  0000
>
> When running in this environment:
>     SQR/4.3.2/PC/Windows NT 4.0/Oracle 7.3.4/Sep 14 1998
>     PSTools 7.04
>
> This SQR has not been modified and works fine with:
>    SQRW/3.0.18.1.1/PC/Windows NT 4.0/Oracle 7.3.3.2/Aug 20 1997
>    PStools 7.03

This is a bug in SQR 3 that has been corrected in SQR 4 (at least in my
opinion).  It does cause trouble when you upgrade, unfortunately.

As you see here, "move" can take an edit mask.  This makes sense if you
are moving into a $ variable, as in
   move #AsOfYYYY to $Display_YYYY edit 0000

(so that $Display_YYYY has leading "0"s on it for years < 1000).

However, the edit mask has no use when you are moving into a # variable.
In SQR 3, this was simply ignored without any message, but in SQR 4 it
raises an error (as you see here).

I don't know for sure, but I'd guess that PeopleSoft has a corrected
version of PAY013.SQR suitable for running under SQR 4....

                                                        Nathan

----------------------------------------------------------------------------
Nathan Stratton Treadway  | Ray Ontko & Co. | Software consulting services
nathant@ontko.com         | Richmond, IN    | http://www.ontko.com/