&ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2 &ANALYZE-RESUME /* Connected Databases anadat PROGRESS */ &Scoped-define WINDOW-NAME CURRENT-WINDOW &Scoped-define FRAME-NAME gSuchenFemeld {adecomm/appserv.i} &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gSuchenFemeld /*------------------------------------------------------------------------ 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 opNummer AS INT NO-UNDO. /* Local Variable Definitions --- */ DEF VAR hQuery AS HANDLE NO-UNDO. { incl/dlgdefinition.i } { src/adm2/widgetprto.i } /* _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 designated FRAME-NAME and/or first browse and/or first query */ &Scoped-define FRAME-NAME gSuchenFemeld &Scoped-define BROWSE-NAME Br_SuchenFemeld /* Internal Tables (found by Frame, Query & Browse Queries) */ &Scoped-define INTERNAL-TABLES Femeld /* Definitions for BROWSE Br_SuchenFemeld */ &Scoped-define FIELDS-IN-QUERY-Br_SuchenFemeld Femeld.Fenr Femeld.Fetext &Scoped-define ENABLED-FIELDS-IN-QUERY-Br_SuchenFemeld &Scoped-define QUERY-STRING-Br_SuchenFemeld FOR EACH Femeld NO-LOCK INDEXED-REPOSITION &Scoped-define OPEN-QUERY-Br_SuchenFemeld OPEN QUERY Br_SuchenFemeld FOR EACH Femeld NO-LOCK INDEXED-REPOSITION. &Scoped-define TABLES-IN-QUERY-Br_SuchenFemeld Femeld &Scoped-define FIRST-TABLE-IN-QUERY-Br_SuchenFemeld Femeld /* Definitions for DIALOG-BOX gSuchenFemeld */ /* Standard List Definitions */ &Scoped-Define ENABLED-OBJECTS RECT-2 F_Suchbe Br_SuchenFemeld Btn_OK ~ Btn_Cancel &Scoped-Define DISPLAYED-OBJECTS F_Suchbe /* 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 "SmartDialogCues" gSuchenFemeld _INLINE /* Actions: adecomm/_so-cue.w ? adecomm/_so-cued.p ? adecomm/_so-cuew.p */ /* SmartDialog,ab,49267 Destroy on next read */ /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* *********************** Control Definitions ********************** */ /* Define a dialog box */ /* Definitions of the field level widgets */ DEFINE BUTTON Btn_Cancel LABEL "abbrechen" SIZE 15 BY 1. DEFINE BUTTON Btn_OK AUTO-GO LABEL "OK" SIZE 15 BY 1. DEFINE VARIABLE F_Suchbe AS CHARACTER FORMAT "X(256)":U LABEL "Text" VIEW-AS FILL-IN NATIVE SIZE 40 BY 1 BGCOLOR 15 NO-UNDO. DEFINE RECTANGLE RECT-2 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 94 BY 8.57. /* Query definitions */ &ANALYZE-SUSPEND DEFINE QUERY Br_SuchenFemeld FOR Femeld SCROLLING. &ANALYZE-RESUME /* Browse definitions */ DEFINE BROWSE Br_SuchenFemeld &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS Br_SuchenFemeld gSuchenFemeld _STRUCTURED QUERY Br_SuchenFemeld NO-LOCK DISPLAY Femeld.Fenr FORMAT "zzzz":U Femeld.Fetext FORMAT "x(70)":U WIDTH 78.4 /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME WITH NO-ROW-MARKERS SEPARATORS SIZE 90 BY 7.62 FIT-LAST-COLUMN. /* ************************ Frame Definitions *********************** */ DEFINE FRAME gSuchenFemeld F_Suchbe AT ROW 1.52 COL 7 COLON-ALIGNED WIDGET-ID 4 Br_SuchenFemeld AT ROW 3.38 COL 5 WIDGET-ID 200 Btn_OK AT ROW 11.86 COL 20.2 Btn_Cancel AT ROW 11.86 COL 66.2 RECT-2 AT ROW 2.91 COL 3 WIDGET-ID 2 SPACE(1.79) SKIP(2.46) WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE TITLE "Meldung suchen" WIDGET-ID 100. /* *********************** 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 APPSERVER */ &ANALYZE-RESUME _END-PROCEDURE-SETTINGS &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB gSuchenFemeld /* ************************* 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 gSuchenFemeld FRAME-NAME */ /* BROWSE-TAB Br_SuchenFemeld F_Suchbe gSuchenFemeld */ ASSIGN FRAME gSuchenFemeld:SCROLLABLE = FALSE FRAME gSuchenFemeld:HIDDEN = TRUE. /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* Setting information for Queries and Browse Widgets fields */ &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE Br_SuchenFemeld /* Query rebuild information for BROWSE Br_SuchenFemeld _TblList = "AnaDat.Femeld" _Options = "NO-LOCK INDEXED-REPOSITION" _FldNameList[1] = AnaDat.Femeld.Fenr _FldNameList[2] > AnaDat.Femeld.Fetext "Fetext" ? ? "character" ? ? ? ? ? ? no ? no no "78.4" yes no no "U" "" "" "" "" "" "" 0 no 0 no no _Query is NOT OPENED */ /* BROWSE Br_SuchenFemeld */ &ANALYZE-RESUME &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gSuchenFemeld /* Query rebuild information for DIALOG-BOX gSuchenFemeld _Options = "SHARE-LOCK" _Query is NOT OPENED */ /* DIALOG-BOX gSuchenFemeld */ &ANALYZE-RESUME /* ************************ Control Triggers ************************ */ &Scoped-define SELF-NAME gSuchenFemeld &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gSuchenFemeld gSuchenFemeld ON END-ERROR OF FRAME gSuchenFemeld /* Meldung suchen */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gSuchenFemeld gSuchenFemeld ON WINDOW-CLOSE OF FRAME gSuchenFemeld /* Meldung suchen */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define BROWSE-NAME Br_SuchenFemeld &Scoped-define SELF-NAME Br_SuchenFemeld &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_SuchenFemeld gSuchenFemeld ON END-ERROR OF Br_SuchenFemeld IN FRAME gSuchenFemeld /* Browse 1 */ DO: 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_SuchenFemeld gSuchenFemeld ON RETURN OF Br_SuchenFemeld IN FRAME gSuchenFemeld /* Browse 1 */ DO: IF hQuery:NUM-RESULTS = 0 OR hQuery:NUM-RESULTS = ? THEN RETURN NO-APPLY. BROWSE {&BROWSE-NAME}:FETCH-SELECTED-ROW(1). opNummer = Femeld.Fenr. RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME Btn_Cancel &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Cancel gSuchenFemeld ON CHOOSE OF Btn_Cancel IN FRAME gSuchenFemeld /* abbrechen */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME Btn_OK &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_OK gSuchenFemeld ON CHOOSE OF Btn_OK IN FRAME gSuchenFemeld /* OK */ DO: btnOK = TRUE. RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Suchbe &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Suchbe gSuchenFemeld ON RETURN OF F_Suchbe IN FRAME gSuchenFemeld /* Text */ DO: DEF VAR cString AS CHAR NO-UNDO. DEF VAR cWhere AS CHAR NO-UNDO. DEF VAR ii AS INT NO-UNDO. IF SELF:SCREEN-VALUE = '' THEN DO: APPLY 'ENTRY' TO SELF. RETURN NO-APPLY. END. ASSIGN F_Suchbe. cWhere = ''. DO ii = 1 TO NUM-ENTRIES(F_Suchbe, ' '): cString = REPLACE(ENTRY(ii, F_Suchbe, ' '), '*', ''). cWhere = cWhere + (IF cWhere = '' THEN '' ELSE ' AND ') + 'Femeld.Fetext MATCHES "*' + cString + '*"'. END. cWhere = 'FOR EACH Femeld NO-LOCK WHERE ' + cWhere. hQuery = BROWSE {&BROWSE-NAME}:QUERY. /* IF hQuery:QUERY-OPEN THEN hQuery:QUERY-CLOSE(). */ hQuery:QUERY-PREPARE(cWhere). hQuery:QUERY-OPEN(). END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gSuchenFemeld /* *************************** Main Block *************************** */ { incl/dlgmainblock.i } {src/adm2/dialogmn.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* ********************** Internal Procedures *********************** */ &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects gSuchenFemeld _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 disable_UI gSuchenFemeld _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 gSuchenFemeld. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gSuchenFemeld PROCEDURE enableObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ { incl/dlgenableobject.i } END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gSuchenFemeld _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_Suchbe WITH FRAME gSuchenFemeld. ENABLE RECT-2 F_Suchbe Br_SuchenFemeld Btn_OK Btn_Cancel WITH FRAME gSuchenFemeld. VIEW FRAME gSuchenFemeld. {&OPEN-BROWSERS-IN-QUERY-gSuchenFemeld} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gSuchenFemeld PROCEDURE ENDE : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ IF btnOK THEN DO: END. { incl/dlgende.i } END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME