GeMIS_WEB/GUI/g-auswahl-tabelle.w

&ANALYZE-SUSPEND _VERSION-NUMBER AB_v9r12 GUI ADM2
&ANALYZE-RESUME
/* Connected Databases 
          anadat           PROGRESS
*/
&Scoped-define WINDOW-NAME CURRENT-WINDOW
&Scoped-define FRAME-NAME gAuswahl
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gAuswahl 
/*------------------------------------------------------------------------

  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 INPUT PARAMETER ipFeld      AS HANDLE               NO-UNDO.
DEF INPUT PARAMETER ipArt       AS CHAR                 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 FeldInhalt      AS CHAR                     NO-UNDO.
DEF VAR RecArt          AS CHAR                     NO-UNDO.
DEF VAR Firma           AS CHAR                     NO-UNDO.
DEF VAR Art             AS INT                      NO-UNDO.
DEF VAR Suchen          AS INT                      NO-UNDO.

DEF BUFFER BTabel       FOR Tabel.

/* _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 gAuswahl
&Scoped-define BROWSE-NAME select-next-roeBr_Tabelle

/* Internal Tables (found by Frame, Query & Browse Queries)             */
&Scoped-define INTERNAL-TABLES Tabel

/* Definitions for BROWSE select-next-roeBr_Tabelle                     */
&Scoped-define FIELDS-IN-QUERY-select-next-roeBr_Tabelle Tabel.CodeI ~
Tabel.CodeC Tabel.Bez1 
&Scoped-define ENABLED-FIELDS-IN-QUERY-select-next-roeBr_Tabelle 
&Scoped-define OPEN-QUERY-select-next-roeBr_Tabelle OPEN QUERY select-next-roeBr_Tabelle FOR EACH Tabel NO-LOCK INDEXED-REPOSITION.
&Scoped-define TABLES-IN-QUERY-select-next-roeBr_Tabelle Tabel
&Scoped-define FIRST-TABLE-IN-QUERY-select-next-roeBr_Tabelle Tabel


/* Definitions for DIALOG-BOX gAuswahl                                  */

/* Standard List Definitions                                            */
&Scoped-Define ENABLED-OBJECTS select-next-roeBr_Tabelle RECT-38 

/* 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                                                  */

/* Definitions of the field level widgets                               */
DEFINE RECTANGLE RECT-38
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL 
     SIZE 48 BY 8.1.

/* Query definitions                                                    */
&ANALYZE-SUSPEND
DEFINE QUERY select-next-roeBr_Tabelle FOR 
      Tabel SCROLLING.
&ANALYZE-RESUME

/* Browse definitions                                                   */
DEFINE BROWSE select-next-roeBr_Tabelle
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS select-next-roeBr_Tabelle gAuswahl _STRUCTURED
  QUERY select-next-roeBr_Tabelle NO-LOCK DISPLAY
      Tabel.CodeI COLUMN-LABEL "Code" FORMAT "999":U WIDTH 8
      Tabel.CodeC COLUMN-LABEL "Code" FORMAT "x(8)":U
      Tabel.Bez1 COLUMN-LABEL "Beschreibung" FORMAT "x(30)":U
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
    WITH NO-ROW-MARKERS SEPARATORS MULTIPLE SIZE 44 BY 7.14
         BGCOLOR 15 .


/* ************************  Frame Definitions  *********************** */

DEFINE FRAME gAuswahl
     select-next-roeBr_Tabelle AT ROW 1.95 COL 5
     RECT-38 AT ROW 1.48 COL 3
     SPACE(1.99) SKIP(0.22)
    WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER 
         SIDE-LABELS NO-UNDERLINE THREE-D  SCROLLABLE 
         TITLE "Auswahl aus Tabelle".


/* *********************** 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 gAuswahl 
/* ************************* 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 gAuswahl
                                                                        */
/* BROWSE-TAB select-next-roeBr_Tabelle 1 gAuswahl */
ASSIGN 
       FRAME gAuswahl:SCROLLABLE       = FALSE
       FRAME gAuswahl:HIDDEN           = TRUE.

