Path: utzoo!attcan!uunet!mcvax!cernvax!pan!jw
From: jw@pan.UUCP (Jamie Watson)
Newsgroups: comp.databases
Subject: Informix 4gl bug
Keywords: Bull
Message-ID: <463@pan.UUCP>
Date: 31 Aug 88 16:01:31 GMT
Reply-To: jw@pan.UUCP (Jamie Watson)
Organization: Adasoft AG, Solothurn, Switzerland
Lines: 40


Given the following trivial 4gl program,

database bletch
main
  start report foo
    output to report foo (1)
  finish report foo
end main
report foo (bar)
  define
    bar integer
  order by bar
  format
    before group of bar
      print "Before ", bar
    on every row
      print "Every ", bar
    after group of bar
      print "After ", bar
end report

The output produced, believe it or not, is this:

     Before           1
     Every           1
     After           1
     After           0

Looks like about one too many calls to the 'after group of bar' routine to me.

The problem does not appear in any of these cases:

- Change the 'order by bar' to 'order external by bar'

- Get rid of the 'order by bar' statement

- Feed two values to the report.  It doesn't have to be two different values.

jw