Re: Tools upgrade SQR 3 to SQR 4 problems

[Allen Wong <awong01@YAHOO.COM>]

You must add/change the sqr.ini with SQR_DB_FORMAT=DD-MON-YYYY - or
some date format like that - refer to the sqr book for the correct date
format.


--- "Wendel, Robbi" <rwendel@NESPOWER.COM> wrote:
>         We are starting our Tools conversion from
> 7.01 to 7.05 which
> includes the SQR upgrade(3.0.18.1. to 4.3.4). Our
> database is Oracle 7.3.4
>
> In our initial testing of our custom SQR's we are
> running into this warning
>
>         Warning on line 250:
>         (SQR 7501) Using YY edit mask from
> (DD-MON-YY) against (1999)
>
> Where at the same time we seem to be having
> successful execution of ALTER
> SESSION
> showing the four digit year being set to YYYY(see
> below)
>
>         Cursor #1:
>         SQL = ALTER SESSION SET
> NLS_DATE_FORMAT='DD-MON-YYYY'
>         Compiles = 1
>         Executes = 1
>         Rows     = 0
>
> These same SQR's run fine in the old version. What
> else do we need to
> change?
>
> Any thoughts would be appreciated!
>
> TIA,
> Robbi Anne Wendel
> SCT Corporation
> rwendel@nespower.com
> (615) 747-3078
>

__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com