Ocenite etot tekst:Ne chital10987654321
SoderzhanieFine HTMLPrinted versiontxt(Word,KPK)Lib.ru html
4GL. Otchety

DREPORTE report-name (argument-list)

DDEFINEE variable-list { type | LIKE table-column |
   RECORD  { LIKE table.* | variable-list  type [,...] END RECORD }}[,...]

[DOUTPUTE                       po umolchaniyu:

  [REPORT TO { "filename | PIPE "program" | PRINTER }    ]
                                 SCREEN
  [ LEFT MARGIN integer ]          5
  [ RIGHT MARGIN integer ]        132
  [ TOP  MARGIN integer ]          3
  [ BOTTOM MARGIN integer ]        3
  [ PAGE LENGTH integer ]          66
]

[DORDERE [EXTERNAL] BY  sort-list ] podspisok peremennyh, vhodyashchih v argumenty


DFORMAT EVERY ROWE   prostejshij operator formata.
                V etom sluchae nel'zya ispol'zovat' kontrol'nye bloki.
        libo

DFORMATE  vklyuchaet v sebya neskol'ko kontrol'nyh blokov, kotorye 
soderzhat obychnye operatory 4GL i operatory primenimye tol'ko v REPORT

  ON EVERY ROW                  vyvodit stroku
        statement
          . . .
  FIRST PAGE HEADER             vyvodit zagolovok pervoj stranicy
        statement
          . . .
  ON LAST ROW                   okonchanie REPORT (podvedenie itogov)
        statement
          . . .
  PAGE HEADER                   zagolovok kazhdoj stranicy
        statement
          . . .
  PAGE TRAILER                  v konce kazhdoj stranicy
        statement
          . . .
  BEFORE GROUP OF variable      v nachale gruppy strok
        statement
          . . .
   . . .
  AFTER GROUP OF  variable      v konce gruppy strok
        statement
          . . .
   . . .
DEND REPORTE
ннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннннн
v kontrol'nyh blokah pomimo obychnyh operatorov 4GL ispol'zuyutsya:

NEED num-expr LINES     esli na stranice ostalos' menee expr strok, 
                        to nachat' s novoj stranicy.

PAUSE ["Soobshchenie" ]    vyvesti Soobshchenie na ekran i zhdat' nazhatiya CR

PRINT FILE "filename"   vyvesti na pechat' soderzhimoe fajla

SKIP { integer LINE | TO TOP OF PAGE }

PRINT   expr-list   [;] vyvesti na pechat' [ ne perevodya stroku ]


        Dv REPORT mozhno ispol'zovat' sleduyushchie funkcii:E

num-expr SPACES                          vstavit' probely
char-exp WORDWRAP [RIGHT MARGIN integer] vyvesti dlinnuyu stroku

LINENO          nomer stroki na stranice
PAGENO          nomer pechataemoj stranicy

        DAgregatnye funkcii:E

[GROUP]   DfunctionE   [WHERE  uslovie]
[dlya gruppy strok] primenit' funkciyu [tol'ko dlya strok, udovletvoryayushchih usloviyu]

gde DfunctionE mozhet byt':
{ COUNT(*) | PERCENT(*) | { SUM | MAX | MIN | AVG }(expr) }
           v procentah ot                      srednee
         obshchego kol-va strok

        DObychnye funkcii 4GL (sm. fajl h4fu)E
Last-modified: Thu, 12 Feb 1998 08:47:55 GMT
Ocenite etot tekst:Ne chital10987654321