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

[Aboukr Sadikh <bsadikh@YAHOO.COM>]

Nathan,

comment out the edit (0000), and it will do it.

BS

--- Nathan Stratton Treadway <nathant@ONTKO.COM> wrote:
> 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/
>

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com