GeMIS_WEB/GUI/v8/a-schriften.w

&ANALYZE-SUSPEND _VERSION-NUMBER UIB_v8r12 GUI ADM1
&ANALYZE-RESUME
/* Connected Databases 
          anadat           PROGRESS
*/
&Scoped-define WINDOW-NAME CURRENT-WINDOW
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS B-table-Win 
/*------------------------------------------------------------------------

  File:  

  Description: from BROWSER.W - Basic SmartBrowser Object Template

  Input Parameters:
      <none>

  Output Parameters:
      <none>

------------------------------------------------------------------------*/
/*          This .W file was created with the Progress UIB.             */
/*----------------------------------------------------------------------*/

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

&Scoped-define ERSTES-FELD  Schname
&Scoped-define ZWEITES-FELD Schbild
&Scoped-define LETZTES-FELD Schzzend
&Scoped-define INPUT-FELDER Schrift.Schname,Schrift.Schbild,Schrift.Schzztot,~
                            Schrift.Schzzbeg,Schrift.Schzzend
&Scoped-define DATEI-NAME   Schrift

/* ***************************  Definitions  ************************** */

/* Parameters Definitions ---                                           */

/* Local Variable Definitions ---                                       */

/* --------------------------------------------------------------------------- */
DEF VAR     VUpdate     AS LOG      INIT FALSE          NO-UNDO.
DEF VAR     VSpeichern  AS LOG      INIT FALSE          NO-UNDO.
DEF VAR     VNeu        AS LOG      INIT FALSE          NO-UNDO.
DEF VAR     FErfassen   AS LOG      INIT FALSE          NO-UNDO.
DEF VAR     PHandle     AS HANDLE                       NO-UNDO.
DEF VAR     XHandle     AS HANDLE                       NO-UNDO.
DEF VAR     LHandle     AS HANDLE                       NO-UNDO.
DEF VAR     ch          AS CHAR                         NO-UNDO.
DEF VAR     VText       AS CHAR     FORMAT "x(30)"      NO-UNDO.
DEF VAR     QOpen       AS LOG      INIT FALSE          NO-UNDO.
DEF VAR     FQOpen      AS LOG      INIT FALSE          NO-UNDO.
DEF VAR     Vorhanden   AS LOG                          NO-UNDO.
DEF VAR     VRecid      AS RECID                        NO-UNDO.
DEF VAR     VROWID      AS ROWID                        NO-UNDO.
DEF VAR     Feldname    AS CHAR                         NO-UNDO.
DEF VAR     FeldInhalt  AS CHAR                         NO-UNDO.
DEF VAR     BStatus     AS INT      INIT 0              NO-UNDO.
DEF BUFFER  B{&DATEI-NAME}  FOR {&DATEI-NAME}.
/* --------------------------------------------------------------------------- */

/* Parameters Definitions ---                                           */

/* Local Variable Definitions ---                                       */

/*  ----------  Globale Variablen   ---------------------------------- */

{ v8/globvar.i" " " " "SHARED" }
{ v8/debivar.i " " " " "SHARED" }
{ v8/artivar.i " " " " "SHARED" }
{ v8/contvar.i " " " " "SHARED" }

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


&ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK 

/* ********************  Preprocessor Definitions  ******************** */

&Scoped-define PROCEDURE-TYPE SmartBrowser
&Scoped-define DB-AWARE no

&Scoped-define ADM-SUPPORTED-LINKS Record-Source,Record-Target,TableIO-Target

/* Name of first Frame and/or Browse and/or first Query                 */
&Scoped-define FRAME-NAME F-Main
&Scoped-define BROWSE-NAME br_table

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

/* Define KEY-PHRASE in case it is used by any query. */
&Scoped-define KEY-PHRASE TRUE

