5.09, CHOOSE & PARM
Deskin, Bob
Bob.Deskin@cognos.com
Sun, 1 Feb 1998 08:22:45 -0500
Keep in mind that the earliest year 2000 compliant version of PowerHouse
on MPE/iX is 7.29.C8. Earlier versions had problems getting the correct
system date (it's a long story as to why). Everyone should be moving to
at least 7.29.C8.
Bob Deskin
Senior Product Advisor bob.deskin@cognos.com
Cognos Inc. (613) 738-1338 ext 4205 FAX: (613) 228-3149
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
> ----------
> From: Roger Marcinik[SMTP:ROGERM@compuserve.com]
> Sent: January 31, 1998 6:46 PM
> To: PowerHouse List
> Subject: 5.09, CHOOSE & PARM
>
> One of our clients is still using 5.09 on an HP3000. They have a
> number of
> QUIZ reports using CHOOSE with a prompt for a date. Until recently
> the
> Image (key) date field was defined as Z6. The Image database was
> restructured using Adager and all dates were changed to Z8. The QDDR
> dictionary was changed to match and with century now included as date
> default with format MMDDYYYY. After these changes, the QUIZ reports
> were
> modified to prompt for MMDDYYYY and recompiled. All QUIZ using
> CHOOSE
> NEWDATE PARM PROMPT failed to retireve any records. In an interactive
> test, CHOOSE NEWDATE 19980125 produced the expected results, but when
> the
> PARM option was used with or without the FORMAT option, the CHOOSE
> failed
> again. Since the client also has version 6.09 available, but not in
> use
> yet, we tested the interactive and compiled QUIZ versions and CHOOSE
> with
> the PARM PROMPT worked fine with version 6.09.
>
> CHOOSE NEWDATE PARM PROMPT still works fine in QTP 5.09 and FINDs in
> QDESIGN/QUICK 5.09 also work fine. Only QUIZ 5.09 fails.
>
> As a workaround, client plans to recompile all QUIZ using version
> 6.09,
> but keep the dictionary, QTP and QUICK on version 5.09 for the time
> being
> until users can perform extensive testing using version 6.09.
> Should we expect any problems with this configuration?
>
> Anyone else notice similar problems? Anything else we should look out
> for
> with 8 character dates?
>