&ANALYZE-SUSPEND _VERSION-NUMBER AB_v9r12 GUI ADM2 &ANALYZE-RESUME /* Connected Databases anadat PROGRESS */ &Scoped-define WINDOW-NAME CURRENT-WINDOW &Scoped-define FRAME-NAME gArtikelauswahl &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gArtikelauswahl /*------------------------------------------------------------------------ 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 ipStart AS CHAR NO-UNDO. DEF OUTPUT PARAMETER opAdresse 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 Firma AS CHAR NO-UNDO INIT ''. DEF VAR AdFirma AS CHAR NO-UNDO INIT ''. DEF VAR VSort AS INT NO-UNDO INIT 1. DEF VAR Knr AS INT NO-UNDO INIT 1. DEF VAR Inhalt AS CHAR NO-UNDO INIT ''. /* _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 gArtikelauswahl &Scoped-define BROWSE-NAME Br_Debitor /* Internal Tables (found by Frame, Query & Browse Queries) */ &Scoped-define INTERNAL-TABLES Adresse Debst /* Definitions for BROWSE Br_Debitor */ &Scoped-define FIELDS-IN-QUERY-Br_Debitor Adresse.Knr Adresse.Anzeig_br &Scoped-define ENABLED-FIELDS-IN-QUERY-Br_Debitor &Scoped-define OPEN-QUERY-Br_Debitor OPEN QUERY Br_Debitor FOR EACH Adresse NO-LOCK, ~ EACH Debst OF Adresse NO-LOCK INDEXED-REPOSITION. &Scoped-define TABLES-IN-QUERY-Br_Debitor Adresse Debst &Scoped-define FIRST-TABLE-IN-QUERY-Br_Debitor Adresse &Scoped-define SECOND-TABLE-IN-QUERY-Br_Debitor Debst /* Definitions for DIALOG-BOX gArtikelauswahl */ /* Standard List Definitions */ &Scoped-Define ENABLED-OBJECTS Br_Debitor F_Knr F_Suchbe RECT-8 &Scoped-Define DISPLAYED-OBJECTS F_Knr F_Suchbe /* Custom List Definitions */ /* List-1,List-2,List-3,List-4,List-5,List-6 */ &Scoped-define List-6 F_Knr F_Suchbe /* _UIB-PREPROCESSOR-BLOCK-END */ &ANALYZE-RESUME /* *********************** Control Definitions ********************** */ /* Define a dialog box */ /* Definitions of the field level widgets */ DEFINE VARIABLE F_Knr AS INTEGER FORMAT "999999":U INITIAL 0 LABEL "Knr" VIEW-AS FILL-IN NATIVE SIZE 11 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Suchbe AS CHARACTER FORMAT "X(256)":U LABEL "Suchbegriff" VIEW-AS FILL-IN NATIVE SIZE 20 BY 1 BGCOLOR 15 NO-UNDO. DEFINE RECTANGLE RECT-8 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 94 BY 11.91. /* Query definitions */ &ANALYZE-SUSPEND DEFINE QUERY Br_Debitor FOR Adresse, Debst SCROLLING. &ANALYZE-RESUME /* Browse definitions */ DEFINE BROWSE Br_Debitor &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS Br_Debitor gArtikelauswahl _STRUCTURED QUERY Br_Debitor NO-LOCK DISPLAY Adresse.Knr FORMAT "zzzzzz9":U WIDTH 8 Adresse.Anzeig_br COLUMN-LABEL "Kunde" FORMAT "x(75)":U /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME WITH NO-ROW-MARKERS SEPARATORS SIZE 89 BY 8.67 BGCOLOR 15 EXPANDABLE. /* ************************ Frame Definitions *********************** */ DEFINE FRAME gArtikelauswahl Br_Debitor AT ROW 4.1 COL 5 F_Knr AT ROW 1.52 COL 18 COLON-ALIGNED AUTO-RETURN F_Suchbe AT ROW 2.52 COL 18 COLON-ALIGNED AUTO-RETURN RECT-8 AT ROW 1.24 COL 2 SPACE(0.99) SKIP(0.22) WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE TITLE "Debitorauswahl". /* *********************** 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 gArtikelauswahl /* ************************* 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 gArtikelauswahl Custom */ /* BROWSE-TAB Br_Debitor 1 gArtikelauswahl */ ASSIGN FRAME gArtikelauswahl:SCROLLABLE = FALSE FRAME gArtikelauswahl:HIDDEN = TRUE. /* SETTINGS FOR FILL-IN F_Knr IN FRAME gArtikelauswahl 6 */ /* SETTINGS FOR FILL-IN F_Suchbe IN FRAME gArtikelauswahl 6 */ /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* Setting information for Queries and Browse Widgets fields */ &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE Br_Debitor /* Query rebuild information for BROWSE Br_Debitor _TblList = "AnaDat.Adresse,AnaDat.Debst OF AnaDat.Adresse" _Options = "NO-LOCK INDEXED-REPOSITION" _FldNameList[1] > AnaDat.Adresse.Knr "Adresse.Knr" ? ? "integer" ? ? ? ? ? ? no ? no no "8" yes no no "U" "" "" _FldNameList[2] > AnaDat.Adresse.Anzeig_br "Adresse.Anzeig_br" "Kunde" ? "character" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" _Query is NOT OPENED */ /* BROWSE Br_Debitor */ &ANALYZE-RESUME &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gArtikelauswahl /* Query rebuild information for DIALOG-BOX gArtikelauswahl _Options = "SHARE-LOCK" _Query is NOT OPENED */ /* DIALOG-BOX gArtikelauswahl */ &ANALYZE-RESUME /* ************************ Control Triggers ************************ */ &Scoped-define SELF-NAME gArtikelauswahl &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gArtikelauswahl gArtikelauswahl ON END-ERROR OF FRAME gArtikelauswahl /* Debitorauswahl */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gArtikelauswahl gArtikelauswahl ON GO OF FRAME gArtikelauswahl /* Debitorauswahl */ DO: RUN ENDE_PROGRAMM ( INPUT THIS-PROCEDURE:FILE-NAME ) NO-ERROR. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gArtikelauswahl gArtikelauswahl ON WINDOW-CLOSE OF FRAME gArtikelauswahl /* Debitorauswahl */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define BROWSE-NAME Br_Debitor &Scoped-define SELF-NAME Br_Debitor &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_Debitor gArtikelauswahl ON END-ERROR OF Br_Debitor IN FRAME gArtikelauswahl DO: IF VSort = 1 THEN APPLY 'ENTRY' TO F_Knr IN FRAME {&FRAME-NAME}. IF VSort = 2 THEN APPLY 'ENTRY' TO F_Suchbe IN FRAME {&FRAME-NAME}. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_Debitor gArtikelauswahl ON RETURN OF Br_Debitor IN FRAME gArtikelauswahl DO: DO WITH FRAME {&FRAME-NAME}: IF NUM-RESULTS('{&BROWSE-NAME}') = ? THEN RETURN NO-APPLY. IF NUM-RESULTS('{&BROWSE-NAME}') = 0 THEN RETURN NO-APPLY. IF {&BROWSE-NAME}:NUM-SELECTED-ROWS = 0 THEN RETURN NO-APPLY. {&BROWSE-NAME}:FETCH-SELECTED-ROW(1). opAdresse = STRING(RECID(Adresse)) + CHR(01) + STRING(Adresse.Knr) + CHR(01) + Adresse.Anzeig_Br. END. RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Knr &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Knr gArtikelauswahl ON ENTRY OF F_Knr IN FRAME gArtikelauswahl /* Knr */ DO: SELF:SCREEN-VALUE = '0'. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Knr gArtikelauswahl ON LEAVE OF F_Knr IN FRAME gArtikelauswahl /* Knr */ DO: DO WITH FRAME {&FRAME-NAME}: IF KEYFUNCTION(LASTKEY) = 'END-ERROR' THEN RETURN. IF KEYFUNCTION(LASTKEY) = 'BACK-TAB' THEN RETURN. Inhalt = SELF:SCREEN-VALUE. IF INTEGER(Inhalt) = 0 THEN APPLY 'ENTRY' TO F_Suchbe. ELSE APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}. SELF:SCREEN-VALUE = '0'. END. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Knr gArtikelauswahl ON RETURN OF F_Knr IN FRAME gArtikelauswahl /* Knr */ DO: APPLY 'TAB' TO SELF. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Knr gArtikelauswahl ON VALUE-CHANGED OF F_Knr IN FRAME gArtikelauswahl /* Knr */ DO: RUN OPENQUERY. RETURN. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Suchbe &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Suchbe gArtikelauswahl ON END-ERROR OF F_Suchbe IN FRAME gArtikelauswahl /* Suchbegriff */ DO: SELF:SCREEN-VALUE = ''. APPLY 'ENTRY' TO F_Knr IN FRAME {&FRAME-NAME}. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Suchbe gArtikelauswahl ON ENTRY OF F_Suchbe IN FRAME gArtikelauswahl /* Suchbegriff */ DO: SELF:SCREEN-VALUE = ''. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Suchbe gArtikelauswahl ON LEAVE OF F_Suchbe IN FRAME gArtikelauswahl /* Suchbegriff */ DO: DO WITH FRAME {&FRAME-NAME}: IF KEYFUNCTION(LASTKEY) = 'END-ERROR' THEN RETURN. IF KEYFUNCTION(LASTKEY) = 'BACK-TAB' THEN RETURN. Inhalt = SELF:SCREEN-VALUE. SELF:SCREEN-VALUE = ''. IF Inhalt = '' THEN APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}. ELSE APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}. END. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Suchbe gArtikelauswahl ON RETURN OF F_Suchbe IN FRAME gArtikelauswahl /* Suchbegriff */ DO: APPLY 'TAB' TO SELF. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Suchbe gArtikelauswahl ON VALUE-CHANGED OF F_Suchbe IN FRAME gArtikelauswahl /* Suchbegriff */ DO: RUN OPENQUERY. RETURN. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gArtikelauswahl /* *************************** Main Block *************************** */ DEF VAR ix AS INT NO-UNDO. opAdresse = ''. MaxPage = 1. AktSeite = 1. Firma = DYNAMIC-FUNCTION('GETMANDANT':U ). AdFirma = DYNAMIC-FUNCTION('GETADMANDANT':U). IF NUM-ENTRIES(ipStart, CHR(01)) < 1 THEN DO: ipStart = '1' + CHR(01) + '1'. END. DO WHILE TRUE WITH FRAME {&FRAME-NAME}: IF ENTRY(1, ipStart, CHR(01)) = '2' THEN DO: F_Suchbe = ENTRY(2, ipStart, CHR(01)). F_Knr = 0. LEAVE. END. F_Knr = INTEGER(ENTRY(2, ipStart, CHR(01))) NO-ERROR. F_Suchbe = ''. IF F_Knr = ? THEN F_Knr = 1. IF F_Knr = 0 THEN F_Knr = 1. LEAVE. END. SESSION:DATA-ENTRY-RETURN = TRUE. /* TRIGGERS ------------------------------------------------------ */ ON 'CURSOR-DOWN':U OF F_Knr IN FRAME {&FRAME-NAME}, F_Suchbe IN FRAME {&FRAME-NAME} DO: APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}. 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 gArtikelauswahl _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 gArtikelauswahl 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 ENTRY_CURSOR. END. END CASE. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI gArtikelauswahl _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 gArtikelauswahl. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gArtikelauswahl PROCEDURE enableObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ RUN SUPER. RUN FENSTER_TITEL ( INPUT FRAME {&FRAME-NAME}:HANDLE ) NO-ERROR. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gArtikelauswahl _DEFAULT-ENABLE PROCEDURE enable_UI : /*------------------------------------------------------------------------------ Purpose: ENABLE the User Interface Parameters: Notes: Here we display/view/enable the widgets in the user-interface. In addition, OPEN all queries associated with each FRAME and BROWSE. These statements here are based on the "Other Settings" section of the widget Property Sheets. ------------------------------------------------------------------------------*/ DISPLAY F_Knr F_Suchbe WITH FRAME gArtikelauswahl. ENABLE Br_Debitor F_Knr F_Suchbe RECT-8 WITH FRAME gArtikelauswahl. VIEW FRAME gArtikelauswahl. {&OPEN-BROWSERS-IN-QUERY-gArtikelauswahl} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gArtikelauswahl 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 gArtikelauswahl PROCEDURE ENTRY_CURSOR : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U). CASE AktSeite: /* WHEN 1 THEN RUN applyEntry IN h_v-adresse ( INPUT ? ). */ /* WHEN 2 THEN RUN applyEntry IN h_f-adrkomm ( INPUT ? ). */ /* WHEN 3 THEN RUN applyEntry IN h_b-auftbb ( INPUT ? ). */ /* WHEN 4 THEN RUN applyEntry IN h_b-aufdet ( INPUT ? ). */ /* WHEN 5 THEN RUN applyEntry IN h_b-aufstreu ( INPUT ? ). */ /* WHEN 6 THEN RUN applyEntry IN h_b-auffak ( INPUT ? ). */ /* WHEN 7 THEN RUN applyEntry IN h_b-position ( INPUT ? ). */ END CASE. RETURN NO-APPLY. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE exitObject gArtikelauswahl 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 gArtikelauswahl 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 OPENQUERY gArtikelauswahl PROCEDURE OPENQUERY : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR Knr AS INT NO-UNDO. DEF VAR Such AS CHAR NO-UNDO. DO WITH FRAME {&FRAME-NAME}: ASSIGN {&List-6}. IF F_Knr = 0 THEN VSort = 2. ELSE VSort = 1. END. CASE VSort: WHEN 1 THEN Knr = F_Knr . WHEN 2 THEN Inhalt = F_Suchbe. END CASE. CASE VSort: WHEN 1 THEN DO: OPEN QUERY {&BROWSE-NAME} FOR EACH Adresse USE-INDEX Adresse-k1 WHERE Adresse.Firma = AdFirma AND Adresse.Aktiv = TRUE AND Adresse.Knr >= Knr NO-LOCK, FIRST Debst USE-INDEX Debst-k1 WHERE Debst.Firma = Firma AND Debst.Knr = Adresse.Knr AND Debst.Aktiv = TRUE NO-LOCK. END. WHEN 2 THEN DO: OPEN QUERY {&BROWSE-NAME} FOR EACH Adresse USE-INDEX Adresse-k2 WHERE Adresse.Firma = Firma AND Adresse.Aktiv = TRUE AND Adresse.Suchbe BEGINS Inhalt NO-LOCK, FIRST Debst USE-INDEX Debst-k1 WHERE Debst.Firma = Firma AND Debst.Knr = Adresse.Knr AND Debst.Aktiv = TRUE NO-LOCK. END. END CASE. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE PREVPAGE gArtikelauswahl 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 gArtikelauswahl 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 TOOLBAR gArtikelauswahl 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 gArtikelauswahl PROCEDURE viewObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ RUN SUPER. RUN OPENQUERY. DO WITH FRAME {&FRAME-NAME}: F_Knr:SCREEN-VALUE = '0'. F_Suchbe:SCREEN-VALUE = ''. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME