Date Display (Long)

[Rod Hulme]

Thanks to those that responded. Some response from me and a further explanation. Any more ideas anyone as to why this occurs?

Rod.


Matt wrote:

>Why wouldn't PowerHouse treat "null" value and the "0" value different?
>They are different.  Just like 1 and 2.  Null values are unpredictable.  I
>had subscreen in the past that had data expression errors.

I agree Matt, but where does the decision to display the "Null" as "  /  /1900" come from?

Sam Perri wrote:

>When you modified your data.  Did you blindly add "19" to all your
>dates.  If you had a date with no date, then  what you're seeing is what
>would happen.

No Sam this happens also with newly created records.

Here is output of the same record from 3 different perspectives: Quick, Quiz, and Query (we are on an HP3000). Non relevent data has been changed. The Dictionary record description and database layouts are also shown. (One thing to note is that the record has been created from COBOL. The DATE-ASS-RET-STU field has been set to 0 through the Quick screen later, for the purpose of this display). 

Architect description:

1  STUDENT-NUMBER            C    8          CHARACTER        8           1.000
2  SUBJECT-NUMBER             C    5          CHARACTER         6           2.000
3  DATE-MAIL-TO-STUDENT   D    8          ZONED           U    8           3.000
4  DATE-ASS-TO-TUT              D    8          ZONED           U    8           4.000
5  DATE-ASS-RET-STU            D    8          ZONED           U    8           5.000

Database Layout:

Dataset ,DETAIL

      ITEMS:
         STUDENT-NUMBER,       X8            <<SEARCH ITEM>>
         SUBJECT-NUMBER,        X6            <<SEARCH ITEM>>
         DATE-MAIL-TO-STU,       Z8
         DATE-ASS-TO-TUT,        Z8
         DATE-ASS-RET-STU,      Z8

Quiz:

> ACCESS Dataset
> CHO STUDENT-NUMBER PARM
> SEL IF SUBJECT-NUMBER = '1234'
> REP STUDENT-NUMBER SUBJECT-NUMBER DATE-MAIL-TO-STU DATE-ASS-TO-TUT
> GO

Student number: 9XXXXXXX
Student number: 


07-AUG-98                  GLOBAL SYSTEM-WIDE OPTIONS                  PAGE   1

  Student   Subject   DATE-MAIL       DATE-ASS        DATE-ASS
  number    number     TO STU          TO-TUT             RET-STU

  9XXXXXXX  1234    18/06/1994

Quick:

MODE:F ACTION:          
01 Student number      9XXXXXXX
02 Subject number:      1234
03 Date mail stu:          18/06/1994
04 Date ass-to-tut:   /  /1900
05 Date ass-ret:

(We seem to overcome the "problem" in Quick by including a test for fieldtext = "" in the output procedure replacing it with "000000000").


Query:

HP32216D.03.11  QUERY/3000  FRI, AUG  7, 1998,  8:23 AM 
COPYRIGHT HEWLETT-PACKARD CO. 1976

B=ASSIGN.TECTEST
PASSWORD = >>
MODE = >>1
>S=DSTUDENT-ASSIGNM
>F STUDENT-NUMBER = 9XXXXXXXX
90  ENTRIES QUALIFIED
>SUBSET
>>SUBJECT-NUMBER = 1234
1  ENTRIES QUALIFIED
>REP ALL

STUDENT-NUMBER        =9XXXXXXXX
SUBJECT-NUMBER         =1234
DATE-MAIL-TO-STU        =19940618
DATE-ASS-TO-TUT   =
DATE-ASS-RET-STU =00000000

...



Rod Hulme
RMIT University Melbourne

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.