&ANALYZE-SUSPEND _VERSION-NUMBER AB_v9r12 GUI ADM2 &ANALYZE-RESUME /* Connected Databases anadat PROGRESS */ &Scoped-define WINDOW-NAME CURRENT-WINDOW &Scoped-define FRAME-NAME gSuchenOrte &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gSuchenOrte /*------------------------------------------------------------------------ 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 ipLand AS CHAR NO-UNDO. DEF INPUT PARAMETER ipSort AS INT NO-UNDO. DEF INPUT-OUTPUT PARAMETER ipBeginn AS CHAR NO-UNDO. /* Local Variable Definitions --- */ DEF VAR VLkz AS CHAR 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 gSuchenOrte &Scoped-define BROWSE-NAME Br_Orte /* Internal Tables (found by Frame, Query & Browse Queries) */ &Scoped-define INTERNAL-TABLES Orte /* Definitions for BROWSE Br_Orte */ &Scoped-define FIELDS-IN-QUERY-Br_Orte Orte.Plz Orte.Ort &Scoped-define ENABLED-FIELDS-IN-QUERY-Br_Orte Orte.Plz Orte.Ort &Scoped-define ENABLED-TABLES-IN-QUERY-Br_Orte Orte &Scoped-define FIRST-ENABLED-TABLE-IN-QUERY-Br_Orte Orte &Scoped-define OPEN-QUERY-Br_Orte OPEN QUERY Br_Orte FOR EACH Orte NO-LOCK INDEXED-REPOSITION. &Scoped-define TABLES-IN-QUERY-Br_Orte Orte &Scoped-define FIRST-TABLE-IN-QUERY-Br_Orte Orte /* Definitions for DIALOG-BOX gSuchenOrte */ /* Standard List Definitions */ &Scoped-Define ENABLED-OBJECTS F_Eingabe Br_Orte CB_Land RECT-1 &Scoped-Define DISPLAYED-OBJECTS F_Eingabe CB_Land /* 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 VARIABLE CB_Land AS CHARACTER FORMAT "X(256)":U LABEL "Land" VIEW-AS COMBO-BOX INNER-LINES 5 LIST-ITEM-PAIRS "Item 1","Item 1" DROP-DOWN-LIST SIZE 35 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Eingabe AS CHARACTER FORMAT "X(256)":U LABEL "Fill 1" VIEW-AS FILL-IN SIZE 35 BY 1 BGCOLOR 15 NO-UNDO. DEFINE RECTANGLE RECT-1 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 62.6 BY 13.48. /* Query definitions */ &ANALYZE-SUSPEND DEFINE QUERY Br_Orte FOR Orte SCROLLING. &ANALYZE-RESUME /* Browse definitions */ DEFINE BROWSE Br_Orte &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS Br_Orte gSuchenOrte _STRUCTURED QUERY Br_Orte NO-LOCK DISPLAY Orte.Plz FORMAT "x(12)":U Orte.Ort FORMAT "x(40)":U ENABLE Orte.Plz Orte.Ort /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME WITH NO-ROW-MARKERS SEPARATORS SIZE 58 BY 9.43 BGCOLOR 15 EXPANDABLE. /* ************************ Frame Definitions *********************** */ DEFINE FRAME gSuchenOrte F_Eingabe AT ROW 3.19 COL 24 COLON-ALIGNED Br_Orte AT ROW 4.71 COL 4.2 CB_Land AT ROW 1.67 COL 24 COLON-ALIGNED RECT-1 AT ROW 1.24 COL 2 SPACE(0.99) SKIP(0.13) WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE TITLE "Suchen nach Orten". /* *********************** 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 Other Settings: COMPILE */ &ANALYZE-RESUME _END-PROCEDURE-SETTINGS &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB gSuchenOrte /* ************************* 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 gSuchenOrte Custom */ /* BROWSE-TAB Br_Orte F_Eingabe gSuchenOrte */ ASSIGN FRAME gSuchenOrte:SCROLLABLE = FALSE FRAME gSuchenOrte:HIDDEN = TRUE. /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* Setting information for Queries and Browse Widgets fields */ &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE Br_Orte /* Query rebuild information for BROWSE Br_Orte _TblList = "AnaDat.Orte" _Options = "NO-LOCK INDEXED-REPOSITION" _FldNameList[1] > AnaDat.Orte.Plz "Orte.Plz" ? ? "character" ? ? ? ? ? ? yes ? no no ? yes no no "U" "" "" _FldNameList[2] > AnaDat.Orte.Ort "Orte.Ort" ? ? "character" ? ? ? ? ? ? yes ? no no ? yes no no "U" "" "" _Query is NOT OPENED */ /* BROWSE Br_Orte */ &ANALYZE-RESUME &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gSuchenOrte /* Query rebuild information for DIALOG-BOX gSuchenOrte _Options = "SHARE-LOCK" _Query is NOT OPENED */ /* DIALOG-BOX gSuchenOrte */ &ANALYZE-RESUME /* ************************ Control Triggers ************************ */ &Scoped-define SELF-NAME gSuchenOrte &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gSuchenOrte gSuchenOrte ON END-ERROR OF FRAME gSuchenOrte /* Suchen nach Orten */ DO: ipBeginn = ''. RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gSuchenOrte gSuchenOrte ON WINDOW-CLOSE OF FRAME gSuchenOrte /* Suchen nach Orten */ DO: ipBeginn = ''. RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define BROWSE-NAME Br_Orte &Scoped-define SELF-NAME Br_Orte &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_Orte gSuchenOrte ON END-ERROR OF Br_Orte IN FRAME gSuchenOrte DO: APPLY 'ENTRY' TO F_Eingabe IN FRAME {&FRAME-NAME}. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_Orte gSuchenOrte ON RETURN OF Br_Orte IN FRAME gSuchenOrte DO: 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). ipBeginn = Ort.Lkz + CHR(01) + Ort.Plz + CHR(01) + Ort.Ort. RUN ENDE. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_Orte gSuchenOrte ON START-SEARCH OF Br_Orte IN FRAME gSuchenOrte DO: DEF VAR xx AS HANDLE. xx = {&BROWSE-NAME}:CURRENT-COLUMN. IF xx:NAME = 'Plz' THEN ipSort = 1. ELSE ipSort = 2. IF ipSort = 1 THEN F_Eingabe:LABEL = 'Plz'. IF ipSort = 2 THEN F_Eingabe:LABEL = 'Ort'. ipBeginn = ''. F_Eingabe = ''. APPLY 'END-SEARCH' TO BROWSE {&BROWSE-NAME}. RUN OPENQUERY. APPLY 'ENTRY' TO F_Eingabe. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME CB_Land &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_Land gSuchenOrte ON VALUE-CHANGED OF CB_Land IN FRAME gSuchenOrte /* Land */ DO: RUN OPENQUERY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Eingabe &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Eingabe gSuchenOrte ON CURSOR-DOWN OF F_Eingabe IN FRAME gSuchenOrte /* Fill 1 */ DO: F_Eingabe:SCREEN-VALUE = ''. APPLY 'TAB' TO SELF. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Eingabe gSuchenOrte ON RETURN OF F_Eingabe IN FRAME gSuchenOrte /* Fill 1 */ DO: F_Eingabe:SCREEN-VALUE = ''. APPLY 'TAB' TO SELF. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Eingabe gSuchenOrte ON VALUE-CHANGED OF F_Eingabe IN FRAME gSuchenOrte /* Fill 1 */ DO: DO WITH FRAME {&FRAME-NAME}: ipBeginn = SELF:SCREEN-VALUE. F_Eingabe = ipBeginn. RUN OPENQUERY. APPLY 'END' TO F_Eingabe. END. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gSuchenOrte /* *************************** Main Block *************************** */ SESSION:DATA-ENTRY-RETURN = TRUE. IF ipSort = 0 THEN ipSort = 1. IF ipSort > 2 THEN ipSort = 2. ipBeginn = ''. F_Eingabe = ''. {src/adm2/dialogmn.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* ********************** Internal Procedures *********************** */ &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects gSuchenOrte _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 createObjects gSuchenOrte PROCEDURE createObjects : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ CASE ipSort: WHEN 1 THEN F_Eingabe:LABEL IN FRAME {&FRAME-NAME} = 'Plz'. WHEN 2 THEN F_Eingabe:LABEL IN FRAME {&FRAME-NAME} = 'Ort'. END CASE. RUN SUPER. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI gSuchenOrte _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 gSuchenOrte. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gSuchenOrte PROCEDURE enableObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ RUN SUPER. RUN COMBO_Land ( INPUT CB_Land:HANDLE IN FRAME {&FRAME-NAME} ). CB_Land:SCREEN-VALUE = VLkz. {&BROWSE-NAME}:READ-ONLY = TRUE. RUN OPENQUERY. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gSuchenOrte _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_Eingabe CB_Land WITH FRAME gSuchenOrte. ENABLE F_Eingabe Br_Orte CB_Land RECT-1 WITH FRAME gSuchenOrte. VIEW FRAME gSuchenOrte. {&OPEN-BROWSERS-IN-QUERY-gSuchenOrte} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gSuchenOrte PROCEDURE ENDE : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ APPLY 'GO' TO FRAME {&FRAME-NAME}. RETURN NO-APPLY. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE OPENQUERY gSuchenOrte PROCEDURE OPENQUERY : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ IF NUM-RESULTS("{&BROWSE-NAME}") <> ? THEN CLOSE QUERY {&BROWSE-NAME}. VLkz = CB_Land:SCREEN-VALUE IN FRAME {&FRAME-NAME}. CASE ipSort: WHEN 1 THEN DO: OPEN QUERY {&BROWSE-NAME} FOR EACH Orte USE-INDEX Orte-k1 WHERE Orte.Lkz = VLkz AND Orte.Plz BEGINS ipBeginn NO-LOCK. END. WHEN 2 THEN DO: OPEN QUERY {&BROWSE-NAME} FOR EACH Orte USE-INDEX Orte-k2 WHERE Orte.Lkz = VLkz AND Orte.Ort BEGINS ipBeginn NO-LOCK. END. END CASE. ipBeginn = ''. DISPLAY F_Eingabe WITH FRAME {&FRAME-NAME}. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME