| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959 |
- &ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2
- &ANALYZE-RESUME
- /* Connected Databases
- anadat PROGRESS
- */
- &Scoped-define WINDOW-NAME CURRENT-WINDOW
- &Scoped-define FRAME-NAME gExportfelder
- /* Temp-Table and Buffer definitions */
- DEFINE TEMP-TABLE TTabel NO-UNDO LIKE Tabel.
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gExportfelder
- /*------------------------------------------------------------------------
- File:
- Description: from cntnrdlg.w - ADM2 SmartDialog Template
- Input Parameters:
- <none>
- Output Parameters:
- <none>
- Author:
- Created:
- ------------------------------------------------------------------------*/
- /* This .W file was created with the Progress AppBuilder. */
- /*----------------------------------------------------------------------*/
- /* Create an unnamed pool to store all the widgets created
- by this procedure. This is a good default which assures
- that this procedure's triggers and internal procedures
- will execute in this procedure's storage, and that proper
- cleanup will occur on deletion of the procedure. */
- CREATE WIDGET-POOL.
- /* *************************** Definitions ************************** */
- /* Parameters Definitions --- */
- DEF OUTPUT PARAMETER opExport AS LOG NO-UNDO.
- /* Local Variable Definitions --- */
- DEF VAR MaxPage AS INT NO-UNDO.
- DEF VAR AktSeite AS INT NO-UNDO.
- DEF VAR FMutFlag AS LOG NO-UNDO.
- DEF VAR ProgName AS CHAR NO-UNDO.
- DEF VAR SAktiv AS LOG NO-UNDO.
- DEF VAR Firma AS CHAR NO-UNDO.
- DEF VAR AdFirma AS CHAR NO-UNDO.
- DEF VAR FEntry AS LOG NO-UNDO.
- DEF BUFFER BTabel FOR TTabel.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
- /* ******************** Preprocessor Definitions ******************** */
- &Scoped-define PROCEDURE-TYPE SmartDialog
- &Scoped-define DB-AWARE no
- &Scoped-define ADM-CONTAINER DIALOG-BOX
- &Scoped-define ADM-SUPPORTED-LINKS Data-Target,Data-Source,Page-Target,Update-Source,Update-Target
- /* Name of designated FRAME-NAME and/or first browse and/or first query */
- &Scoped-define FRAME-NAME gExportfelder
- &Scoped-define BROWSE-NAME Br-Felder
- /* Internal Tables (found by Frame, Query & Browse Queries) */
- &Scoped-define INTERNAL-TABLES TTabel
- /* Definitions for BROWSE Br-Felder */
- &Scoped-define FIELDS-IN-QUERY-Br-Felder TTabel.Bez1 TTabel.Flag_1 ~
- TTabel.Bez2
- &Scoped-define ENABLED-FIELDS-IN-QUERY-Br-Felder TTabel.Flag_1
- &Scoped-define ENABLED-TABLES-IN-QUERY-Br-Felder TTabel
- &Scoped-define FIRST-ENABLED-TABLE-IN-QUERY-Br-Felder TTabel
- &Scoped-define QUERY-STRING-Br-Felder FOR EACH TTabel NO-LOCK ~
- BY TTabel.Bez1 INDEXED-REPOSITION
- &Scoped-define OPEN-QUERY-Br-Felder OPEN QUERY Br-Felder FOR EACH TTabel NO-LOCK ~
- BY TTabel.Bez1 INDEXED-REPOSITION.
- &Scoped-define TABLES-IN-QUERY-Br-Felder TTabel
- &Scoped-define FIRST-TABLE-IN-QUERY-Br-Felder TTabel
- /* Definitions for DIALOG-BOX gExportfelder */
- &Scoped-define OPEN-BROWSERS-IN-QUERY-gExportfelder ~
- ~{&OPEN-QUERY-Br-Felder}
- /* Standard List Definitions */
- &Scoped-Define ENABLED-OBJECTS RECT-40 RECT-41 Br-Felder F_Dateiname ~
- Btn_OpenFile Btn_OK Btn_Cancel
- &Scoped-Define DISPLAYED-OBJECTS F_Dateiname
- /* Custom List Definitions */
- /* List-1,List-2,List-3,List-4,List-5,List-6 */
- /* _UIB-PREPROCESSOR-BLOCK-END */
- &ANALYZE-RESUME
- /* *********************** Control Definitions ********************** */
- /* Define a dialog box */
- /* Menu Definitions */
- DEFINE MENU POPUP-MENU-Br-Felder
- MENU-ITEM m_alle_ausgeben LABEL "alle ausgeben"
- MENU-ITEM m_keine_ausgeben LABEL "keine ausgeben".
- /* Definitions of the field level widgets */
- DEFINE BUTTON Btn_Cancel AUTO-END-KEY
- LABEL "&Abbrechen"
- SIZE 15 BY 1.
- DEFINE BUTTON Btn_OK
- LABEL "&Start"
- SIZE 15 BY 1.
- DEFINE BUTTON Btn_OpenFile
- IMAGE-UP FILE "grafik/select.bmp":U
- LABEL "suchen in"
- SIZE 4.4 BY 1.05 TOOLTIP "Starten neue Selektion".
- DEFINE VARIABLE F_Dateiname AS CHARACTER FORMAT "X(256)":U
- LABEL "Speichern unter"
- VIEW-AS FILL-IN NATIVE
- SIZE 40 BY 1
- BGCOLOR 15 NO-UNDO.
- DEFINE RECTANGLE RECT-40
- EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
- SIZE 80 BY 10.95.
- DEFINE RECTANGLE RECT-41
- EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
- SIZE 80 BY 2.
- /* Query definitions */
- &ANALYZE-SUSPEND
- DEFINE QUERY Br-Felder FOR
- TTabel
- FIELDS(TTabel.Bez1
- TTabel.Flag_1
- TTabel.Bez2) SCROLLING.
- &ANALYZE-RESUME
- /* Browse definitions */
- DEFINE BROWSE Br-Felder
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS Br-Felder gExportfelder _STRUCTURED
- QUERY Br-Felder NO-LOCK DISPLAY
- TTabel.Bez1 COLUMN-LABEL "Feld" FORMAT "x(30)":U
- TTabel.Flag_1 COLUMN-LABEL "Ausgeben" FORMAT "Ja/Nein":U
- COLUMN-FONT 6
- TTabel.Bez2 COLUMN-LABEL "Variablenname" FORMAT "x(30)":U
- ENABLE
- TTabel.Flag_1
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- WITH NO-ROW-MARKERS SEPARATORS SIZE 76 BY 10
- BGCOLOR 15 TOOLTIP "mit rechtes Maustaste zur Auswahl / RETURN -> ändern".
- /* ************************ Frame Definitions *********************** */
- DEFINE FRAME gExportfelder
- Br-Felder AT ROW 1.95 COL 5
- F_Dateiname AT ROW 13.38 COL 32.6 COLON-ALIGNED
- Btn_OpenFile AT ROW 13.38 COL 76 NO-TAB-STOP
- Btn_OK AT ROW 15.52 COL 24.6
- Btn_Cancel AT ROW 15.52 COL 48.8
- RECT-40 AT ROW 1.48 COL 3
- RECT-41 AT ROW 12.91 COL 3
- SPACE(1.99) SKIP(2.13)
- WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER
- SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE
- TITLE "Exportfelder bestimmen".
- /* *********************** Procedure Settings ************************ */
- &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
- /* Settings for THIS-PROCEDURE
- Type: SmartDialog
- Allow: Basic,Browse,DB-Fields,Query,Smart
- Container Links: Data-Target,Data-Source,Page-Target,Update-Source,Update-Target
- Design Page: 1
- Other Settings: COMPILE
- Temp-Tables and Buffers:
- TABLE: TTabel T "?" NO-UNDO AnaDat Tabel
- END-TABLES.
- */
- &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB gExportfelder
- /* ************************* Included-Libraries *********************** */
- {src/adm2/containr.i}
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- /* *********** Runtime Attributes and AppBuilder Settings *********** */
- &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
- /* SETTINGS FOR DIALOG-BOX gExportfelder
- FRAME-NAME */
- /* BROWSE-TAB Br-Felder RECT-41 gExportfelder */
- ASSIGN
- FRAME gExportfelder:SCROLLABLE = FALSE
- FRAME gExportfelder:HIDDEN = TRUE.
- ASSIGN
- Br-Felder:POPUP-MENU IN FRAME gExportfelder = MENU POPUP-MENU-Br-Felder:HANDLE.
- /* _RUN-TIME-ATTRIBUTES-END */
- &ANALYZE-RESUME
- /* Setting information for Queries and Browse Widgets fields */
- &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE Br-Felder
- /* Query rebuild information for BROWSE Br-Felder
- _TblList = "Temp-Tables.TTabel"
- _Options = "NO-LOCK INDEXED-REPOSITION"
- _TblOptList = "USED"
- _OrdList = "Temp-Tables.TTabel.Bez1|yes"
- _FldNameList[1] > Temp-Tables.TTabel.Bez1
- "Bez1" "Feld" ? "character" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
- _FldNameList[2] > Temp-Tables.TTabel.Flag_1
- "Flag_1" "Ausgeben" "Ja/Nein" "logical" ? ? 6 ? ? ? yes ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
- _FldNameList[3] > Temp-Tables.TTabel.Bez2
- "Bez2" "Variablenname" ? "character" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
- _Query is OPENED
- */ /* BROWSE Br-Felder */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gExportfelder
- /* Query rebuild information for DIALOG-BOX gExportfelder
- _Options = "SHARE-LOCK"
- _Query is NOT OPENED
- */ /* DIALOG-BOX gExportfelder */
- &ANALYZE-RESUME
-
- /* ************************ Control Triggers ************************ */
- &Scoped-define SELF-NAME gExportfelder
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gExportfelder gExportfelder
- ON END-ERROR OF FRAME gExportfelder /* Exportfelder bestimmen */
- DO:
- RUN ENDE.
- RETURN NO-APPLY.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gExportfelder gExportfelder
- ON GO OF FRAME gExportfelder /* Exportfelder bestimmen */
- DO:
- /*
- RUN ENDE_PROGRAMM ( INPUT Progname ) NO-ERROR.
- */
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gExportfelder gExportfelder
- ON WINDOW-CLOSE OF FRAME gExportfelder /* Exportfelder bestimmen */
- DO:
- RUN ENDE.
- RETURN NO-APPLY.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &Scoped-define BROWSE-NAME Br-Felder
- &Scoped-define SELF-NAME Br-Felder
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br-Felder gExportfelder
- ON LEFT-MOUSE-DBLCLICK OF Br-Felder IN FRAME gExportfelder
- DO:
- DO WITH FRAME {&FRAME-NAME}:
- FEntry = FALSE.
- APPLY 'ENTRY' TO Btn_OK.
- {&BROWSE-NAME}:READ-ONLY = FALSE.
- APPLY 'ENTRY' TO TTabel.Flag_1 IN BROWSE {&BROWSE-NAME}.
- FEntry = TRUE.
- END.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br-Felder gExportfelder
- ON RETURN OF Br-Felder IN FRAME gExportfelder
- DO:
- DO WITH FRAME {&FRAME-NAME}:
- FEntry = FALSE.
- APPLY 'ENTRY' TO Btn_OK.
- {&BROWSE-NAME}:READ-ONLY = FALSE.
- APPLY 'ENTRY' TO TTabel.Flag_1 IN BROWSE {&BROWSE-NAME}.
- FEntry = TRUE.
- END.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &Scoped-define SELF-NAME TTabel.Flag_1
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL TTabel.Flag_1 Br-Felder _BROWSE-COLUMN gExportfelder
- ON END-ERROR OF TTabel.Flag_1 IN BROWSE Br-Felder /* Ausgeben */
- DO:
- DO WITH FRAME {&FRAME-NAME}:
- APPLY 'ENTRY' TO Btn_OpenFile.
- {&BROWSE-NAME}:READ-ONLY = TRUE.
- APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
- RETURN NO-APPLY.
- END.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL TTabel.Flag_1 Br-Felder _BROWSE-COLUMN gExportfelder
- ON RETURN OF TTabel.Flag_1 IN BROWSE Br-Felder /* Ausgeben */
- DO:
- APPLY 'TAB' TO SELF.
- RETURN NO-APPLY.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &Scoped-define SELF-NAME TTabel.Bez2
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL TTabel.Bez2 Br-Felder _BROWSE-COLUMN gExportfelder
- ON END-ERROR OF TTabel.Bez2 IN BROWSE Br-Felder /* Variablenname */
- DO:
- DO WITH FRAME {&FRAME-NAME}:
- APPLY 'ENTRY' TO Btn_OpenFile.
- {&BROWSE-NAME}:READ-ONLY = TRUE.
- APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
- RETURN NO-APPLY.
- END.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL TTabel.Bez2 Br-Felder _BROWSE-COLUMN gExportfelder
- ON RETURN OF TTabel.Bez2 IN BROWSE Br-Felder /* Variablenname */
- DO:
- APPLY 'TAB' TO SELF.
- RETURN NO-APPLY.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &Scoped-define SELF-NAME Btn_Cancel
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Cancel gExportfelder
- ON CHOOSE OF Btn_Cancel IN FRAME gExportfelder /* Abbrechen */
- DO:
- RUN ENDE.
- RETURN NO-APPLY.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &Scoped-define SELF-NAME Btn_OK
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_OK gExportfelder
- ON CHOOSE OF Btn_OK IN FRAME gExportfelder /* Start */
- DO:
- APPLY 'ENTRY' TO Btn_OpenFile.
- RUN SCHREIBEN_FELDER.
- IF RETURN-VALUE <> '' THEN RETURN NO-APPLY.
- opExport = TRUE.
- RUN ENDE.
- RETURN NO-APPLY.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &Scoped-define SELF-NAME Btn_OpenFile
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_OpenFile gExportfelder
- ON CHOOSE OF Btn_OpenFile IN FRAME gExportfelder /* suchen in */
- DO:
- RUN OPEN_DATEI.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &Scoped-define SELF-NAME m_alle_ausgeben
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL m_alle_ausgeben gExportfelder
- ON CHOOSE OF MENU-ITEM m_alle_ausgeben /* alle ausgeben */
- DO:
- DO WITH FRAME {&FRAME-NAME}:
- APPLY 'ENTRY' TO Btn_OpenFile.
- REPEAT TRANSACTION:
- FOR EACH BTabel:
- BTabel.Flag_1 = TRUE.
- BROWSE {&BROWSE-NAME}:REFRESH().
- END.
- LEAVE.
- END.
- APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
- END.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &Scoped-define SELF-NAME m_keine_ausgeben
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL m_keine_ausgeben gExportfelder
- ON CHOOSE OF MENU-ITEM m_keine_ausgeben /* keine ausgeben */
- DO:
- DO WITH FRAME {&FRAME-NAME}:
- APPLY 'ENTRY' TO Btn_OpenFile.
- REPEAT TRANSACTION:
- FOR EACH BTabel:
- BTabel.Flag_1 = FALSE.
- BROWSE {&BROWSE-NAME}:REFRESH().
- END.
- LEAVE.
- END.
- APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
- END.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &UNDEFINE SELF-NAME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gExportfelder
- /* *************************** Main Block *************************** */
- MaxPage = 1.
- AktSeite = 1.
- opExport = FALSE.
- FEntry = TRUE.
- sAktiv = DYNAMIC-FUNCTION('getSuperAktiv':U) NO-ERROR.
- IF sAktiv THEN DO:
- Firma = DYNAMIC-FUNCTION('GETMANDANT':U ) NO-ERROR.
- AdFirma = DYNAMIC-FUNCTION('GETADMANDANT':U ) NO-ERROR.
- ProgName = DYNAMIC-FUNCTION('MAKEPROGNAME':U, INPUT THIS-PROCEDURE ) NO-ERROR.
- END.
- RUN EINLESEN_FELDER.
- SESSION:DATA-ENTRY-RETURN = TRUE.
- /* TRIGGERS ------------------------------------------------------ */
- ON 'ENTRY':U OF FRAME {&FRAME-NAME} ANYWHERE
- DO:
- IF NOT FEntry THEN RETURN.
- RUN ENTRY_FELD_TEST ( INPUT SELF:HANDLE ).
- IF RETURN-VALUE = 'ERROR' THEN DO:
- APPLY 'ENTRY' TO SELF.
- RETURN NO-APPLY.
- END.
- IF RETURN-VALUE = 'APPLY' THEN DO:
- RETURN NO-APPLY.
- END.
- END.
- ON 'END-ERROR':U OF FRAME {&FRAME-NAME} ANYWHERE
- DO:
- RUN ENDE.
- RETURN NO-APPLY.
- END.
-
- /* ------------------------------------------------------------------ */
- {src/adm2/dialogmn.i}
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- /* ********************** Internal Procedures *********************** */
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects gExportfelder _ADM-CREATE-OBJECTS
- PROCEDURE adm-create-objects :
- /*------------------------------------------------------------------------------
- Purpose: Create handles for all SmartObjects used in this procedure.
- After SmartObjects are initialized, then SmartLinks are added.
- Parameters: <none>
- ------------------------------------------------------------------------------*/
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE changePage gExportfelder
- PROCEDURE changePage :
- /*------------------------------------------------------------------------------
- Purpose: Super Override
- Parameters:
- Notes:
- ------------------------------------------------------------------------------*/
- /* Code placed here will execute PRIOR to standard behavior. */
- RUN SUPER.
- AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
- CASE AktSeite:
- WHEN 1 THEN DO:
- /* RUN addLink ( h_dyntoolbar , 'TableIO':U , h_v-auftr ). */
- /* RUN addLink ( h_dyntoolbar , 'Navigation':U , h_d-auftr ). */
- /* RUN ToolbarInit ( INPUT h_d-auftr ). */
- RUN ENTRY_CURSOR.
- END.
- WHEN 2 THEN DO:
- RUN ENTRY_CURSOR.
- END.
- END CASE.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI gExportfelder _DEFAULT-DISABLE
- PROCEDURE disable_UI :
- /*------------------------------------------------------------------------------
- Purpose: DISABLE the User Interface
- Parameters: <none>
- Notes: Here we clean-up the user-interface by deleting
- dynamic widgets we have created and/or hide
- frames. This procedure is usually called when
- we are ready to "clean-up" after running.
- ------------------------------------------------------------------------------*/
- /* Hide all frames. */
- HIDE FRAME gExportfelder.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE EINLESEN_FELDER gExportfelder
- PROCEDURE EINLESEN_FELDER :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEF VAR cFelder AS CHAR NO-UNDO.
- DEF VAR cInhalt AS CHAR NO-UNDO.
- DEF VAR cSection AS CHAR NO-UNDO.
- DEF VAR cKey AS CHAR NO-UNDO.
- DEF VAR cValue AS CHAR NO-UNDO.
- DEF VAR i1 AS INT NO-UNDO.
- DEF VAR ja AS LOG NO-UNDO.
- EMPTY TEMP-TABLE TTabel.
- cSection = 'Adressexport'.
- GET-KEY-VALUE SECTION cSection KEY ? VALUE cFelder.
- IF cFelder = ? THEN cFelder = ''.
- IF cFelder = '?' THEN cFelder = ''.
- IF cFelder = '' THEN RUN SCHREIBEN_ADRESSFELDER.
- DO i1 = 1 TO NUM-ENTRIES(cFelder, ','):
- cKey = ENTRY(i1, cFelder, ',').
- GET-KEY-VALUE SECTION cSection KEY cKey VALUE cValue.
- IF ENTRY(1, cValue, ';') = '0' THEN ja = FALSE.
- ELSE ja = TRUE.
- CREATE TTabel.
- ASSIGN TTabel.CodeI = i1
- TTabel.Bez1 = cKey
- TTabel.Flag_1 = ja
- TTabel.Bez2 = ENTRY(2, cValue, ';').
- END.
- GET-KEY-VALUE SECTION 'Dateinamen' KEY 'Adressexport' VALUE F_Dateiname.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gExportfelder
- PROCEDURE enableObject :
- /*------------------------------------------------------------------------------
- Purpose: Super Override
- Parameters:
- Notes:
- ------------------------------------------------------------------------------*/
- DEF VAR wx AS INT NO-UNDO.
- DEF VAR wy AS INT NO-UNDO.
- DEF VAR MaxX AS INT NO-UNDO.
- DEF VAR MaxY AS INT NO-UNDO.
- DEF VAR xString AS CHAR NO-UNDO.
- MaxX = SESSION:WIDTH-PIXELS.
- MaxY = SESSION:HEIGHT-PIXELS.
- GET-KEY-VALUE SECTION 'FensterPositionen'
- KEY ProgName
- VALUE xString.
- IF xString = ? THEN xString = '30;30'.
- IF xString = '' THEN xString = '30;30'.
- wx = INTEGER(ENTRY(1, xString, ';')).
- wy = INTEGER(ENTRY(2, xString, ';')).
- IF wx < 0 THEN wx = 30.
- IF wy < 0 THEN wy = 30.
- IF wx > (MaxX - 20) THEN wx = 30.
- IF wy > (MaxY - 20) THEN wy = 30.
-
- FRAME {&FRAME-NAME}:X = wx.
- FRAME {&FRAME-NAME}:Y = wy.
- RUN SUPER.
- IF sAktiv THEN RUN FENSTER_TITEL ( INPUT FRAME {&FRAME-NAME}:HANDLE ) NO-ERROR.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gExportfelder _DEFAULT-ENABLE
- PROCEDURE enable_UI :
- /*------------------------------------------------------------------------------
- Purpose: ENABLE the User Interface
- Parameters: <none>
- Notes: Here we display/view/enable the widgets in the
- user-interface. In addition, OPEN all queries
- associated with each FRAME and BROWSE.
- These statements here are based on the "Other
- Settings" section of the widget Property Sheets.
- ------------------------------------------------------------------------------*/
- DISPLAY F_Dateiname
- WITH FRAME gExportfelder.
- ENABLE RECT-40 RECT-41 Br-Felder F_Dateiname Btn_OpenFile Btn_OK Btn_Cancel
- WITH FRAME gExportfelder.
- VIEW FRAME gExportfelder.
- {&OPEN-BROWSERS-IN-QUERY-gExportfelder}
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gExportfelder
- PROCEDURE ENDE :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEF VAR wx AS INT NO-UNDO.
- DEF VAR wy AS INT NO-UNDO.
- DEF VAR xString AS CHAR NO-UNDO.
- AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U) NO-ERROR.
- IF AktSeite > 1 THEN DO:
- RUN selectPage ( INPUT 1 ).
- RETURN NO-APPLY.
- END.
- IF sAktiv THEN RUN ENDE_PROGRAMM ( INPUT Progname ).
- wx = FRAME {&FRAME-NAME}:X NO-ERROR.
- wy = FRAME {&FRAME-NAME}:Y NO-ERROR.
- xString = STRING(wx) + ';' + STRING(wy).
- PUT-KEY-VALUE SECTION 'FensterPositionen'
- KEY ProgName
- VALUE xString.
- APPLY 'CLOSE':U TO THIS-PROCEDURE.
- APPLY 'GO' TO FRAME {&FRAME-NAME}.
- RETURN NO-APPLY.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_FELD_TEST gExportfelder
- PROCEDURE ENTRY_FELD_TEST :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEF INPUT PARAMETER ipHandle AS HANDLE NO-UNDO.
- DEF VAR FeldName AS CHAR NO-UNDO.
- DEF VAR FeldInhalt AS CHAR NO-UNDO.
- FeldName = ''.
- FeldInhalt = ''.
- IF NOT VALID-HANDLE(ipHandle) THEN RETURN ''.
- IF ipHandle:TYPE = 'FRAME' THEN RETURN ''.
- IF ipHandle:TYPE = 'WINDOW' THEN RETURN ''.
- FeldName = ipHandle:NAME.
-
- DO WITH FRAME {&FRAME-NAME}:
- CASE FeldName:
- WHEN 'Flag_1' THEN RETURN ''.
- WHEN 'Bez2' THEN RETURN ''.
- OTHERWISE DO:
- FEntry = FALSE.
- APPLY 'ENTRY' TO Btn_OpenFile.
- {&BROWSE-NAME}:READ-ONLY = TRUE.
- APPLY 'ENTRY' TO ipHandle.
- FEntry = TRUE.
- END.
- END CASE.
- END.
- RETURN ''.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE exitObject gExportfelder
- PROCEDURE exitObject :
- /*------------------------------------------------------------------------------
- Purpose: Super Override
- Parameters:
- Notes:
- ------------------------------------------------------------------------------*/
- RUN ENDE.
- RETURN NO-APPLY.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject gExportfelder
- PROCEDURE initializeObject :
- /*------------------------------------------------------------------------------
- Purpose: Super Override
- Parameters:
- Notes:
- ------------------------------------------------------------------------------*/
- RUN SUPER.
- DO WITH FRAME {&FRAME-NAME}:
- APPLY 'ENTRY' TO Btn_OK.
- {&BROWSE-NAME}:READ-ONLY = TRUE.
- APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
- END.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE OPEN_DATEI gExportfelder
- PROCEDURE OPEN_DATEI :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEF VAR ja AS LOG NO-UNDO.
- DO WITH FRAME {&FRAME-NAME}:
- F_Dateiname = F_Dateiname:SCREEN-VALUE.
- SYSTEM-DIALOG GET-FILE F_Dateiname
- FILTERS 'Textdatei' '*.txt',
- 'csv - Datei' '*.csv',
- 'Exceldatei' '*.xls',
- 'alle Dateien' '*.*'
- INITIAL-FILTER 1
- CREATE-TEST-FILE
- DEFAULT-EXTENSION '.txt'
- TITLE 'Export der Daten in ....'
- USE-FILENAME
- UPDATE ja.
- IF Ja THEN DO:
- F_DateiName:SCREEN-VALUE = F_Dateiname.
- END.
- END.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SCHREIBEN_ADRESSFELDER gExportfelder
- PROCEDURE SCHREIBEN_ADRESSFELDER :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEF VAR hBuf AS WIDGET-HANDLE NO-UNDO.
- DEF VAR hFeld AS WIDGET-HANDLE NO-UNDO.
- DEF VAR cInhalt AS CHAR NO-UNDO.
- DEF VAR cKey AS CHAR NO-UNDO.
- DEF VAR cValue AS CHAR NO-UNDO.
- DEF VAR i1 AS INT NO-UNDO.
- DEF VAR i2 AS INT NO-UNDO.
- GET-KEY-VALUE SECTION 'Adressexport' KEY ? VALUE cInhalt.
- IF cInhalt <> '?' AND
- cInhalt <> ? AND
- cInhalt <> '' THEN RETURN.
- hBuf = BUFFER Adresse:HANDLE.
- i2 = hBuf:NUM-FIELDS.
- DO i1 = 1 TO i2:
- hFeld = hBuf:BUFFER-FIELD(i1) NO-ERROR.
- cInhalt = '1;'.
- IF hFeld:LABEL = ? THEN cInhalt = cInhalt + hFeld:NAME.
- ELSE cInhalt = cInhalt + hFeld:LABEL.
- PUT-KEY-VALUE SECTION 'Adressexport' KEY hFeld:NAME VALUE cInhalt.
- END.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SCHREIBEN_FELDER gExportfelder
- PROCEDURE SCHREIBEN_FELDER :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEF VAR cSection AS CHAR NO-UNDO.
- DEF VAR cKey AS CHAR NO-UNDO.
- DEF VAR cValue AS CHAR NO-UNDO.
- cSection = 'Adressexport'.
- FOR EACH BTabel BY BTabel.Bez1:
- cKey = BTabel.Bez1.
- IF BTabel.Flag_1 THEN cValue = '1;' + BTabel.Bez2.
- ELSE cValue = '0;' + BTabel.Bez2.
- PUT-KEY-VALUE SECTION cSection KEY cKey VALUE cValue.
- END.
- F_Dateiname = F_Dateiname:SCREEN-VALUE IN FRAME {&FRAME-NAME}.
- REPEAT ON ERROR UNDO, RETRY:
- IF F_Dateiname = ? THEN F_Dateiname = ''.
- IF F_Dateiname = '?' THEN F_Dateiname = ''.
- IF F_Dateiname = '' THEN LEAVE.
- IF RETRY THEN DO WITH FRAME {&FRAME-NAME}:
- APPLY 'ENTRY' TO F_Dateiname.
- RETURN 'ERROR'.
- END.
- OUTPUT TO VALUE(F_Dateiname).
- LEAVE.
- END.
- OUTPUT CLOSE.
- PUT-KEY-VALUE SECTION 'Dateinamen' KEY 'Adressexport' VALUE F_Dateiname.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE selectPage gExportfelder
- PROCEDURE selectPage :
- /*------------------------------------------------------------------------------
- Purpose: Super Override
- Parameters:
- Notes:
- ------------------------------------------------------------------------------*/
- DEF INPUT PARAMETER piPageNum AS INT NO-UNDO.
- DEF VAR FMutFlag AS LOG NO-UNDO.
- DEF VAR MutProg AS CHAR NO-UNDO.
- FMutFlag = DYNAMIC-FUNCTION ('GETMUTFLAG':U, INPUT Progname) NO-ERROR.
- IF FMutFlag THEN RETURN NO-APPLY.
- CASE piPageNum:
- END CASE.
- AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U) NO-ERROR.
- CASE AktSeite:
- WHEN 1 THEN DO:
- /* RUN removeLink ( h_dyntoolbar , 'TableIO':U , h_v-auftr ). */
- /* RUN removeLink ( h_dyntoolbar , 'Navigation':U , h_d-auftr ). */
- END.
- END CASE.
- RUN SUPER( INPUT piPageNum).
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
|