&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: Output Parameters: Author: Created: ------------------------------------------------------------------------*/ /* This .W file was created with the Progress AppBuilder. */ /*----------------------------------------------------------------------*/ /* Create an unnamed pool to store all the widgets created by this procedure. This is a good default which assures that this procedure's triggers and internal procedures will execute in this procedure's storage, and that proper cleanup will occur on deletion of the procedure. */ CREATE WIDGET-POOL. /* *************************** Definitions ************************** */ /* Parameters Definitions --- */ DEF 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: ------------------------------------------------------------------------------*/ 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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