Date:         Thu, 14 Sep 1995 14:53:06 +0100
Reply-To:     The NOMAD2 Discussion List
Sender:       The NOMAD2 Discussion List
From:         Alan Long
Subject:      ACROSS WITH AS DISPLAY

     I'm using Nomad version 6.00 on VM/XA and found a weird problem.  If
I run my procedure once within a session, I get an unexpected result.  If
I run it immediately again, I get the expected result.  Further runs are
OK, until I quit from the Nomad environment.  Entering the Nomad
environment once again similarly produces an unexpected result on the
first run only.

Here is the schema for MYDB1:

          MASTER MYDB1   INSERT=KEYED(KEY1);
          ITEM KEY1              AS A3;
          ITEM ITEM1(3)          AS 999;

          PERSPECT;

Here are the contents of MYDB1:

           KEY1  ITEM1
           ----  -----
           AAA      10
                    20
                    30
           BBB      40
                    50
                    60
           CCC      70
                    80
                    90

Here is the schema for MYDB2:

          MASTER MYDB2   INSERT=KEYED(KEY1);
          ITEM KEY1              AS 999;
          ITEM ITEM1             AS A5;

          PERSPECT;

Here are the contents of MYDB2:

           KEY1  ITEM1
           ----  -----
              1  SEP95
              2  AUG95
              3  JUL95

Here is my procedure:

          DA MYDB1;
          DBADD MYDB2;

          FROM MYDB1
          LIST BY KEY1
               ACROSS INDX(ITEM1) AS DISPLAY'ITEM1 FROM MYDB2'
               ITEM1 HEADING''
          ON FILE;

          SYS BROWSE FILE FILE;

Here is the result of the first run:

           KEY1   N/A   AUG95  JUL95
           ----  -----  -----  -----
           AAA      10     20     30
           BBB      40     50     60
           CCC      70     80     90


Here is the result of the second and subsequent runs:

           KEY1  SEP95  AUG95  JUL95
           ----  -----  -----  -----
           AAA      10     20     30
           BBB      40     50     60
           CCC      70     80     90

     Why does the header of the second column always show N/A on the
first run?????

Regards,
Alan Long     Motorola Semiconductors, East Kilbride, Scotland
              email TICS28@WACCVM.corp.mot.com
back to index