ASSIGN 
       select-next-roeBr_Tabelle:ALLOW-COLUMN-SEARCHING IN FRAME gAuswahl = TRUE
       select-next-roeBr_Tabelle:COLUMN-RESIZABLE IN FRAME gAuswahl       = TRUE.

ASSIGN 
       Tabel.CodeI:VISIBLE IN BROWSE select-next-roeBr_Tabelle = FALSE
       Tabel.CodeC:VISIBLE IN BROWSE select-next-roeBr_Tabelle = FALSE.

/* _RUN-TIME-ATTRIBUTES-END */
&ANALYZE-RESUME


/* Setting information for Queries and Browse Widgets fields            */

&ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gAuswahl
/* Query rebuild information for DIALOG-BOX gAuswahl
     _Options          = "SHARE-LOCK"
     _Query            is NOT OPENED
*/  /* DIALOG-BOX gAuswahl */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _QUERY-BLOCK BROWSE select-next-roeBr_Tabelle
/* Query rebuild information for BROWSE select-next-roeBr_Tabelle
     _TblList          = "AnaDat.Tabel"
     _Options          = "NO-LOCK INDEXED-REPOSITION"
     _FldNameList[1]   > AnaDat.Tabel.CodeI
"Tabel.CodeI" "Code" "999" "integer" ? ? ? ? ? ? no ? no no "8" no no no "U" "" ""
     _FldNameList[2]   > AnaDat.Tabel.CodeC
"Tabel.CodeC" "Code" ? "character" ? ? ? ? ? ? no ? no no ? no no no "U" "" ""
     _FldNameList[3]   > AnaDat.Tabel.Bez1
"Tabel.Bez1" "Beschreibung" ? "character" ? ? ? ? ? ? no ? no no ? yes no no "U" "" ""
     _Query            is NOT OPENED
*/  /* BROWSE select-next-roeBr_Tabelle */
&ANALYZE-RESUME

 



/* ************************  Control Triggers  ************************ */

&Scoped-define SELF-NAME gAuswahl
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gAuswahl gAuswahl
ON END-ERROR OF FRAME gAuswahl /* Auswahl aus Tabelle */
DO:
    RUN ENDE.
    RETURN NO-APPLY.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gAuswahl gAuswahl
ON GO OF FRAME gAuswahl /* Auswahl aus Tabelle */
DO:
    RUN ENDE_PROGRAMM ( INPUT THIS-PROCEDURE:FILE-NAME ) NO-ERROR.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gAuswahl gAuswahl
ON WINDOW-CLOSE OF FRAME gAuswahl /* Auswahl aus Tabelle */
DO:  
    RUN SELEKTION.
    RUN ENDE.
    RETURN NO-APPLY.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&Scoped-define BROWSE-NAME select-next-roeBr_Tabelle
&Scoped-define SELF-NAME select-next-roeBr_Tabelle
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL select-next-roeBr_Tabelle gAuswahl
ON ANY-PRINTABLE OF select-next-roeBr_Tabelle IN FRAME gAuswahl
DO:
    DEF VAR ja      AS LOG                  NO-UNDO.
    DEF VAR i       AS INT                  NO-UNDO.

    DO WHILE TRUE:
        IF CHR(LASTKEY) = '' THEN                 RETURN NO-APPLY.
        IF NUM-RESULTS('{&BROWSE-NAME}') = 0 THEN RETURN NO-APPLY.
        i = {&BROWSE-NAME}:NUM-SELECTED-ROWS.
        IF i > 0 THEN LEAVE.
        i = {&BROWSE-NAME}:FOCUSED-ROW.
        IF i > 0 THEN DO:
            {&BROWSE-NAME}:SELECT-ROW(i).
            LEAVE.
        END.
        ja = BROWSE {&BROWSE-NAME}:SELECT-ROW(1).
    END.
    ja = BROWSE {&BROWSE-NAME}:SELECT-NEXT-ROW().
    i  = 0.
    DO WHILE ja:
        CASE Suchen:
            WHEN 1 THEN DO:
                RETURN.
            END.
            WHEN 2 THEN DO:
                IF Tabel.CodeC BEGINS CHR(LASTKEY) THEN DO:
                    REPOSITION {&BROWSE-NAME} TO ROWID ROWID(Tabel).
                    RETURN.
                END.
            END.
            WHEN 3 THEN DO:
                IF Tabel.Bez1 BEGINS CHR(LASTKEY) THEN DO:
                    REPOSITION {&BROWSE-NAME} TO ROWID ROWID(Tabel).
                    RETURN.
                END.
            END.
        END CASE.
        ja = BROWSE {&BROWSE-NAME}:SELECT-NEXT-ROW().
        IF ja THEN NEXT.
        i  = i + 1.
        ja = BROWSE {&BROWSE-NAME}:SELECT-ROW(1).
        IF i = 2 THEN RETURN.
    END.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL select-next-roeBr_Tabelle gAuswahl
