AA 0017 12/05/2007 367
AA 0017 01/02/2008 372
AA 0017 01/30/2008 371
AA 0017 02/27/2008 371
AA 0017 03/26/2008 373
AZ 0555 12/05/2007 213
AZ 0555 01/02/2008 213
AZ 0555 01/30/2008 210
AZ 0555 02/27/2008 215
Using At New
At New ---> the left side feild change the event
trigers and the values become 0 and * for Next Field which u r mentioned in Between At new and Endat .
data: sflight_tab type sorted table of sflight
with unique key carrid connid fldate,
sflight_wa like line of sflight_tab.
select *
from sflight
into table sflight_tab.
loop at sflight_tab into sflight_wa.
at new carrid.
uline.
write: / sflight_wa-carrid,
sflight_wa-connid,
sflight_wa-fldate.
uline.
endat.
write: / sflight_wa-fldate,
sflight_wa-seatsocc.
endloop.
Output
AA **** **/**/****
12/05/2007 367
01/02/2008 372
01/30/2008 371
02/27/2008 371
03/26/2008 373
AZ **** **/**/****
12/05/2007 213
01/02/2008 213
01/30/2008 210
02/27/2008 215
No comments:
Post a Comment