&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: Output Parameters: ------------------------------------------------------------------------*/ /* 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 &BROWSE-NAME ************************** * Set attributes related to FOREIGN KEYS */ RUN set-attribute-list ( 'Keys-Accepted = "", Keys-Supplied = ""':U). /************************** */ /* _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 &BROWSE-NAME ************************ * Set attributes related to SORTBY-OPTIONS */ RUN set-attribute-list ( 'SortBy-Options = ""':U). /************************ */ /* _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: ------------------------------------------------------------------------------*/ /* 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: 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: 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: 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: 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: 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: 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: 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