ON CTRL-A OF select-next-roeBr_Tabelle IN FRAME gAuswahl
DO:
    RUN DESELEKTION.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL select-next-roeBr_Tabelle gAuswahl
ON RETURN OF select-next-roeBr_Tabelle IN FRAME gAuswahl
DO:
    RUN SELEKTION.
    RUN ENDE.
    RETURN NO-APPLY.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL select-next-roeBr_Tabelle gAuswahl
ON START-SEARCH OF select-next-roeBr_Tabelle IN FRAME gAuswahl
DO:
    DEFINE VARIABLE ColumnHandle AS HANDLE    NO-UNDO.
  
    ASSIGN ColumnHandle = {&BROWSE-NAME}:CURRENT-COLUMN.

    DO WITH FRAME {&FRAME-NAME}:
        APPLY 'END-SEARCH' TO BROWSE {&BROWSE-NAME}.
    END.

    CASE ColumnHandle:NAME:
    
        WHEN 'CodeI' THEN DO:
            Suchen = 1.
        END.
    
        WHEN 'CodeC' THEN DO:
            Suchen = 2.
        END.
    
        WHEN 'Bez1'  THEN DO:
            Suchen = 3.
        END.
    
    END CASE.

END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&UNDEFINE SELF-NAME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gAuswahl 


/* ***************************  Main Block  *************************** */

    MaxPage  = 1.
    AktSeite = 1.
    Suchen   = 3.

    SESSION:DATA-ENTRY-RETURN = TRUE.

    SUBSCRIBE TO 'TOOLBAR' ANYWHERE.

    FeldInhalt = ipFeld:SCREEN-VALUE.
    RecArt     = ipArt.
    Firma      = DYNAMIC-FUNCTION('GETMANDANT':U) NO-ERROR.

/*  TRIGGERS    ------------------------------------------------------  */

    ON 'ALT-CURSOR-RIGHT':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN NEXTPAGE.
    END.
    ON 'ALT-CURSOR-LEFT':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN PREVPAGE.
    END.
    ON 'U1':U OF {&WINDOW-NAME} ANYWHERE
    DO:
        RUN ENTRY_CURSOR.
    END.
/*
    ON 'PAGE-DOWN':U OF {&WINDOW-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'Next':U ).
    END.
    ON 'PAGE-UP':U OF {&WINDOW-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'Prev':U ).
    END.
    
    ON 'ALT-RETURN':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'UPDATE':U ).
    END.
    ON 'ALT-INS':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'ADD':U    ).
    END.
    ON 'ALT-DEL':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'DELETE':U ).
    END.
    ON 'ALT-R':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'RESET':U  ).
    END.
    ON 'F9':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'SAVE':U   ).
    END.
    ON 'ALT-S':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'SAVE':U   ).
    END.
    ON 'ALT-K':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'COPY':U   ).
    END.

    ON 'END-ERROR':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        FMutFlag = DYNAMIC-FUNCTION('getMutflagAlt':U) NO-ERROR.
        IF FMutFlag = FALSE THEN DO:
            RUN ENDE.
            RETURN NO-APPLY.
        END.
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'CANCEL':U ).
        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 gAuswahl  _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 gAuswahl 
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 DESELEKTION gAuswahl 
PROCEDURE DESELEKTION :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DEF VAR ii      AS INT                      NO-UNDO.
    DEF VAR ix      AS INT                      NO-UNDO.

    DO WITH FRAME {&FRAME-NAME}:
        ii = {&BROWSE-NAME}:NUM-SELECTED-ROWS.
        DO ix = 1 TO ii:
            {&BROWSE-NAME}:DESELECT-SELECTED-ROW(01) NO-ERROR.
        END.
    END.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI gAuswahl  _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 gAuswahl.
END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gAuswahl 
PROCEDURE enableObject :
/*------------------------------------------------------------------------------
  Purpose:     Super Override
  Parameters:  
  Notes:       
------------------------------------------------------------------------------*/
    
    Art = 0.

