Ocenite etot tekst:Ne chital10987654321
SoderzhanieFine HTMLPrinted versiontxt(Word,KPK)Lib.ru html
Vstroennye funkcii 4GL. Ne vklyuchat' v SQL operatory.

Darg_valE (n)          n-j argument iz komandnoj stroki
Dnum_argsE ()          kol-vo argumentov v komandnoj stroke

DinfieldE (field-name) istina esli kursor nahoditsya v pole  (DISPLAY/INPUT)
CALL Dset_countE(n)    soobshchit' 4GLyu kol-vo zapolnennyh strok v massive
                     pered operatorom DISPLAY ARRAY
Darr_currE()           No. tekushchej stroki massiva           (INPUT/DISPLAY ARRAY)
Dscr_lipeE ()          No. tekushchej stroki ekrannogo massiva (INPUT/DISPLAY ARRAY)
Darr_countE ()         kol-vo zapolnennyh strok v massive   (INPUT ARRAY)

Derr_getE (status)     4GL soobshchenie ob oshibke ° status
CALL Derr_printE(nn)   vyvesti  4GL soobshchenie ob oshibke ° nn
CALL Derr_quitE (nn)   vyvesti  4GL soobshchenie ob oshibke i konchit'
CALL DshowhelrE (n)    vyvesti  4GL help-menu i help-soobshchenie

CALL DstartlogE("filename")   otkryt' errorlog fajl
CALL DerrorlogE (stroka)      dobavit' soobshchenie v errorlog

DdownshiftE (stroka)          ne dlinnee 512
DupshiftE   (stroka)

DASCIIE   n            Preobrazuet chislo n v simvol ASCII
stroka DCLIPPEDE       Gasit probely v konce stroki
DCOLUMNE  n       Dobavit' probelov, chtob okazat'sya na n-om stolbce ekrana

Dexpr USING "format"E  Zadaet format dlya number, MONEY, DATE vyrazhenij
  elementy formata chisel: D*&#<,.-+()$E
    D*E Zamenyat' probely na *        D.E   poziciya desyatichnoj tochki
    D&E Zamenyat' probely na 0        D-E   pozicii znaka "-"
    D#E nichego ne menyat'             D+E   pozicii znakov "+","-"
    D<E levoustanovit' chislo     D(((E...D)E otricatel'noe chislo v skobki.
    D,E literal ","                  D$E   literal  "$"
  elementy formata dat: DddE,DdddE,DmmE,DmmmE,DyuE,DyyyuE i literaly D/-.()E i dr.

|ti funkcii mozhno ispol'zovat' v operatore SELEST:

SITENAME                imya servera(ili hostname)          D*OnL*E
DLENGTNE (stroka)            dlina bez zakanchivayushchih probelov
DUSER E                      login-name tekushchego pol'zovatelya
DTODAYE                      tekushchaya data v sistemnom formate
DCURRENTE  [first DTOE last]   tekushchee DATETIME
gde first,last iz {YEAR,MONTH,DAY,HOUR,MINUTE,SECOND,FRACTION(n)}

Preobrazovanie  dat i vremeni:

DTIMEE                       tekushchee vremya v vide "hh:mm:ss"
DDATEE                       tekushchaya data v vide "Mon Apr 1 1991"
DEXTENDE (datetime-value [first DTOE last]) preobrazuet k DATETIME
expr DUNITSE qualifier Vozvrashchaet INTERVAL znachenie=expr*qualifier
gde qualifier ¨ {YEAR,MONTH,DAY,HOUR,MINUTE,SECOND,FRACTION(n)}
DDATEE ([char] expr)         preobrazuet k tipu DATE
DMDYE (nDAY, nMONTH, nYEAR)  preobrazuet k tipu DATE

DDAYE (data  )     vydelyaet nomer dnya v mesyace iz daty
DWEEKDAYE (data)   vydelyaet nomer dnya v nedele   ! Zdes' data  
DMONTNE (data)     vydelyaet nomer mesyaca         ! tipa DATE   
DYEARE (data)      vydelyaet god                  ! ili DATETIME


Vstroennye agregatnye funkcii operatora  SELEST.

DCOUNTE (*)
DCOUNTE (  DISTINCT  column-name )     kolichestvo
DSUME   ( [DISTINCT] column-name )
DAVGE   ( [DISTINCT] column-name )     srednee znachenie
DMINE   ( [DISTINCT] column-name )
DMAHE   ( [DISTINCT] column-name )
Last-modified: Wed, 17 Apr 1996 04:30:52 GMT
Ocenite etot tekst:Ne chital10987654321