G
gkarol_ccj
Guest
Panie Piotrze, wklejam include: /*------------------------------------------------------------------------ File : Firmy Purpose : Syntax : Description : Author(s) : gkarol Created : Sun Jun 26 23:01:16 CEST 2016 Notes : ----------------------------------------------------------------------*/ /* *************************** Definitions ************************** */ /* ******************** Preprocessor Definitions ******************** */ /* *************************** Main Block *************************** */ /** Dynamically generated schema file **/ @openapi.openedge.entity.primarykey (fields="id_firmy"). DEFINE TEMP-TABLE ttfirmy BEFORE-TABLE bttfirmy FIELD id_firmy AS INTEGER INITIAL "0" LABEL "?" FIELD kod_firmy AS CHARACTER LABEL "?" FIELD nazwa_firmy AS CHARACTER LABEL "Nazwa" FIELD pelna_nazwa AS CHARACTER LABEL "Pełna nazwa" FIELD NIP AS CHARACTER LABEL "?" FIELD adres_miejscowosc AS CHARACTER LABEL "Miejscowość" FIELD adres_kod AS CHARACTER LABEL "Kod" FIELD adres_ulica AS CHARACTER LABEL "Ulica" FIELD adres_poczta AS CHARACTER LABEL "?" FIELD prezes AS CHARACTER LABEL "?" FIELD telefon AS CHARACTER LABEL "?" FIELD fax AS CHARACTER LABEL "?" FIELD email AS CHARACTER LABEL "?" FIELD data_rej AS DATE INITIAL "?" LABEL "?" FIELD nr_rej AS CHARACTER LABEL "Nr rej." FIELD www AS CHARACTER LABEL "www" FIELD aktywna AS LOGICAL INITIAL "Yes" LABEL "Aktywna" FIELD id_prowadzacego AS INTEGER INITIAL "0" LABEL "?" FIELD adresk_miejscowosc AS CHARACTER LABEL "Miejscowość" FIELD adresk_kod AS CHARACTER LABEL "Kod" FIELD adresk_ulica AS CHARACTER LABEL "Ulica" FIELD adresk_poczta AS CHARACTER LABEL "?" FIELD uwagi AS CHARACTER LABEL "Uwagi" FIELD id_filii AS INTEGER INITIAL "0" LABEL "?" FIELD oczekujaca AS LOGICAL INITIAL "No" LABEL "Oczekująca" FIELD AQAP AS LOGICAL INITIAL "No" LABEL "AQAP" FIELD upowaznienie_VAT AS LOGICAL INITIAL "No" LABEL "Upowaznienie VAT" FIELD typ_szkolenie AS LOGICAL INITIAL "No" LABEL "Szkolenie" FIELD typ_certyfikacja AS LOGICAL INITIAL "No" LABEL "Certyfikacja" FIELD typ_inne AS LOGICAL INITIAL "No" LABEL "Inne" FIELD archiwum AS CHARACTER LABEL "?" FIELD dokumentacja AS CHARACTER LABEL "Dokumentacja" FIELD oczekujaca_wn AS LOGICAL INITIAL "No" LABEL "Wniosek" FIELD oczekujaca_kw AS LOGICAL INITIAL "No" LABEL "Kwestionariusz" FIELD oczekujaca_umowa AS LOGICAL INITIAL "No" LABEL "Umowa" FIELD oczekujaca_kj AS LOGICAL INITIAL "No" LABEL "Księga Jakości" FIELD oczekujaca_proc AS LOGICAL INITIAL "No" LABEL "Procedury" FIELD oczekujaca_uwagi AS CHARACTER LABEL "?" FIELD id_wojewod AS INTEGER INITIAL "0" LABEL "?" INDEX idx-aktywna aktywna DESCENDING nazwa_firmy ASCENDING adres_miejscowosc ASCENDING INDEX idx-id_firmy IS PRIMARY UNIQUE id_firmy ASCENDING INDEX idx-nazwa nazwa_firmy ASCENDING adres_miejscowosc ASCENDING INDEX idx-nip NIP ASCENDING nazwa_firmy ASCENDING INDEX idx-pelna pelna_nazwa ASCENDING INDEX idxw-nazwa nazwa_firmy ASCENDING INDEX idxw-pelna_nazwa pelna_nazwa ASCENDING . DEFINE DATASET dsfirmy FOR ttfirmy.
Continue reading...
Continue reading...