DO WITH FRAME {&FRAME-NAME}:
    CASE RecArt:
        WHEN 'HERST' THEN DO:
           FRAME {&FRAME-NAME}:TITLE = 'Hersteller'.
            Tabel.CodeI:VISIBLE IN BROWSE {&BROWSE-NAME} = TRUE.
            Art = 0.
        END.
        WHEN 'AREG' THEN DO:
           FRAME {&FRAME-NAME}:TITLE = 'Regionen'.
            Tabel.CodeI:VISIBLE IN BROWSE {&BROWSE-NAME} = TRUE.
            Art = 0.
        END.
        WHEN 'KUNDGRP' THEN DO:
           FRAME {&FRAME-NAME}:TITLE = 'Kundengruppen'.
            Tabel.CodeI:VISIBLE IN BROWSE {&BROWSE-NAME} = TRUE.
            Art = 0.
        END.
        WHEN 'PREGRP' THEN DO:
           FRAME {&FRAME-NAME}:TITLE = 'Preisgruppen'.
            Tabel.CodeI:VISIBLE IN BROWSE {&BROWSE-NAME} = TRUE.
            Art = 0.
        END.
        WHEN 'BIER' THEN DO:
           FRAME {&FRAME-NAME}:TITLE = 'Vertragsgruppe'.
            Tabel.CodeI:VISIBLE IN BROWSE {&BROWSE-NAME} = TRUE.
            Art = 0.
        END.
        WHEN 'BESUCH' THEN DO:
           FRAME {&FRAME-NAME}:TITLE = 'Besuchsarten/Aktivitäten'.
            Tabel.CodeC:VISIBLE IN BROWSE {&BROWSE-NAME} = TRUE.
            Art = 1.
        END.
    END CASE.
    {&BROWSE-NAME}:SET-REPOSITIONED-ROW ( 3 , 'CONDITIONAL' ).
END.

    RUN SUPER.

    RUN FENSTER_TITEL ( INPUT FRAME {&FRAME-NAME}:HANDLE ) NO-ERROR.

    RUN OPEN_TABELLE.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gAuswahl  _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.
------------------------------------------------------------------------------*/
  ENABLE select-next-roeBr_Tabelle RECT-38 
      WITH FRAME gAuswahl.
  VIEW FRAME gAuswahl.
  {&OPEN-BROWSERS-IN-QUERY-gAuswahl}
END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gAuswahl 
PROCEDURE ENDE :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U) NO-ERROR.

    IF AktSeite > 1 THEN DO:
        RUN selectPage ( INPUT 1 ).
        RETURN NO-APPLY.
    END.

    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 ENTRY_CURSOR gAuswahl 
