Need SQL*Forms 3 trigger help.
Date: 1995/07/20
Message-ID: <DBzt1r.7vD_at_iglou.com>#1/1
The sorted table looks something like this:
On the form I want it displayed something like this:
First record:
|-------------------------------------------------------|
AWARD
SSN AWARD DATE
--------- -------- ---------
123456789 AAAAAAAA 12-FEB-95
123456789 BBBBBBBB 24-MAY-94
123456789 BBBBBBBB 12-JUL-95
234567890 BBBBBBBB 07-APR-93
234567890 BBBBBBBB 13-JUL-95
234567890 CCCCCCCC 19-JAN-95
| SSN |
| --------- |
| 123456789 |
| |
| NUMBER |
| LAST DATE OF TIMES |
| AWARD RECEIVED RECEIVED |
| -------- --------- ------ |
| AAAAAAAA 12-FEB-95 1 |
| BBBBBBBB 12-JUL-95 2 |
| |
|-------------------------------------------------------|
Next record:
|-------------------------------------------------------|
| SSN | | --------- | | 234567890 | | | | NUMBER | | LAST DATE OF TIMES | | AWARD RECEIVED RECEIVED | | -------- --------- ------ | | BBBBBBBB 13-JUL-95 2 | | CCCCCCCC 19-JAN-95 1 | | |Received on Thu Jul 20 1995 - 00:00:00 CEST
|-------------------------------------------------------|