&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: Output Parameters: 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: ------------------------------------------------------------------------------*/ 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: 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: 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: 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: 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: 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: 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: 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: 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