/* Definitions for BROWSE br_table                                      */
&Scoped-define FIELDS-IN-QUERY-br_table Schrift.Schname Schrift.Schbild ~
Schrift.Schzztot Schrift.Schzzbeg Schrift.Schzzend 
&Scoped-define ENABLED-FIELDS-IN-QUERY-br_table Schrift.Schbild ~
Schrift.Schzzbeg Schrift.Schzzend 
&Scoped-define ENABLED-TABLES-IN-QUERY-br_table Schrift
&Scoped-define FIRST-ENABLED-TABLE-IN-QUERY-br_table Schrift
&Scoped-define QUERY-STRING-br_table FOR EACH Schrift WHERE ~{&KEY-PHRASE} NO-LOCK ~
    ~{&SORTBY-PHRASE}
&Scoped-define OPEN-QUERY-br_table OPEN QUERY br_table FOR EACH Schrift WHERE ~{&KEY-PHRASE} NO-LOCK ~
    ~{&SORTBY-PHRASE}.
&Scoped-define TABLES-IN-QUERY-br_table Schrift
&Scoped-define FIRST-TABLE-IN-QUERY-br_table Schrift


/* Definitions for FRAME F-Main                                         */

/* Standard List Definitions                                            */
&Scoped-Define ENABLED-OBJECTS RECT-9 br_table Btn_Erfassen Btn_Speichern ~
Btn_Loeschen 

