Re: SQR Warning

[Greg Hesla <ghesla@CIMACONSULTING.COM>]

SQR version 4 uses default date masks. The delivered default date mask for
Oracle is DD-MON-YY. However, you probably have the Oracle date mask set up
as DD-MON-YYYY. Add the following section to your SQR.INI file and it should
solve the problem:

[Environment:Oracle]
SQR_DB_DATE_FORMAT=DD-MON-YYYY

There are other environment settings, and other environments. I believe that
the environments and the settings are discussed in the SQR manual that was
delivered (in PDF format) with SQR v.4.

Hope this helps,

Greg Hesla
Cima Consulting Group
www.cimaconsulting.com


----- Original Message -----
From: Pam Lantzy <plantzy@UAMAIL.ALBANY.EDU>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Sent: Tuesday, May 18, 1999 1:31 PM
Subject: SQR Warning


> Hi,
>
> I am getting the following warning:
>
>    (SQR 7501) Using YY edit mask from (DD-MON-YY) against (1999)
>
> The line of code is within a begin-select.  I have selected P.TEST_DT and
now
> I want to move it to a variable.
>
>    move &P.TEST_DT         to $TEST_DT_INPUT
>
>
> Any way I can get rid of this warning?
>
> Thanks Pam
>