&ANALYZE-SUSPEND _VERSION-NUMBER AB_v9r12 GUI ADM2 &ANALYZE-RESUME /* Connected Databases anadat PROGRESS */ &Scoped-define WINDOW-NAME CURRENT-WINDOW &Scoped-define FRAME-NAME gsuchartikel &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gsuchartikel /*------------------------------------------------------------------------ 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 OUTPUT PARAMETER opArtikel 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 VSort AS INT NO-UNDO INIT 1. DEF VAR VSuch1 AS CHAR NO-UNDO INIT ''. DEF VAR VSuch2 AS CHAR NO-UNDO INIT ''. DEF VAR VSuch3 AS CHAR NO-UNDO INIT ''. DEF VAR VSuch4 AS CHAR NO-UNDO INIT ''. DEF VAR VSuch5 AS CHAR NO-UNDO INIT ''. DEF VAR Inhalt AS CHAR NO-UNDO INIT ''. DEF VAR MinNr AS INT NO-UNDO. DEF VAR AnzVorhanden AS INT NO-UNDO. /* _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 gsuchartikel &Scoped-define BROWSE-NAME Br_artikel /* Internal Tables (found by Frame, Query & Browse Queries) */ &Scoped-define INTERNAL-TABLES Artst Artbez /* Definitions for BROWSE Br_artikel */ &Scoped-define FIELDS-IN-QUERY-Br_artikel Artst.Artnr Artst.Inhalt ~ Artst.Jahr Artst.Suchbe Artst.Bez Artst.Bestand Artst.Listen_EP ~ Artst.Alk_Gehalt &Scoped-define ENABLED-FIELDS-IN-QUERY-Br_artikel &Scoped-define OPEN-QUERY-Br_artikel OPEN QUERY Br_artikel FOR EACH Artst NO-LOCK, ~ EACH Artbez OF Artst NO-LOCK INDEXED-REPOSITION. &Scoped-define TABLES-IN-QUERY-Br_artikel Artst Artbez &Scoped-define FIRST-TABLE-IN-QUERY-Br_artikel Artst &Scoped-define SECOND-TABLE-IN-QUERY-Br_artikel Artbez /* Definitions for DIALOG-BOX gsuchartikel */ /* Standard List Definitions */ &Scoped-Define ENABLED-OBJECTS F_Artnr F_Inhalt F_Jahr F_Suchbe F_Bez ~ Br_artikel T_Geloescht RECT-38 &Scoped-Define DISPLAYED-OBJECTS F_Artnr F_Inhalt F_Jahr F_Suchbe F_Bez ~ T_Geloescht /* Custom List Definitions */ /* List-1,List-2,List-3,List-4,List-5,List-6 */ &Scoped-define List-6 F_Artnr F_Inhalt F_Jahr F_Suchbe F_Bez T_Geloescht /* _UIB-PREPROCESSOR-BLOCK-END */ &ANALYZE-RESUME /* *********************** Control Definitions ********************** */ /* Define a dialog box */ /* Definitions of the field level widgets */ DEFINE VARIABLE F_Artnr AS INTEGER FORMAT "999999":U INITIAL 0 LABEL "Artnr" VIEW-AS FILL-IN NATIVE SIZE 11 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Bez AS CHARACTER FORMAT "X(256)":U LABEL "Bezeichnung" VIEW-AS FILL-IN NATIVE SIZE 30 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Inhalt AS INTEGER FORMAT "9999":U INITIAL 0 LABEL "Inhalt" VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Jahr AS INTEGER FORMAT "9999":U INITIAL 0 LABEL "Jahrgang" VIEW-AS FILL-IN NATIVE SIZE 8 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-38 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 105 BY 19.29. DEFINE VARIABLE T_Geloescht AS LOGICAL INITIAL no LABEL "&inaktive ?" VIEW-AS TOGGLE-BOX SIZE 15.2 BY 1 NO-UNDO. /* Query definitions */ &ANALYZE-SUSPEND DEFINE QUERY Br_artikel FOR Artst, Artbez SCROLLING. &ANALYZE-RESUME /* Browse definitions */ DEFINE BROWSE Br_artikel &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS Br_artikel gsuchartikel _STRUCTURED QUERY Br_artikel NO-LOCK DISPLAY Artst.Artnr FORMAT "999999":U WIDTH 7 Artst.Inhalt FORMAT "9999":U WIDTH 6 Artst.Jahr FORMAT "9999":U WIDTH 5 Artst.Suchbe FORMAT "x(15)":U Artst.Bez COLUMN-LABEL "Bezeichnung" FORMAT "x(30)":U Artst.Bestand FORMAT "zzzzz,zz9-":U WIDTH 11 Artst.Listen_EP COLUMN-LABEL "Listen EP" FORMAT "z,zz9.999":U WIDTH 10 Artst.Alk_Gehalt COLUMN-LABEL "Alk%" FORMAT "zz9.9":U WIDTH 5 /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME WITH NO-ROW-MARKERS SEPARATORS SIZE 100 BY 14.76 BGCOLOR 15 . /* ************************ Frame Definitions *********************** */ DEFINE FRAME gsuchartikel F_Artnr AT ROW 1.52 COL 18 COLON-ALIGNED F_Inhalt AT ROW 1.52 COL 40 COLON-ALIGNED F_Jahr AT ROW 1.52 COL 62 COLON-ALIGNED F_Suchbe AT ROW 2.52 COL 18 COLON-ALIGNED F_Bez AT ROW 3.52 COL 18 COLON-ALIGNED Br_artikel AT ROW 5.19 COL 4 T_Geloescht AT ROW 3.52 COL 64.2 NO-TAB-STOP RECT-38 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 "Suche nach Artikeln". /* *********************** 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 gsuchartikel /* ************************* 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 gsuchartikel Custom */ /* BROWSE-TAB Br_artikel F_Bez gsuchartikel */ ASSIGN FRAME gsuchartikel:SCROLLABLE = FALSE FRAME gsuchartikel:HIDDEN = TRUE. ASSIGN Br_artikel:COLUMN-RESIZABLE IN FRAME gsuchartikel = TRUE. /* SETTINGS FOR FILL-IN F_Artnr IN FRAME gsuchartikel 6 */ /* SETTINGS FOR FILL-IN F_Bez IN FRAME gsuchartikel 6 */ /* SETTINGS FOR FILL-IN F_Inhalt IN FRAME gsuchartikel 6 */ /* SETTINGS FOR FILL-IN F_Jahr IN FRAME gsuchartikel 6 */ /* SETTINGS FOR FILL-IN F_Suchbe IN FRAME gsuchartikel 6 */ /* SETTINGS FOR TOGGLE-BOX T_Geloescht IN FRAME gsuchartikel 6 */ /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* Setting information for Queries and Browse Widgets fields */ &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE Br_artikel /* Query rebuild information for BROWSE Br_artikel _TblList = "AnaDat.Artst,AnaDat.Artbez OF AnaDat.Artst" _Options = "NO-LOCK INDEXED-REPOSITION" _FldNameList[1] > AnaDat.Artst.Artnr "Artst.Artnr" ? ? "integer" ? ? ? ? ? ? no ? no no "7" yes no no "U" "" "" _FldNameList[2] > AnaDat.Artst.Inhalt "Artst.Inhalt" ? ? "integer" ? ? ? ? ? ? no ? no no "6" yes no no "U" "" "" _FldNameList[3] > AnaDat.Artst.Jahr "Artst.Jahr" ? ? "integer" ? ? ? ? ? ? no ? no no "5" yes no no "U" "" "" _FldNameList[4] = AnaDat.Artst.Suchbe _FldNameList[5] > AnaDat.Artst.Bez "Artst.Bez" "Bezeichnung" ? "character" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" _FldNameList[6] > AnaDat.Artst.Bestand "Artst.Bestand" ? ? "integer" ? ? ? ? ? ? no ? no no "11" yes no no "U" "" "" _FldNameList[7] > AnaDat.Artst.Listen_EP "Artst.Listen_EP" "Listen EP" ? "decimal" ? ? ? ? ? ? no ? no no "10" yes no no "U" "" "" _FldNameList[8] > AnaDat.Artst.Alk_Gehalt "Artst.Alk_Gehalt" "Alk%" "zz9.9" "decimal" ? ? ? ? ? ? no ? no no "5" yes no no "U" "" "" _Query is NOT OPENED */ /* BROWSE Br_artikel */ &ANALYZE-RESUME &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gsuchartikel /* Query rebuild information for DIALOG-BOX gsuchartikel _Options = "SHARE-LOCK" _Query is NOT OPENED */ /* DIALOG-BOX gsuchartikel */ &ANALYZE-RESUME /* ************************ Control Triggers ************************ */ &Scoped-define SELF-NAME gsuchartikel &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gsuchartikel gsuchartikel ON END-ERROR OF FRAME gsuchartikel /* Suche nach Artikeln */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gsuchartikel gsuchartikel ON GO OF FRAME gsuchartikel /* Suche nach Artikeln */ DO: RUN ENDE_PROGRAMM ( INPUT THIS-PROCEDURE:FILE-NAME ) NO-ERROR. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gsuchartikel gsuchartikel ON WINDOW-CLOSE OF FRAME gsuchartikel /* Suche nach Artikeln */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define BROWSE-NAME Br_artikel &Scoped-define SELF-NAME Br_artikel &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_artikel gsuchartikel ON END-ERROR OF Br_artikel IN FRAME gsuchartikel DO: APPLY 'ENTRY' TO F_Artnr IN FRAME {&FRAME-NAME}. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_artikel gsuchartikel ON RETURN OF Br_artikel IN FRAME gsuchartikel 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). ASSIGN {&List-6}. F_Artnr = Artst.Artnr. VSuch1 = TRIM(STRING(F_Artnr ,'zzzzzzzz')). F_Inhalt = Artst.Inhalt. VSuch2 = TRIM(STRING(F_Inhalt,'zzzzzzzz')). F_Jahr = Artst.Jahr . VSuch3 = TRIM(STRING(F_Jahr ,'zzzzzzzz')). VSuch4 = F_Suchbe. VSuch5 = F_Bez . {&BROWSE-NAME}:FETCH-SELECTED-ROW(1). opArtikel = STRING(RECID(Artst)) + CHR(01) + Artst.Firma + CHR(01) + STRING(Artst.Artnr) + CHR(01) + STRING(Artst.Inhalt) + CHR(01) + STRING(Artst.Jahr) + CHR(01) + STRING(VSort) + CHR(01). IF VSort <> 1 THEN VSuch1 = ''. IF VSort <> 2 THEN VSuch2 = ''. IF VSort <> 3 THEN VSuch3 = ''. IF VSort <> 4 THEN VSuch4 = ''. IF VSort <> 5 THEN VSuch5 = ''. opArtikel = opArtikel + VSuch1 + CHR(01) + VSuch2 + CHR(01) + VSuch3 + CHR(01) + VSuch4 + CHR(01) + VSuch5 + CHR(01). END. RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_artikel gsuchartikel ON ROW-DISPLAY OF Br_artikel IN FRAME gsuchartikel DO: DEF VAR Farbe AS INT NO-UNDO. IF NOT AVAILABLE Artst THEN RETURN. DO WITH FRAME {&FRAME-NAME}: Farbe = 15. IF Artst.Ausverk > 1 THEN Farbe = 14. IF Artst.Aktiv = FALSE THEN Farbe = 12. Artst.Artnr :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe. Artst.Inhalt :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe. Artst.Jahr :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe. Artst.Suchbe :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe. Artst.Bez :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe. Artst.Bestand:BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Artnr &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Artnr gsuchartikel ON ENTRY OF F_Artnr IN FRAME gsuchartikel /* Artnr */ DO: VSuch1 = ''. vSuch2 = ''. VSuch3 = ''. VSuch4 = ''. VSuch5 = ''. DO WITH FRAME {&FRAME-NAME}: F_Inhalt:SCREEN-VALUE = ''. F_Jahr :SCREEN-VALUE = ''. F_Suchbe:SCREEN-VALUE = ''. F_Bez :SCREEN-VALUE = ''. F_Artnr :SCREEN-VALUE = ''. F_Artnr :SET-SELECTION(1, 7). END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Artnr gsuchartikel ON LEAVE OF F_Artnr IN FRAME gsuchartikel /* Artnr */ DO: DEF VAR iArtnr AS INT NO-UNDO. VSuch1 = SELF:SCREEN-VALUE. VSuch1 = TRIM(STRING(INTEGER(VSuch1),'zzzzzz')). IF VSuch1 <> '' THEN DO: iArtnr = INTEGER(VSuch1). DO WHILE iArtnr LT MinNr: iArtnr = iArtnr * 10. END. VSuch1 = STRING(iArtnr). SELF:SCREEN-VALUE = VSuch1. RUN OPENQUERY. IF NOT LASTKEY = KEYCODE('RETURN') THEN RETURN. IF AnzVorhanden = 0 THEN RETURN. IF AnzVorhanden > 1 THEN DO: APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}. RETURN NO-APPLY. END. APPLY 'RETURN' TO BROWSE {&BROWSE-NAME}. RETURN NO-APPLY. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Bez &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Bez gsuchartikel ON END-ERROR OF F_Bez IN FRAME gsuchartikel /* Bezeichnung */ DO: APPLY 'ENTRY' TO F_Artnr IN FRAME {&FRAME-NAME}. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Bez gsuchartikel ON LEAVE OF F_Bez IN FRAME gsuchartikel /* Bezeichnung */ DO: VSuch5 = SELF:SCREEN-VALUE. IF VSuch5 <> '' THEN DO WITH FRAME {&FRAME-NAME}: RUN OPENQUERY. IF NOT LASTKEY = KEYCODE('RETURN') THEN RETURN. IF AnzVorhanden = 0 THEN RETURN. IF AnzVorhanden > 1 THEN DO: APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}. RETURN NO-APPLY. END. APPLY 'RETURN' TO BROWSE {&BROWSE-NAME}. RETURN NO-APPLY. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Bez gsuchartikel ON VALUE-CHANGED OF F_Bez IN FRAME gsuchartikel /* Bezeichnung */ DO: VSuch5 = SELF:SCREEN-VALUE. IF VSuch5 <> '' THEN RUN OPENQUERY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Inhalt &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Inhalt gsuchartikel ON END-ERROR OF F_Inhalt IN FRAME gsuchartikel /* Inhalt */ DO: APPLY 'ENTRY' TO F_Artnr IN FRAME {&FRAME-NAME}. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Inhalt gsuchartikel ON LEAVE OF F_Inhalt IN FRAME gsuchartikel /* Inhalt */ DO: VSuch2 = SELF:SCREEN-VALUE. VSuch2 = TRIM(STRING(INTEGER(Vsuch2),'zzzzzz')). IF VSuch2 <> '' THEN DO WITH FRAME {&FRAME-NAME}: RUN OPENQUERY. IF NOT LASTKEY = KEYCODE('RETURN') THEN RETURN. IF AnzVorhanden = 0 THEN RETURN. IF AnzVorhanden > 1 THEN DO: APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}. RETURN NO-APPLY. END. APPLY 'RETURN' TO BROWSE {&BROWSE-NAME}. RETURN NO-APPLY. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Jahr &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Jahr gsuchartikel ON END-ERROR OF F_Jahr IN FRAME gsuchartikel /* Jahrgang */ DO: APPLY 'ENTRY' TO F_Artnr IN FRAME {&FRAME-NAME}. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Jahr gsuchartikel ON LEAVE OF F_Jahr IN FRAME gsuchartikel /* Jahrgang */ DO: VSuch3 = SELF:SCREEN-VALUE. VSuch3 = TRIM(STRING(INTEGER(VSuch3),'zzzzzz')). IF VSuch3 <> '' THEN DO WITH FRAME {&FRAME-NAME}: RUN OPENQUERY. IF NOT LASTKEY = KEYCODE('RETURN') THEN RETURN. IF AnzVorhanden = 0 THEN RETURN. IF AnzVorhanden > 1 THEN DO: APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}. RETURN NO-APPLY. END. APPLY 'RETURN' TO BROWSE {&BROWSE-NAME}. RETURN NO-APPLY. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Suchbe &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Suchbe gsuchartikel ON END-ERROR OF F_Suchbe IN FRAME gsuchartikel /* Suchbegriff */ DO: APPLY 'ENTRY' TO F_Artnr IN FRAME {&FRAME-NAME}. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Suchbe gsuchartikel ON LEAVE OF F_Suchbe IN FRAME gsuchartikel /* Suchbegriff */ DO: VSuch4 = SELF:SCREEN-VALUE. IF VSuch4 <> '' THEN DO WITH FRAME {&FRAME-NAME}: RUN OPENQUERY. IF NOT LASTKEY = KEYCODE('RETURN') THEN RETURN. IF AnzVorhanden = 0 THEN RETURN. IF AnzVorhanden > 1 THEN DO: APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}. RETURN NO-APPLY. END. APPLY 'RETURN' TO BROWSE {&BROWSE-NAME}. RETURN NO-APPLY. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Suchbe gsuchartikel ON VALUE-CHANGED OF F_Suchbe IN FRAME gsuchartikel /* Suchbegriff */ DO: VSuch4 = SELF:SCREEN-VALUE. IF VSuch4 <> '' THEN RUN OPENQUERY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME T_Geloescht &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL T_Geloescht gsuchartikel ON VALUE-CHANGED OF T_Geloescht IN FRAME gsuchartikel /* inaktive ? */ DO: DEF VAR xHandle AS HANDLE NO-UNDO. xHandle = ?. DO WITH FRAME {&FRAME-NAME}: IF F_Bez :SCREEN-VALUE <> '' THEN xHandle = F_Bez :HANDLE. IF F_Suchbe:SCREEN-VALUE <> '' THEN xHandle = F_Suchbe:HANDLE. IF F_Jahr :SCREEN-VALUE <> '0000' THEN xHandle = F_Jahr :HANDLE. IF F_Inhalt:SCREEN-VALUE <> '0000' THEN xHandle = F_Inhalt:HANDLE. IF NOT VALID-HANDLE(xHandle) THEN xHandle = F_Artnr:HANDLE. APPLY 'ENTRY' TO xHandle. CASE xHandle:NAME: WHEN 'F_Artnr' THEN RETURN NO-APPLY. WHEN 'F_Inhalt' THEN RETURN NO-APPLY. WHEN 'F_Jahr' THEN RETURN NO-APPLY. END CASE. IF xHandle:SCREEN-VALUE = '' THEN RETURN NO-APPLY. APPLY 'VALUE-CHANGED' TO xHandle. RETURN NO-APPLY. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gsuchartikel /* *************************** Main Block *************************** */ opArtikel = ''. MaxPage = 1. AktSeite = 1. Firma = DYNAMIC-FUNCTION('GETMANDANT':U). DEF VAR ix AS INT NO-UNDO. FIND Steuer USE-INDEX Steuer-k1 WHERE Steuer.Firma = Firma NO-LOCK NO-ERROR. MinNr = 1. IF AVAILABLE Steuer THEN DO: DO ix = 2 TO DYNAMIC-FUNCTION('GETMINARTNR':U) : MinNr = MinNr * 10. END. END. SESSION:DATA-ENTRY-RETURN = TRUE. /* TRIGGERS ------------------------------------------------------ */ ON 'CURSOR-DOWN':U OF F_Artnr , F_Inhalt, F_Jahr , F_Suchbe , F_Bez 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 gsuchartikel _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 gsuchartikel 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 disable_UI gsuchartikel _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 gsuchartikel. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gsuchartikel PROCEDURE enableObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR hColumn AS HANDLE NO-UNDO. DEF VAR cBreite AS CHAR NO-UNDO. DEF VAR cString AS CHAR NO-UNDO. GET-KEY-VALUE SECTION 'GrundEinstellungen' KEY 'EpAufArtikelSuchen' VALUE cString. IF cString = ? THEN cString = 'nein'. DO WITH FRAME {&FRAME-NAME}: IF cString BEGINS 'n' THEN Artst.Listen_EP:VISIBLE IN BROWSE {&BROWSE-NAME} = FALSE. ELSE Artst.Listen_EP:VISIBLE IN BROWSE {&BROWSE-NAME} = TRUE . hColumn = {&BROWSE-NAME}:FIRST-COLUMN IN FRAME {&FRAME-NAME}. DO WHILE VALID-HANDLE(hColumn): IF hColumn:VISIBLE = TRUE THEN DO: GET-KEY-VALUE SECTION 'ArtikelSuchBrowser' KEY hColumn:NAME VALUE cBreite. DO WHILE TRUE WITH FRAME {&FRAME-NAME}: IF cBreite = ? THEN LEAVE. IF cBreite = '' THEN LEAVE. IF DECIMAL(cBreite) < 2 THEN cBreite = '2'. hColumn:WIDTH = DECIMAL(cBreite). LEAVE. END. END. hColumn = hColumn:NEXT-COLUMN. END. END. 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 gsuchartikel _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_Artnr F_Inhalt F_Jahr F_Suchbe F_Bez T_Geloescht WITH FRAME gsuchartikel. ENABLE F_Artnr F_Inhalt F_Jahr F_Suchbe F_Bez Br_artikel T_Geloescht RECT-38 WITH FRAME gsuchartikel. VIEW FRAME gsuchartikel. {&OPEN-BROWSERS-IN-QUERY-gsuchartikel} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gsuchartikel 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. DEF VAR hColumn AS HANDLE NO-UNDO. DO WITH FRAME {&FRAME-NAME}: hColumn = {&BROWSE-NAME}:FIRST-COLUMN. DO WHILE VALID-HANDLE(hColumn): PUT-KEY-VALUE SECTION 'ArtikelSuchBrowser' KEY hColumn:NAME VALUE STRING(hColumn:WIDTH). hColumn = hColumn:NEXT-COLUMN. END. 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 gsuchartikel 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 gsuchartikel 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 gsuchartikel 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 gsuchartikel PROCEDURE OPENQUERY : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR FAktiv AS LOG NO-UNDO. DO WITH FRAME {&FRAME-NAME}: ASSIGN {&list-6}. IF T_Geloescht = TRUE THEN FAktiv = FALSE. ELSE FAktiv = TRUE. END. VSort = 1. IF VSuch5 <> '' AND INDEX(VSuch5, '*') = 0 THEN VSort = 5. IF VSuch4 <> '' AND INDEX(VSuch4, '*') = 0 THEN VSort = 4. IF VSuch3 <> '' AND INDEX(VSuch3, '*') = 0 THEN VSort = 3. IF VSuch2 <> '' AND INDEX(VSuch2, '*') = 0 THEN VSort = 2. IF VSuch1 <> '' AND INDEX(VSuch1, '*') = 0 THEN VSort = 1. SESSION:SET-WAIT-STATE('GENERAL'). CASE VSort: WHEN 1 THEN DO: OPEN QUERY {&BROWSE-NAME} FOR EACH Artst USE-INDEX Artst-k1 WHERE Artst.Firma = Firma AND Artst.Aktiv = FAktiv AND Artst.Artnr >= INTEGER(VSuch1) AND (IF VSuch2 <> '' THEN Artst.Inhalt = INTEGER(VSuch2) ELSE Artst.Inhalt >= 0 ) AND (IF VSuch3 <> '' THEN Artst.Jahr = INTEGER(VSuch3) ELSE Artst.Jahr >= 0 ) AND (IF INDEX(VSuch4, '*') = 0 THEN Artst.Suchbe BEGINS VSuch4 ELSE Artst.Suchbe MATCHES VSuch4) AND (IF INDEX(VSuch5, '*') = 0 THEN Artst.Bez BEGINS VSuch5 ELSE Artst.Bez MATCHES VSuch5) NO-LOCK, FIRST Artbez OF Artst WHERE Artbez.Zustext[01] <> '' OR Artbez.Zustext[02] <> '' NO-LOCK. END. WHEN 2 THEN DO: OPEN QUERY {&BROWSE-NAME} FOR EACH Artst USE-INDEX Artst-k1 WHERE Artst.Firma = Firma AND Artst.Aktiv = FAktiv AND Artst.Inhalt = INTEGER(VSuch2) AND (IF VSuch3 <> '' THEN Artst.Jahr = INTEGER(VSuch3) ELSE Artst.Jahr >= 0 ) AND (IF INDEX(VSuch4, '*') = 0 THEN Artst.Suchbe BEGINS VSuch4 ELSE Artst.Suchbe MATCHES VSuch4) AND (IF INDEX(VSuch5, '*') = 0 THEN Artst.Bez BEGINS VSuch5 ELSE Artst.Bez MATCHES VSuch5) NO-LOCK, FIRST Artbez OF Artst WHERE Artbez.Zustext[01] <> '' OR Artbez.Zustext[02] <> '' NO-LOCK. END. WHEN 3 THEN DO: OPEN QUERY {&BROWSE-NAME} FOR EACH Artst USE-INDEX Artst-k1 WHERE Artst.Firma = Firma AND Artst.Aktiv = FAktiv AND Artst.Jahr = INTEGER(VSuch3) AND (IF INDEX(VSuch4, '*') = 0 THEN Artst.Suchbe BEGINS VSuch4 ELSE Artst.Suchbe MATCHES VSuch4) AND (IF INDEX(VSuch5, '*') = 0 THEN Artst.Bez BEGINS VSuch5 ELSE Artst.Bez MATCHES VSuch5) NO-LOCK, FIRST Artbez OF Artst WHERE Artbez.Zustext[01] <> '' OR Artbez.Zustext[02] <> '' NO-LOCK. END. WHEN 4 THEN DO: OPEN QUERY {&BROWSE-NAME} FOR EACH Artst USE-INDEX Artst-k2 WHERE Artst.Firma = Firma AND Artst.Aktiv = FAktiv AND Artst.Suchbe BEGINS VSuch4 AND (IF INDEX(VSuch5, '*') = 0 THEN Artst.Bez BEGINS VSuch5 ELSE Artst.Bez MATCHES VSuch5) NO-LOCK, FIRST Artbez OF Artst WHERE Artbez.Zustext[01] <> '' OR Artbez.Zustext[02] <> '' NO-LOCK. END. WHEN 5 THEN DO: OPEN QUERY {&BROWSE-NAME} FOR EACH Artst USE-INDEX Artst-k3 WHERE Artst.Firma = Firma AND Artst.Aktiv = FAktiv AND Artst.Bez BEGINS VSuch5 AND (IF INDEX(VSuch4, '*') = 0 THEN Artst.Suchbe BEGINS VSuch4 ELSE Artst.Suchbe MATCHES VSuch4) NO-LOCK, FIRST Artbez OF Artst WHERE Artbez.Zustext[01] <> '' OR Artbez.Zustext[02] <> '' NO-LOCK. END. END CASE. SESSION:SET-WAIT-STATE(''). AnzVorhanden = NUM-RESULTS('{&BROWSE-NAME}') NO-ERROR. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE PREVPAGE gsuchartikel 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 gsuchartikel 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 gsuchartikel 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