/* Custom List Definitions                                              */
/* List-1,List-2,List-3,List-4,List-5,List-6                            */

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _XFTR "Foreign Keys" B-table-Win _INLINE
/* Actions: ? adm/support/keyedit.w ? ? ? */
/* STRUCTURED-DATA
<KEY-OBJECT>
&BROWSE-NAME
</KEY-OBJECT>
<FOREIGN-KEYS>
</FOREIGN-KEYS>
<EXECUTING-CODE>
**************************
* Set attributes related to FOREIGN KEYS
*/
RUN set-attribute-list (
    'Keys-Accepted = "",
     Keys-Supplied = ""':U).
/**************************
</EXECUTING-CODE> */   

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _XFTR "Advanced Query Options" B-table-Win _INLINE
/* Actions: ? adm/support/advqedit.w ? ? ? */
/* STRUCTURED-DATA
<KEY-OBJECT>
&BROWSE-NAME
</KEY-OBJECT>
<SORTBY-OPTIONS>
</SORTBY-OPTIONS> 
<SORTBY-RUN-CODE>
************************
* Set attributes related to SORTBY-OPTIONS */
RUN set-attribute-list (
    'SortBy-Options = ""':U).
/************************
</SORTBY-RUN-CODE> 
<FILTER-ATTRIBUTES>
</FILTER-ATTRIBUTES> */   

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


/* ***********************  Control Definitions  ********************** */


/* Definitions of the field level widgets                               */
DEFINE BUTTON Btn_Erfassen 
     LABEL "&Erfassen" 
     SIZE 14 BY 1.

DEFINE BUTTON Btn_Loeschen 
     LABEL "&Löschen" 
     SIZE 14 BY 1.

DEFINE BUTTON Btn_Speichern 
     LABEL "&Speichern" 
     SIZE 14 BY 1.

DEFINE RECTANGLE RECT-9
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL   
     SIZE 130 BY 8.1.

/* Query definitions                                                    */
&ANALYZE-SUSPEND
DEFINE QUERY br_table FOR 
      Schrift SCROLLING.
&ANALYZE-RESUME

/* Browse definitions                                                   */
DEFINE BROWSE br_table
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_table B-table-Win _STRUCTURED
  QUERY br_table NO-LOCK DISPLAY
      Schrift.Schname COLUMN-LABEL "Drucker" FORMAT "x(50)":U
      Schrift.Schbild COLUMN-LABEL "Schriftbild" FORMAT "x(20)":U
      Schrift.Schzztot COLUMN-LABEL "Tot. Zeilen" FORMAT "zzz9":U
      Schrift.Schzzbeg COLUMN-LABEL "Kopfzeilen" FORMAT "zzz9":U
      Schrift.Schzzend COLUMN-LABEL "Fusszeilen" FORMAT "zzz9":U
  ENABLE
      Schrift.Schbild
      Schrift.Schzzbeg
      Schrift.Schzzend
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
    WITH NO-ASSIGN NO-ROW-MARKERS SEPARATORS SIZE 110 BY 7.62
         BGCOLOR 15 .


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

DEFINE FRAME F-Main
     br_table AT ROW 1.48 COL 3
     Btn_Erfassen AT ROW 1.76 COL 115.8
     Btn_Speichern AT ROW 2.95 COL 115.8
     Btn_Loeschen AT ROW 4.14 COL 115.8
     RECT-9 AT ROW 1.24 COL 2
    WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY 
         SIDE-LABELS NO-UNDERLINE THREE-D 
         AT COL 1 ROW 1 SCROLLABLE 
         DEFAULT-BUTTON Btn_Speichern.


/* *********************** Procedure Settings ************************ */

&ANALYZE-SUSPEND _PROCEDURE-SETTINGS
/* Settings for THIS-PROCEDURE
   Type: SmartBrowser
   Allow: Basic,Browse
   Frames: 1
   Add Fields to: EXTERNAL-TABLES
   Other Settings: PERSISTENT-ONLY COMPILE
 */

/* This procedure should always be RUN PERSISTENT.  Report the error,  */
/* then cleanup and return.                                            */
IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
          VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  RETURN.
END.

&ANALYZE-RESUME _END-PROCEDURE-SETTINGS

/* *************************  Create Window  ************************** */

&ANALYZE-SUSPEND _CREATE-WINDOW
/* DESIGN Window definition (used by the UIB) 
  CREATE WINDOW B-table-Win ASSIGN
         HEIGHT             = 8.91
         WIDTH              = 133.2.
/* END WINDOW DEFINITION */
                                                                        */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB B-table-Win 
/* ************************* Included-Libraries *********************** */

{src/adm/method/browser.i}

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




/* ***********  Runtime Attributes and AppBuilder Settings  *********** */

&ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
/* SETTINGS FOR WINDOW B-table-Win
  NOT-VISIBLE,,RUN-PERSISTENT                                           */
/* SETTINGS FOR FRAME F-Main
   NOT-VISIBLE Size-to-Fit                                              */
/* BROWSE-TAB br_table RECT-9 F-Main */
ASSIGN 
       FRAME F-Main:SCROLLABLE       = FALSE
       FRAME F-Main:HIDDEN           = TRUE
       FRAME F-Main:RESIZABLE        = TRUE.

ASSIGN 
       br_table:COLUMN-RESIZABLE IN FRAME F-Main       = TRUE.

ASSIGN 
       Btn_Erfassen:PRIVATE-DATA IN FRAME F-Main     = 
                "Abbrechen".

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


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

&ANALYZE-SUSPEND _QUERY-BLOCK BROWSE br_table
/* Query rebuild information for BROWSE br_table
     _TblList          = "AnaDat.Schrift"
     _Options          = "NO-LOCK KEY-PHRASE SORTBY-PHRASE"
     _FldNameList[1]   > AnaDat.Schrift.Schname
"Schname" "Drucker" "x(50)" "character" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[2]   > AnaDat.Schrift.Schbild
"Schbild" "Schriftbild" "x(20)" "character" ? ? ? ? ? ? yes ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[3]   > AnaDat.Schrift.Schzztot
"Schzztot" "Tot. Zeilen" ? "integer" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[4]   > AnaDat.Schrift.Schzzbeg
"Schzzbeg" "Kopfzeilen" ? "integer" ? ? ? ? ? ? yes ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[5]   > AnaDat.Schrift.Schzzend
"Schzzend" "Fusszeilen" ? "integer" ? ? ? ? ? ? yes ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _Query            is NOT OPENED
*/  /* BROWSE br_table */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
/* Query rebuild information for FRAME F-Main
     _Options          = "NO-LOCK"
     _Query            is NOT OPENED
*/  /* FRAME F-Main */
&ANALYZE-RESUME

 



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

&Scoped-define BROWSE-NAME br_table
&Scoped-define SELF-NAME br_table
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table B-table-Win
ON LEFT-MOUSE-DBLCLICK OF br_table IN FRAME F-Main
DO:
    IF NOT AVAILABLE Schrift THEN RETURN.
    LVRecid = RECID(Schrift).
    RUN new-state ( 'druckerwahl, BROWSER' ).
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table B-table-Win
ON ROW-DISPLAY OF br_table IN FRAME F-Main
DO:
    RUN ANZEIGE.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table B-table-Win
ON ROW-ENTRY OF br_table IN FRAME F-Main
DO:
    {src/adm/template/brsentry.i}
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table B-table-Win
ON ROW-LEAVE OF br_table IN FRAME F-Main
DO:
    LKY     = LASTKEY.
    LHandle = LAST-EVENT:WIDGET-LEAVE.
    XHandle = LAST-EVENT:WIDGET-ENTER.
    
    DO WHILE VUpdate AND NOT FErfassen WITH FRAME {&FRAME-NAME}:
        IF KEYFUNCTION(LKY) = 'END-ERROR' THEN DO:
            VSpeichern = FALSE.
            RUN ERFASSEN.
            RETURN NO-APPLY.
        END.
        IF {&BROWSE-NAME}:CURRENT-ROW-MODIFIED = FALSE THEN DO:
            VSpeichern = FALSE.
            VUpdate    = FALSE.
            RUN ERFASSEN.
            RETURN NO-APPLY.
        END.
        IF LKY = KEYCODE('RETURN') THEN DO:
            RUN SPEICHERN.
            RETURN NO-APPLY.
        END.
        IF LKY = KEYCODE('TAB')             AND
           LHandle:NAME = '{&LETZTES-FELD}' THEN DO:
            RUN SPEICHERN.
            RETURN NO-APPLY.
        END.
        IF VALID-HANDLE(XHandle) THEN DO:
            DO WHILE XHandle:TYPE = 'BUTTON':
                IF XHandle:NAME = 'Btn_Erfassen'    THEN RETURN.
                IF XHandle:NAME = 'Btn_Speichern'   THEN RETURN.
                APPLY 'ENTRY' TO LHandle.
                RETURN NO-APPLY.
            END.
        END.
        RETURN NO-APPLY.
    END.
    
    FErfassen = FALSE.

    {src/adm/template/brsleave.i}
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table B-table-Win
ON VALUE-CHANGED OF br_table IN FRAME F-Main
DO:
    RUN ANZEIGE.
    {src/adm/template/brschnge.i}
END.

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


&Scoped-define SELF-NAME Btn_Erfassen
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Erfassen B-table-Win
ON CHOOSE OF Btn_Erfassen IN FRAME F-Main /* Erfassen */
DO:
    IF VUpdate THEN VSpeichern = FALSE.
    VUpdate = FALSE.
    RUN ERFASSEN.
END.

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


&Scoped-define SELF-NAME Btn_Loeschen
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Loeschen B-table-Win
ON CHOOSE OF Btn_Loeschen IN FRAME F-Main /* Löschen */
DO:
    RUN LOESCHEN.
END.

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


&Scoped-define SELF-NAME Btn_Speichern
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Speichern B-table-Win
ON CHOOSE OF Btn_Speichern IN FRAME F-Main /* Speichern */
DO:
    VUpdate = FALSE.
    RUN SPEICHERN.
END.

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


&UNDEFINE SELF-NAME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK B-table-Win 


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

/*  ------  Triggers  ----------------------------------------------------  */

ON INSERT-MODE OF BROWSE {&BROWSE-NAME}
DO:
    IF VUpdate THEN RETURN NO-APPLY.
    RUN ERFASSEN.
END.

ON RETURN OF BROWSE {&BROWSE-NAME}
DO:
    IF VUpdate THEN RETURN NO-APPLY.
    RUN SPEICHERN.
END.

ON DELETE-CHARACTER OF BROWSE {&BROWSE-NAME}
DO:
    IF VUpdate THEN RETURN NO-APPLY.
    RUN LOESCHEN.
END.

ON CTRL-CURSOR-RIGHT OF        {&WINDOW-NAME}
OR CTRL-CURSOR-RIGHT OF BROWSE {&BROWSE-NAME}
DO:
    IF VUpdate THEN RETURN NO-APPLY.
    RUN new-state ( INPUT 'Next_Page, MAIN':U ).
    RETURN NO-APPLY.
END.

ON CTRL-CURSOR-LEFT  OF        {&WINDOW-NAME}
OR CTRL-CURSOR-LEFT  OF BROWSE {&BROWSE-NAME}
DO:
    IF VUpdate THEN RETURN NO-APPLY.
    RUN new-state ( INPUT 'Prev_Page, MAIN':U ).
    RETURN NO-APPLY.
END.

ON ENTRY OF {&DATEI-NAME}.{&ERSTES-FELD} IN BROWSE {&BROWSE-NAME}
DO:
    IF NOT VNeu THEN DO:
        APPLY 'ENTRY' TO {&DATEI-NAME}.{&ZWEITES-FELD} IN BROWSE {&BROWSE-NAME}.
        RETURN NO-APPLY.
    END.
END.

ON RETURN OF {&DATEI-NAME}.{&ERSTES-FELD} IN BROWSE {&BROWSE-NAME}
DO:
    IF NOT VUpdate THEN RETURN.
    APPLY 'TAB' TO SELF.
    RETURN NO-APPLY.
END.

ON CURSOR-UP   OF {&INPUT-FELDER} IN BROWSE {&BROWSE-NAME}
DO:
    IF NOT VUpdate THEN RETURN.
    APPLY 'BACK-TAB' TO SELF.
    RETURN NO-APPLY.
END.

ON CURSOR-DOWN OF {&INPUT-FELDER} IN BROWSE {&BROWSE-NAME}
DO:
    IF NOT VUpdate THEN RETURN.
    APPLY 'TAB' TO SELF.
    RETURN NO-APPLY.
END.

ON END-ERROR OF {&INPUT-FELDER} IN BROWSE {&BROWSE-NAME}
DO:
    VSpeichern = FALSE.
    IF NOT VUpdate THEN DO:
        RUN new-state ( INPUT 'ENDE, MAIN':U ).
        RETURN NO-APPLY.  
    END.
    APPLY 'ENTRY' TO Btn_Erfassen IN FRAME {&FRAME-NAME}.
END.

ON LEFT-MOUSE-DOWN, RIGHT-MOUSE-DOWN, MIDDLE-MOUSE-DOWN OF BROWSE {&BROWSE-NAME}
DO:
    DO WHILE TRUE:
        IF NOT VUpdate THEN LEAVE.
        XHandle = {&BROWSE-NAME}:CURRENT-COLUMN IN FRAME {&FRAME-NAME}.
        IF NOT VALID-HANDLE(XHandle) THEN XHandle = LAST-EVENT:WIDGET-LEAVE.
        IF VALID-HANDLE(XHandle) THEN DO:
            APPLY 'LEAVE' TO XHandle.
            RETURN.
        END.
        LEAVE.
    END.
END.

ON LEAVE OF {&DATEI-NAME}.{&ERSTES-FELD} IN BROWSE {&BROWSE-NAME}
DO:
    IF NOT VUpdate THEN RETURN.
    LKY     = LASTKEY.
    LHandle = LAST-EVENT:WIDGET-ENTER.
    
    IF VALID-HANDLE(LHandle) THEN DO:
        IF LHandle:TYPE         = 'BUTTON'      AND
           LHandle:PRIVATE-DATA = 'Abbrechen'   THEN DO:
            VSpeichern = FALSE.
            APPLY 'ENTRY' TO Btn_Erfassen IN FRAME {&FRAME-NAME}.
            RETURN NO-APPLY.
        END.
    END.
    
    IF NOT VSpeichern THEN RETURN.

    XHandle    = {&BROWSE-NAME}:CURRENT-COLUMN IN FRAME {&FRAME-NAME}.
    Feldname   = XHandle:NAME.
    Feldinhalt = XHandle:SCREEN-VALUE.
    
END.

&IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN          
RUN dispatch IN THIS-PROCEDURE ('initialize':U).        
&ENDIF

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


/* **********************  Internal Procedures  *********************** */

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-row-available B-table-Win  _ADM-ROW-AVAILABLE
PROCEDURE adm-row-available :
/*------------------------------------------------------------------------------
  Purpose:     Dispatched to this procedure when the Record-
               Source has a new row available.  This procedure
               tries to get the new row (or foriegn keys) from
               the Record-Source and process it.
  Parameters:  <none>
------------------------------------------------------------------------------*/

  /* Define variables needed by this internal procedure.             */
  {src/adm/template/row-head.i}

  /* Process the newly available records (i.e. display fields,
     open queries, and/or pass records on to any RECORD-TARGETS).    */
  {src/adm/template/row-end.i}

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ANZEIGE B-table-Win 
PROCEDURE ANZEIGE :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    VText = ''.
    
    IF AVAILABLE {&DATEI-NAME} THEN DO:
        VRecid = RECID({&DATEI-NAME}).
        VROWID = ROWID({&DATEI-NAME}).
    END.

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE BUTTON_ENABLE B-table-Win 
PROCEDURE BUTTON_ENABLE :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

DEF INPUT PARAMETER Art         AS INT          NO-UNDO.

DO WITH FRAME {&FRAME-NAME}:

    IF Art < 90 THEN BStatus = Art.
    IF Art = 98 THEN Art     = 9.
    IF Art = 99 THEN Art     = BStatus.
    
    CASE Art:
    
        WHEN 1 THEN DO:
            ENABLE  Btn_Erfassen.
            DISABLE Btn_Speichern   Btn_Loeschen.
        END.
        
        WHEN 2 THEN DO:
            ENABLE  Btn_Erfassen    Btn_Speichern   Btn_Loeschen.
        END.
        
        WHEN 3 THEN DO:
            DISABLE Btn_Loeschen.
            ENABLE  Btn_Speichern.
        END.
        
        WHEN 9 THEN DO:
            DISABLE Btn_Erfassen    Btn_Speichern   Btn_Loeschen.
        END.
        
    END CASE.
    
END.

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI B-table-Win  _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 F-Main.
  IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ERFASSEN B-table-Win 
PROCEDURE ERFASSEN :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

DO WITH FRAME {&FRAME-NAME}:

    IF Btn_Erfassen:SENSITIVE = FALSE THEN RETURN NO-APPLY.
    APPLY 'ENTRY' TO Btn_Erfassen.

    CASE Btn_Erfassen:LABEL:
    
        WHEN '&Erfassen' THEN DO:
            APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
            RETURN NO-APPLY.
        END.

        WHEN '&Abbrechen' THEN DO:
            VSpeichern = FALSE.
            RUN adm-disable-fields.
            RUN adm-cancel-record.
            VUpdate    = FALSE.
            VNeu       = FALSE.
            FErfassen  = FALSE.
            Btn_Erfassen:LABEL  = '&Erfassen'.
            Btn_Speichern:LABEL = '&Aendern'.
            IF Vorhanden THEN RUN BUTTON_ENABLE ( 2 ).
            ELSE              RUN BUTTON_ENABLE ( 1 ).
        END.

    END CASE.
    
END.

    IF NOT VUpdate THEN RUN state-changed ( INPUT THIS-PROCEDURE, INPUT 'browser_entry' ).

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-assign-record B-table-Win 
PROCEDURE local-assign-record :
/*------------------------------------------------------------------------------
  Purpose:     Override standard ADM method
  Notes:       
------------------------------------------------------------------------------*/

    RUN dispatch IN THIS-PROCEDURE ( INPUT 'assign-record':U ) .

    IF VNeu THEN DO:
    END.
    ELSE DO:
    END.

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-hide B-table-Win 
PROCEDURE local-hide :
/*------------------------------------------------------------------------------
  Purpose:     Override standard ADM method
  Notes:       
------------------------------------------------------------------------------*/

    IF VUpdate THEN DO:
        APPLY 'ENTRY' TO Btn_Erfassen IN FRAME {&FRAME-NAME}.
        RUN ERFASSEN.
    END.

    RUN dispatch IN THIS-PROCEDURE ( INPUT 'hide':U ) .
    FQOpen = FALSE.

    RUN BUTTON_ENABLE ( INPUT 98 ).

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-open-query B-table-Win 
PROCEDURE local-open-query :
/*------------------------------------------------------------------------------
  Purpose:     Override standard ADM method
  Notes:       
------------------------------------------------------------------------------*/

    IF QOpen THEN CLOSE QUERY {&BROWSE-NAME}.
    QOpen = FALSE.

    Vorhanden = FALSE.

    RUN dispatch IN THIS-PROCEDURE ( INPUT 'open-query':U ).
    QOpen     = TRUE.

    DO WHILE TRUE WITH FRAME {&FRAME-NAME}:
        IF NUM-RESULTS("{&BROWSE-NAME}":U) = ? THEN LEAVE.
        IF NUM-RESULTS("{&BROWSE-NAME}":U) = 0 THEN LEAVE.
        Vorhanden = TRUE.
        LEAVE.
    END.
    
    DO WITH FRAME {&FRAME-NAME}:
        IF Vorhanden THEN DO:
            RUN BUTTON_ENABLE ( 2 ).
            APPLY 'VALUE-CHANGED' TO BROWSE {&BROWSE-NAME}.
        END.
        ELSE DO:
            RUN BUTTON_ENABLE ( 1 ).
        END.
    END.
    
END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-view B-table-Win 
PROCEDURE local-view :
/*------------------------------------------------------------------------------
  Purpose:     Override standard ADM method
  Notes:       
------------------------------------------------------------------------------*/

    RUN dispatch IN THIS-PROCEDURE ( INPUT 'view':U ) .
    FQOpen = TRUE.
    
    RUN BUTTON_ENABLE ( INPUT 99 ).

    DO WITH FRAME {&FRAME-NAME}:
        Btn_Erfassen:LABEL  IN FRAME {&FRAME-NAME} = '&Erfassen'.
        Btn_Speichern:LABEL IN FRAME {&FRAME-NAME} = '&Aendern'.
        
        RUN dispatch IN THIS-PROCEDURE ('disable-fields':U).
        
        IF NUM-RESULTS("{&BROWSE-NAME}":U) = ? THEN LEAVE.
        IF NUM-RESULTS("{&BROWSE-NAME}":U) = 0 THEN LEAVE.

        {&BROWSE-NAME}:SELECT-FOCUSED-ROW().
        APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
        RETURN NO-APPLY.
    END.

    
END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE LOESCHEN B-table-Win 
PROCEDURE LOESCHEN :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/
    
    IF Btn_Loeschen:SENSITIVE IN FRAME {&FRAME-NAME} = FALSE THEN RETURN NO-APPLY.
    
    APPLY 'ENTRY' TO Btn_Erfassen IN FRAME {&FRAME-NAME}.

    RUN BUTTON_ENABLE ( 9 ).

    Ja = FALSE.
    { v8/loeschen.i }
    IF NOT Ja THEN DO:
        RUN BUTTON_ENABLE ( 2 ).
        RUN state-changed ( INPUT THIS-PROCEDURE, INPUT 'browser_entry' ).
        RETURN.
    END.

    RUN dispatch IN THIS-PROCEDURE ('delete-record':U).
        
    DO WHILE TRUE WITH FRAME {&FRAME-NAME}:
        Vorhanden = FALSE.
        IF NUM-RESULTS("{&BROWSE-NAME}":U) = ? THEN LEAVE.
        IF NUM-RESULTS("{&BROWSE-NAME}":U) = 0 THEN LEAVE.
        Vorhanden = TRUE.
        LEAVE.
    END.

    IF Vorhanden THEN RUN BUTTON_ENABLE ( 2 ).
    ELSE              RUN BUTTON_ENABLE ( 1 ).
    
    RUN state-changed ( INPUT THIS-PROCEDURE, INPUT 'browser_entry' ).

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE send-records B-table-Win  _ADM-SEND-RECORDS
PROCEDURE send-records :
/*------------------------------------------------------------------------------
  Purpose:     Send record ROWID's for all tables used by
               this file.
  Parameters:  see template/snd-head.i
------------------------------------------------------------------------------*/

  /* Define variables needed by this internal procedure.               */
  {src/adm/template/snd-head.i}

  /* For each requested table, put it's ROWID in the output list.      */
  {src/adm/template/snd-list.i "Schrift"}

  /* Deal with any unexpected table requests before closing.           */
  {src/adm/template/snd-end.i}

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SPEICHERN B-table-Win 
PROCEDURE SPEICHERN :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

DEF VAR XROWID      AS ROWID                    NO-UNDO.

DO WITH FRAME {&FRAME-NAME}:

    IF Btn_Speichern:SENSITIVE = FALSE THEN RETURN NO-APPLY.
    APPLY 'ENTRY' TO Btn_Speichern.

    CASE Btn_Speichern:LABEL:
    
        WHEN '&Aendern' THEN DO:
            RUN adm-enable-fields.
            APPLY 'ENTRY' TO {&DATEI-NAME}.{&ZWEITES-FELD} IN BROWSE {&BROWSE-NAME}.
            VUpdate    = TRUE.
            VNeu       = FALSE.
            VSpeichern = TRUE.
            Btn_Erfassen:LABEL  = '&Abbrechen'.
            Btn_Speichern:LABEL = '&Speichern'.
            RUN BUTTON_ENABLE ( 3 ).
        END.

        WHEN '&Speichern' THEN DO:
            VUpdate    = FALSE.
            RUN adm-disable-fields.
            RUN adm-update-record.
            RUN adm-end-update.
            VNeu       = FALSE.
            VSpeichern = FALSE.
            Btn_Erfassen:LABEL  = '&Erfassen'.
            Btn_Speichern:LABEL = '&Aendern'.
            IF Vorhanden THEN RUN BUTTON_ENABLE ( 2 ).
            ELSE              RUN BUTTON_ENABLE ( 1 ).
        END.

    END CASE.
    
END.

    IF NOT VUpdate THEN RUN state-changed ( INPUT THIS-PROCEDURE, INPUT 'browser_entry' ).

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE state-changed B-table-Win 
PROCEDURE state-changed :
/* -----------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
-------------------------------------------------------------*/
DEFINE INPUT PARAMETER p-issuer-hdl AS HANDLE    NO-UNDO.
DEFINE INPUT PARAMETER p-state      AS CHARACTER NO-UNDO.

CASE p-state:

    WHEN 'browser_entry' THEN DO:
        APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
        RETURN NO-APPLY.
    END.

    {src/adm/template/bstates.i}

END CASE.

END PROCEDURE.

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