PROCEDURE ENTRY_CURSOR :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).

    CASE AktSeite:
         WHEN 1 THEN APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
    END CASE.

    RETURN NO-APPLY.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE exitObject gAuswahl 
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 NEXTPAGE gAuswahl 
PROCEDURE NEXTPAGE :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
    IF AktSeite = MaxPage THEN AktSeite = 1.
    ELSE                       AktSeite = AktSeite + 1.

    RUN selectPage ( INPUT AktSeite ).

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE OPEN_TABELLE gAuswahl 
PROCEDURE OPEN_TABELLE :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    CASE Art:
        WHEN 0 THEN DO:
            OPEN QUERY {&BROWSE-NAME}
                FOR EACH Tabel WHERE Tabel.Firma  = Firma
                               AND   Tabel.RecArt = RecArt
                               AND   Tabel.Sprcd  = 1 NO-LOCK BY Tabel.Bez1.
        END.
        WHEN 1 THEN DO:
            OPEN QUERY {&BROWSE-NAME}
                FOR EACH Tabel WHERE Tabel.Firma  = Firma
                               AND   Tabel.RecArt = RecArt
                               AND   Tabel.Sprcd  = 1 NO-LOCK BY Tabel.Bez1.
        END.
    END CASE.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE PREVPAGE gAuswahl 
PROCEDURE PREVPAGE :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
    IF AktSeite = 1 THEN AktSeite = MaxPage.
    ELSE                 AktSeite = AktSeite - 1.

    RUN selectPage ( INPUT AktSeite ).

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE selectPage gAuswahl 
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('getMutflagAlt':U) NO-ERROR.
    DO WHILE TRUE:
        IF NOT FMutFlag THEN LEAVE.
        MutProg = DYNAMIC-FUNCTION('GETMUTPROG':U).
        IF MutProg <> THIS-PROCEDURE:FILE-NAME THEN LEAVE.
        RETURN NO-APPLY.
    END.

    CASE piPageNum:

    END CASE.

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).

    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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SELEKTION gAuswahl 
PROCEDURE SELEKTION :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DEF VAR ii      AS INT                      NO-UNDO.
    DEF VAR ix      AS INT                      NO-UNDO.
    DEF VAR cString AS CHAR                     NO-UNDO.

    DO WITH FRAME {&FRAME-NAME}:
        ii = {&BROWSE-NAME}:NUM-SELECTED-ROWS.
        cString = ''.
        DO ix = ii TO 1 BY -1:
            {&BROWSE-NAME}:FETCH-SELECTED-ROW(ix) NO-ERROR.
            IF NOT AVAILABLE Tabel THEN NEXT.
            IF cString <> '' THEN cString = cString + ','.
            CASE Art:
                WHEN 0 THEN cString = cString + STRING(Tabel.CodeI,'999').
                WHEN 1 THEN cString = cString + Tabel.CodeC.
            END CASE.
        END.
        ipFeld:SCREEN-VALUE = cString.
    END.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE TOOLBAR gAuswahl 
PROCEDURE TOOLBAR :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DEF INPUT PARAMETER pcAction    AS CHAR             NO-UNDO.
/*    
    RUN TOOLBAR IN h_dyntoolbar ( INPUT pcAction ).
*/
END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE viewObject gAuswahl 
PROCEDURE viewObject :
/*------------------------------------------------------------------------------
  Purpose:     Super Override
  Parameters:  
  Notes:       
------------------------------------------------------------------------------*/

    RUN SUPER.

    DEF VAR ix      AS INT                      NO-UNDO.
    DEF VAR ii      AS INT                      NO-UNDO.
    DEF VAR cc      AS CHAR                     NO-UNDO.

    DO ix = 1 TO NUM-ENTRIES(FeldInhalt, ',') WITH FRAME {&FRAME-NAME}:
        CASE Art:
            WHEN 0 THEN DO:
                ii = INTEGER(ENTRY(ix, FeldInhalt, ',')) NO-ERROR.
                IF ERROR-STATUS:ERROR THEN NEXT.
                FIND BTabel WHERE BTabel.Firma  = Firma
                            AND   BTabel.RecArt = RecArt
                            AND   BTabel.Sprcd  = 1
                            AND   BTabel.CodeI  = ii
                            AND   BTabel.CodeC  = '' NO-LOCK NO-ERROR.
                IF AVAILABLE BTabel THEN DO:
                    REPOSITION {&BROWSE-NAME} TO ROWID ROWID(BTabel).
                    {&BROWSE-NAME}:SELECT-FOCUSED-ROW().
                END.
            END.
        END CASE.
    END.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME