&ANALYZE-SUSPEND _VERSION-NUMBER AB_v9r12 GUI ADM2 &ANALYZE-RESUME &Scoped-define WINDOW-NAME CURRENT-WINDOW &Scoped-define FRAME-NAME gKkontaktliste &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gKkontaktliste /*------------------------------------------------------------------------ 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 --- */ /* 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 SAktiv AS LOG NO-UNDO INIT FALSE. DEF VAR Firma AS CHAR NO-UNDO. DEF VAR AdFirma AS CHAR NO-UNDO. DEF VAR iLiArt AS INT NO-UNDO. DEF VAR iVon AS INT NO-UNDO. DEF VAR iBis AS INT NO-UNDO. DEF VAR cVon AS CHAR NO-UNDO. DEF VAR cBis AS CHAR NO-UNDO. DEF BUFFER BAdresse FOR Adresse. DEF TEMP-TABLE TAdresse LIKE Adresse FIELD xSort AS CHAR FIELD iInd AS INT INDEX TAdresse-k1 IS PRIMARY XSort Knr iInd. /* _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 first Frame and/or Browse and/or first Query */ &Scoped-define FRAME-NAME gKkontaktliste /* Standard List Definitions */ &Scoped-Define ENABLED-OBJECTS F_Fe01 F_Fe02 F_Fe03 F_Fe04 F_Fe05 F_Fe06 ~ F_Fe07 F_Fe08 F_Fe09 F_Fe10 F_Fe11 F_Fe12 F_Fe13 F_Fe14 F_Fe15 Btn_Excel ~ Btn_Cancel RECT-39 &Scoped-Define DISPLAYED-OBJECTS F_Fe01 F_Fe02 F_Fe03 F_Fe04 F_Fe05 F_Fe06 ~ F_Fe07 F_Fe08 F_Fe09 F_Fe10 F_Fe11 F_Fe12 F_Fe13 F_Fe14 F_Fe15 /* Custom List Definitions */ /* List-1,List-2,List-3,List-4,List-5,List-6 */ &Scoped-define List-5 Btn_Excel &Scoped-define List-6 F_Fe01 F_Fe02 F_Fe03 F_Fe04 F_Fe05 F_Fe06 F_Fe07 ~ F_Fe08 F_Fe09 F_Fe10 F_Fe11 F_Fe12 F_Fe13 F_Fe14 F_Fe15 /* _UIB-PREPROCESSOR-BLOCK-END */ &ANALYZE-RESUME /* *********************** Control Definitions ********************** */ /* Define a dialog box */ /* Definitions of the field level widgets */ DEFINE BUTTON Btn_Cancel AUTO-END-KEY LABEL "&Abbrechen" SIZE 16 BY 1. DEFINE BUTTON Btn_Excel IMAGE-UP FILE "grafik/results%.ico":U IMAGE-INSENSITIVE FILE "grafik/results%.ico":U LABEL "Excel" SIZE 7 BY 1.81. DEFINE VARIABLE F_Cd01 AS CHARACTER FORMAT "x(05)":U VIEW-AS FILL-IN SIZE 8 BY 1 NO-UNDO. DEFINE VARIABLE F_Cd02 AS CHARACTER FORMAT "x(05)":U VIEW-AS FILL-IN SIZE 8 BY 1 NO-UNDO. DEFINE VARIABLE F_Cd03 AS CHARACTER FORMAT "x(05)":U VIEW-AS FILL-IN SIZE 8 BY 1 NO-UNDO. DEFINE VARIABLE F_Cd04 AS CHARACTER FORMAT "x(05)":U VIEW-AS FILL-IN SIZE 8 BY 1 NO-UNDO. DEFINE VARIABLE F_Cd05 AS CHARACTER FORMAT "x(05)":U VIEW-AS FILL-IN SIZE 8 BY 1 NO-UNDO. DEFINE VARIABLE F_Cd06 AS CHARACTER FORMAT "x(05)":U VIEW-AS FILL-IN SIZE 8 BY 1 NO-UNDO. DEFINE VARIABLE F_Cd07 AS CHARACTER FORMAT "x(05)":U VIEW-AS FILL-IN SIZE 8 BY 1 NO-UNDO. DEFINE VARIABLE F_Cd08 AS CHARACTER FORMAT "x(05)":U VIEW-AS FILL-IN SIZE 8 BY 1 NO-UNDO. DEFINE VARIABLE F_Cd09 AS CHARACTER FORMAT "x(05)":U VIEW-AS FILL-IN SIZE 8 BY 1 NO-UNDO. DEFINE VARIABLE F_Cd10 AS CHARACTER FORMAT "x(05)":U VIEW-AS FILL-IN SIZE 8 BY 1 NO-UNDO. DEFINE VARIABLE F_Cd11 AS CHARACTER FORMAT "x(05)":U VIEW-AS FILL-IN SIZE 8 BY 1 NO-UNDO. DEFINE VARIABLE F_Cd12 AS CHARACTER FORMAT "x(05)":U VIEW-AS FILL-IN SIZE 8 BY 1 NO-UNDO. DEFINE VARIABLE F_Cd13 AS CHARACTER FORMAT "x(05)":U VIEW-AS FILL-IN SIZE 8 BY 1 NO-UNDO. DEFINE VARIABLE F_Cd14 AS CHARACTER FORMAT "x(05)":U VIEW-AS FILL-IN SIZE 8 BY 1 NO-UNDO. DEFINE VARIABLE F_Cd15 AS CHARACTER FORMAT "x(05)":U VIEW-AS FILL-IN SIZE 8 BY 1 NO-UNDO. DEFINE VARIABLE F_Fe01 AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Fe02 AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Fe03 AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Fe04 AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Fe05 AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Fe06 AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Fe07 AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Fe08 AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Fe09 AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Fe10 AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Fe11 AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Fe12 AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Fe13 AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Fe14 AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Fe15 AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE RECTANGLE RECT-39 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 124 BY 3. /* ************************ Frame Definitions *********************** */ DEFINE FRAME gKkontaktliste F_Fe01 AT ROW 3 COL 3 COLON-ALIGNED NO-LABEL F_Fe02 AT ROW 3 COL 11 COLON-ALIGNED NO-LABEL F_Fe03 AT ROW 3 COL 19 COLON-ALIGNED NO-LABEL F_Fe04 AT ROW 3 COL 27 COLON-ALIGNED NO-LABEL F_Cd01 AT ROW 2 COL 3 COLON-ALIGNED NO-LABEL NO-TAB-STOP F_Fe05 AT ROW 3 COL 35 COLON-ALIGNED NO-LABEL F_Fe06 AT ROW 3 COL 43 COLON-ALIGNED NO-LABEL F_Cd02 AT ROW 2 COL 11 COLON-ALIGNED NO-LABEL NO-TAB-STOP F_Fe07 AT ROW 3 COL 51 COLON-ALIGNED NO-LABEL F_Cd03 AT ROW 2 COL 19 COLON-ALIGNED NO-LABEL NO-TAB-STOP F_Fe08 AT ROW 3 COL 59 COLON-ALIGNED NO-LABEL F_Cd04 AT ROW 2 COL 27 COLON-ALIGNED NO-LABEL NO-TAB-STOP F_Fe09 AT ROW 3 COL 67 COLON-ALIGNED NO-LABEL F_Cd05 AT ROW 2 COL 35 COLON-ALIGNED NO-LABEL NO-TAB-STOP F_Fe10 AT ROW 3 COL 75 COLON-ALIGNED NO-LABEL F_Cd06 AT ROW 2 COL 43 COLON-ALIGNED NO-LABEL NO-TAB-STOP F_Fe11 AT ROW 3 COL 83 COLON-ALIGNED NO-LABEL F_Cd07 AT ROW 2 COL 51 COLON-ALIGNED NO-LABEL NO-TAB-STOP F_Fe12 AT ROW 3 COL 91 COLON-ALIGNED NO-LABEL F_Cd08 AT ROW 2 COL 59 COLON-ALIGNED NO-LABEL NO-TAB-STOP F_Fe13 AT ROW 3 COL 99 COLON-ALIGNED NO-LABEL F_Cd09 AT ROW 2 COL 67 COLON-ALIGNED NO-LABEL NO-TAB-STOP F_Fe14 AT ROW 3 COL 107 COLON-ALIGNED NO-LABEL F_Cd10 AT ROW 2 COL 75 COLON-ALIGNED NO-LABEL NO-TAB-STOP F_Fe15 AT ROW 3 COL 115 COLON-ALIGNED NO-LABEL F_Cd11 AT ROW 2 COL 83 COLON-ALIGNED NO-LABEL NO-TAB-STOP F_Cd12 AT ROW 2 COL 91 COLON-ALIGNED NO-LABEL NO-TAB-STOP F_Cd13 AT ROW 2 COL 99 COLON-ALIGNED NO-LABEL NO-TAB-STOP F_Cd14 AT ROW 2 COL 107 COLON-ALIGNED NO-LABEL NO-TAB-STOP Btn_Excel AT ROW 5.1 COL 116.6 F_Cd15 AT ROW 2 COL 115 COLON-ALIGNED NO-LABEL NO-TAB-STOP Btn_Cancel AT ROW 5.67 COL 5.4 RECT-39 AT ROW 1.52 COL 2 SPACE(2.19) SKIP(3.42) WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE TITLE "Kontaktliste" CANCEL-BUTTON Btn_Cancel. /* *********************** 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 */ &ANALYZE-RESUME _END-PROCEDURE-SETTINGS &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB gKkontaktliste /* ************************* 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 gKkontaktliste Custom */ ASSIGN FRAME gKkontaktliste:SCROLLABLE = FALSE FRAME gKkontaktliste:HIDDEN = TRUE. /* SETTINGS FOR BUTTON Btn_Excel IN FRAME gKkontaktliste 5 */ /* SETTINGS FOR FILL-IN F_Cd01 IN FRAME gKkontaktliste NO-DISPLAY NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Cd02 IN FRAME gKkontaktliste NO-DISPLAY NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Cd03 IN FRAME gKkontaktliste NO-DISPLAY NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Cd04 IN FRAME gKkontaktliste NO-DISPLAY NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Cd05 IN FRAME gKkontaktliste NO-DISPLAY NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Cd06 IN FRAME gKkontaktliste NO-DISPLAY NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Cd07 IN FRAME gKkontaktliste NO-DISPLAY NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Cd08 IN FRAME gKkontaktliste NO-DISPLAY NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Cd09 IN FRAME gKkontaktliste NO-DISPLAY NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Cd10 IN FRAME gKkontaktliste NO-DISPLAY NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Cd11 IN FRAME gKkontaktliste NO-DISPLAY NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Cd12 IN FRAME gKkontaktliste NO-DISPLAY NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Cd13 IN FRAME gKkontaktliste NO-DISPLAY NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Cd14 IN FRAME gKkontaktliste NO-DISPLAY NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Cd15 IN FRAME gKkontaktliste NO-DISPLAY NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Fe01 IN FRAME gKkontaktliste 6 */ /* SETTINGS FOR FILL-IN F_Fe02 IN FRAME gKkontaktliste 6 */ /* SETTINGS FOR FILL-IN F_Fe03 IN FRAME gKkontaktliste 6 */ /* SETTINGS FOR FILL-IN F_Fe04 IN FRAME gKkontaktliste 6 */ /* SETTINGS FOR FILL-IN F_Fe05 IN FRAME gKkontaktliste 6 */ /* SETTINGS FOR FILL-IN F_Fe06 IN FRAME gKkontaktliste 6 */ /* SETTINGS FOR FILL-IN F_Fe07 IN FRAME gKkontaktliste 6 */ /* SETTINGS FOR FILL-IN F_Fe08 IN FRAME gKkontaktliste 6 */ /* SETTINGS FOR FILL-IN F_Fe09 IN FRAME gKkontaktliste 6 */ /* SETTINGS FOR FILL-IN F_Fe10 IN FRAME gKkontaktliste 6 */ /* SETTINGS FOR FILL-IN F_Fe11 IN FRAME gKkontaktliste 6 */ /* SETTINGS FOR FILL-IN F_Fe12 IN FRAME gKkontaktliste 6 */ /* SETTINGS FOR FILL-IN F_Fe13 IN FRAME gKkontaktliste 6 */ /* SETTINGS FOR FILL-IN F_Fe14 IN FRAME gKkontaktliste 6 */ /* SETTINGS FOR FILL-IN F_Fe15 IN FRAME gKkontaktliste 6 */ /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* Setting information for Queries and Browse Widgets fields */ &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gKkontaktliste /* Query rebuild information for DIALOG-BOX gKkontaktliste _Options = "SHARE-LOCK" _Query is NOT OPENED */ /* DIALOG-BOX gKkontaktliste */ &ANALYZE-RESUME /* ************************ Control Triggers ************************ */ &Scoped-define SELF-NAME gKkontaktliste &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gKkontaktliste gKkontaktliste ON END-ERROR OF FRAME gKkontaktliste /* Kontaktliste */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gKkontaktliste gKkontaktliste ON GO OF FRAME gKkontaktliste /* Kontaktliste */ DO: /* RUN ENDE_PROGRAMM ( INPUT THIS-PROCEDURE:FILE-NAME ) NO-ERROR. */ END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gKkontaktliste gKkontaktliste ON WINDOW-CLOSE OF FRAME gKkontaktliste /* Kontaktliste */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME Btn_Cancel &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Cancel gKkontaktliste ON CHOOSE OF Btn_Cancel IN FRAME gKkontaktliste /* Abbrechen */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME Btn_Excel &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Excel gKkontaktliste ON CHOOSE OF Btn_Excel IN FRAME gKkontaktliste /* Excel */ DO: DISABLE Btn_Excel WITH FRAME {&FRAME-NAME}. RUN REPORT. ENABLE Btn_Excel WITH FRAME {&FRAME-NAME}. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gKkontaktliste /* *************************** Main Block *************************** */ MaxPage = 1. AktSeite = 0. SESSION:DATA-ENTRY-RETURN = 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. END. /* TRIGGERS ------------------------------------------------------ */ 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 gKkontaktliste _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 AUSGABE gKkontaktliste PROCEDURE AUSGABE : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR DateiName AS CHAR NO-UNDO. DEF VAR DatenName AS CHAR NO-UNDO. DEF VAR SteuerName AS CHAR NO-UNDO. DEF VAR TempName AS CHAR NO-UNDO. DEF VAR cParameter AS CHAR NO-UNDO. DEF VAR Zelle AS CHAR NO-UNDO. DEF VAR VZeile AS CHAR NO-UNDO. DEF VAR comAppl AS COM-HANDLE NO-UNDO. DEF VAR io AS LOG NO-UNDO. DEF VAR ix AS INT NO-UNDO. DateiName = 'Kontakt.xls'. DatenName = SESSION:TEMP-DIR + 'Kontakt.txt'. cParameter = DateiName + CHR(01) + DateiName + CHR(01). RUN CREATEDATEI ( INPUT cParameter ). DateiName = RETURN-VALUE. OUTPUT TO VALUE(DatenName). FOR EACH TAdresse NO-LOCK BY TAdresse.Cd01 BY TAdresse.Cd02 BY TAdresse.Suchbe : VZeile = ''. VZeile = TAdresse.Cd01 + '£' + TAdresse.Cd02 + '£' + STRING(TAdresse.Knr,'999999') + '£' + TAdresse.Anzeig_Br + '£'. IF TAdresse.Firma1 <> '' THEN DO: IF TAdresse.Tel-1 <> '' THEN VZeile = VZeile + 'G: ' + TAdresse.Tel-1. ELSE VZeile = VZeile + 'P: ' + TAdresse.Tel-2. END. ELSE DO: IF TAdresse.Tel-2 <> '' THEN VZeile = VZeile + 'P: ' + TAdresse.Tel-2. ELSE VZeile = VZeile + 'G: ' + TAdresse.Tel-1. END. VZeile = VZeile + '£' + TAdresse.Cd03 + '£' + TAdresse.Cd04 + '£' + TAdresse.Cd05 + '£' + TAdresse.Cd06. VZeile = VZeile + CHR(13). VZeile = REPLACE(VZeile, '"', ' '). VZeile = REPLACE(VZeile, "'", ' '). VZeile = REPLACE(VZeile, ';', ' '). PUT CONTROL VZeile. END. OUTPUT CLOSE. comAppl = DYNAMIC-FUNCTION('CREATEEXCEL':U) NO-ERROR. RUN OPENEXCEL ( INPUT comAppl, INPUT DateiName, INPUT '', OUTPUT io ). IF NOT io THEN DO: RUN FEHLER ( INPUT 1040 ). RETURN NO-APPLY. END. Zelle = 'A2'. comAppl:Range(Zelle):SELECT. comAppl:Selection:FormulaR1C1 = 'TEXT;' + DatenName. comAppl:Application:RUN ( 'DateiEinfügen' ). DYNAMIC-FUNCTION('RELEASEEXCEL':U, INPUT comAppl ) NO-ERROR. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI gKkontaktliste _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 gKkontaktliste. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gKkontaktliste PROCEDURE enableObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR Sprcd AS INT NO-UNDO. DEF VAR ix AS INT NO-UNDO. DEF VAR cFelder AS CHAR NO-UNDO. RUN SUPER. RUN FENSTER_TITEL ( INPUT FRAME {&FRAME-NAME}:HANDLE ) NO-ERROR. DO WITH FRAME {&FRAME-NAME}: Sprcd = DYNAMIC-FUNCTION('GETBENUTZERSPRCD':U) NO-ERROR. FIND Femeld WHERE Femeld.Sprcd = Sprcd AND Femeld.Fenr = 999 NO-LOCK NO-ERROR. IF AVAILABLE Femeld THEN cFelder = Femeld.Fetext. ELSE cFelder = ''. DO ix = 1 TO NUM-ENTRIES(Femeld.Fetext, ','): CASE ix: WHEN 01 THEN F_Cd01:SCREEN-VALUE = ENTRY(ix, cFelder, ','). WHEN 02 THEN F_Cd02:SCREEN-VALUE = ENTRY(ix, cFelder, ','). WHEN 03 THEN F_Cd03:SCREEN-VALUE = ENTRY(ix, cFelder, ','). WHEN 04 THEN F_Cd04:SCREEN-VALUE = ENTRY(ix, cFelder, ','). WHEN 05 THEN F_Cd05:SCREEN-VALUE = ENTRY(ix, cFelder, ','). WHEN 06 THEN F_Cd06:SCREEN-VALUE = ENTRY(ix, cFelder, ','). WHEN 07 THEN F_Cd07:SCREEN-VALUE = ENTRY(ix, cFelder, ','). WHEN 08 THEN F_Cd08:SCREEN-VALUE = ENTRY(ix, cFelder, ','). WHEN 09 THEN F_Cd09:SCREEN-VALUE = ENTRY(ix, cFelder, ','). WHEN 10 THEN F_Cd10:SCREEN-VALUE = ENTRY(ix, cFelder, ','). WHEN 11 THEN F_Cd11:SCREEN-VALUE = ENTRY(ix, cFelder, ','). WHEN 12 THEN F_Cd12:SCREEN-VALUE = ENTRY(ix, cFelder, ','). WHEN 13 THEN F_Cd13:SCREEN-VALUE = ENTRY(ix, cFelder, ','). WHEN 14 THEN F_Cd14:SCREEN-VALUE = ENTRY(ix, cFelder, ','). WHEN 15 THEN F_Cd15:SCREEN-VALUE = ENTRY(ix, cFelder, ','). END CASE. END. GET-KEY-VALUE SECTION 'Auswertungen' KEY 'Kontaktliste' VALUE cFelder. IF cFelder = ? THEN cFelder = FILL('@', 15). DO ix = 1 TO NUM-ENTRIES(cFelder, '@'). CASE ix: WHEN 1 THEN F_Fe01 = ENTRY(ix, cFelder, '@') NO-ERROR. WHEN 2 THEN F_Fe02 = ENTRY(ix, cFelder, '@') NO-ERROR. WHEN 3 THEN F_Fe03 = ENTRY(ix, cFelder, '@') NO-ERROR. WHEN 4 THEN F_Fe04 = ENTRY(ix, cFelder, '@') NO-ERROR. WHEN 5 THEN F_Fe05 = ENTRY(ix, cFelder, '@') NO-ERROR. WHEN 6 THEN F_Fe06 = ENTRY(ix, cFelder, '@') NO-ERROR. WHEN 7 THEN F_Fe07 = ENTRY(ix, cFelder, '@') NO-ERROR. WHEN 8 THEN F_Fe08 = ENTRY(ix, cFelder, '@') NO-ERROR. WHEN 9 THEN F_Fe09 = ENTRY(ix, cFelder, '@') NO-ERROR. WHEN 10 THEN F_Fe10 = ENTRY(ix, cFelder, '@') NO-ERROR. WHEN 11 THEN F_Fe11 = ENTRY(ix, cFelder, '@') NO-ERROR. WHEN 12 THEN F_Fe12 = ENTRY(ix, cFelder, '@') NO-ERROR. WHEN 13 THEN F_Fe13 = ENTRY(ix, cFelder, '@') NO-ERROR. WHEN 14 THEN F_Fe14 = ENTRY(ix, cFelder, '@') NO-ERROR. WHEN 15 THEN F_Fe15 = ENTRY(ix, cFelder, '@') NO-ERROR. END CASE. END. DISPLAY {&List-6}. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gKkontaktliste _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_Fe01 F_Fe02 F_Fe03 F_Fe04 F_Fe05 F_Fe06 F_Fe07 F_Fe08 F_Fe09 F_Fe10 F_Fe11 F_Fe12 F_Fe13 F_Fe14 F_Fe15 WITH FRAME gKkontaktliste. ENABLE F_Fe01 F_Fe02 F_Fe03 F_Fe04 F_Fe05 F_Fe06 F_Fe07 F_Fe08 F_Fe09 F_Fe10 F_Fe11 F_Fe12 F_Fe13 F_Fe14 F_Fe15 Btn_Excel Btn_Cancel RECT-39 WITH FRAME gKkontaktliste. VIEW FRAME gKkontaktliste. {&OPEN-BROWSERS-IN-QUERY-gKkontaktliste} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gKkontaktliste PROCEDURE ENDE : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ RUN ENDE_PROGRAMM ( INPUT THIS-PROCEDURE:FILE-NAME ). APPLY 'GO' TO FRAME {&FRAME-NAME}. RETURN NO-APPLY. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE exitObject gKkontaktliste 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 REPORT gKkontaktliste PROCEDURE REPORT : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR cFelder AS CHAR NO-UNDO. DO WITH FRAME {&FRAME-NAME}: ASSIGN {&List-6}. cFelder = F_Fe01 + '@' + F_Fe02 + '@' + F_Fe03 + '@' + F_Fe04 + '@' + F_Fe05 + '@' + F_Fe06 + '@' + F_Fe07 + '@' + F_Fe08 + '@' + F_Fe09 + '@' + F_Fe10 + '@' + F_Fe11 + '@' + F_Fe12 + '@' + F_Fe13 + '@' + F_Fe14 + '@' + F_Fe15. PUT-KEY-VALUE SECTION 'Auswertungen' KEY 'Kontaktliste' VALUE cFelder. Btn_Excel:HIDDEN = FALSE. Btn_Cancel:HIDDEN = FALSE. SESSION:SET-WAIT-STATE('GENERAL'). RUN SELEKTION. RUN AUSGABE. SESSION:SET-WAIT-STATE(''). Btn_Excel:HIDDEN = TRUE. Btn_Cancel:HIDDEN = TRUE. RUN ENDE. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SELEKTION gKkontaktliste PROCEDURE SELEKTION : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ FOR EACH TAdresse: DELETE TAdresse. END. FOR EACH BAdresse USE-INDEX Adresse-k1 WHERE BAdresse.Firma = AdFirma AND BAdresse.Aktiv = TRUE NO-LOCK: IF F_Fe01 <> '' AND LOOKUP(BAdresse.Cd01, F_Fe01, ',') = 0 THEN NEXT. IF F_Fe02 <> '' AND LOOKUP(BAdresse.Cd02, F_Fe02, ',') = 0 THEN NEXT. IF F_Fe03 <> '' AND LOOKUP(BAdresse.Cd03, F_Fe03, ',') = 0 THEN NEXT. IF F_Fe04 <> '' AND LOOKUP(BAdresse.Cd04, F_Fe04, ',') = 0 THEN NEXT. IF F_Fe05 <> '' AND LOOKUP(BAdresse.Cd05, F_Fe05, ',') = 0 THEN NEXT. IF F_Fe06 <> '' AND LOOKUP(BAdresse.Cd06, F_Fe06, ',') = 0 THEN NEXT. IF F_Fe07 <> '' AND LOOKUP(BAdresse.Cd07, F_Fe07, ',') = 0 THEN NEXT. IF F_Fe08 <> '' AND LOOKUP(BAdresse.Cd08, F_Fe08, ',') = 0 THEN NEXT. IF F_Fe09 <> '' AND LOOKUP(BAdresse.Cd09, F_Fe09, ',') = 0 THEN NEXT. IF F_Fe10 <> '' AND LOOKUP(BAdresse.Cd10, F_Fe10, ',') = 0 THEN NEXT. IF F_Fe11 <> '' AND LOOKUP(BAdresse.Cd11, F_Fe11, ',') = 0 THEN NEXT. IF F_Fe12 <> '' AND LOOKUP(BAdresse.Cd12, F_Fe12, ',') = 0 THEN NEXT. IF F_Fe13 <> '' AND LOOKUP(BAdresse.Cd13, F_Fe13, ',') = 0 THEN NEXT. IF F_Fe14 <> '' AND LOOKUP(BAdresse.Cd14, F_Fe14, ',') = 0 THEN NEXT. IF F_Fe15 <> '' AND LOOKUP(BAdresse.Cd15, F_Fe15, ',') = 0 THEN NEXT. CREATE TAdresse. BUFFER-COPY BAdresse TO TAdresse. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME