&ANALYZE-SUSPEND _VERSION-NUMBER AB_v9r12 GUI ADM2 &ANALYZE-RESUME /* Connected Databases anadat PROGRESS */ &Scoped-define WINDOW-NAME CURRENT-WINDOW &Scoped-define FRAME-NAME gSuchenBank &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gSuchenBank /*------------------------------------------------------------------------ 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-OUTPUT PARAMETER ipBeginn AS CHAR NO-UNDO. /* Local Variable Definitions --- */ DEF VAR VSuchbe AS CHAR NO-UNDO. DEF VAR VName AS CHAR NO-UNDO. DEF VAR VSort 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 gSuchenBank &Scoped-define BROWSE-NAME Br_Bankst /* Internal Tables (found by Frame, Query & Browse Queries) */ &Scoped-define INTERNAL-TABLES Bankst /* Definitions for BROWSE Br_Bankst */ &Scoped-define FIELDS-IN-QUERY-Br_Bankst Bankst.Bank Bankst.Clearing ~ Bankst.Adr[1] Bankst.Adr[4] &Scoped-define ENABLED-FIELDS-IN-QUERY-Br_Bankst Bankst.Clearing &Scoped-define ENABLED-TABLES-IN-QUERY-Br_Bankst Bankst &Scoped-define FIRST-ENABLED-TABLE-IN-QUERY-Br_Bankst Bankst &Scoped-define OPEN-QUERY-Br_Bankst OPEN QUERY Br_Bankst FOR EACH Bankst NO-LOCK INDEXED-REPOSITION. &Scoped-define TABLES-IN-QUERY-Br_Bankst Bankst &Scoped-define FIRST-TABLE-IN-QUERY-Br_Bankst Bankst /* Definitions for DIALOG-BOX gSuchenBank */ /* Standard List Definitions */ &Scoped-Define ENABLED-OBJECTS F_Such_1 F_Such_2 F_Name Br_Bankst RECT-1 &Scoped-Define DISPLAYED-OBJECTS F_Such_1 F_Such_2 F_Name /* 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 F_Name AS CHARACTER FORMAT "x(30)":U LABEL "Bank" VIEW-AS FILL-IN NATIVE SIZE 45 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Such_1 AS CHARACTER FORMAT "x(10)":U LABEL "Bank / Ort" VIEW-AS FILL-IN NATIVE SIZE 15 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Such_2 AS CHARACTER FORMAT "x(10)":U LABEL "/" VIEW-AS FILL-IN NATIVE SIZE 15 BY 1 BGCOLOR 15 NO-UNDO. DEFINE RECTANGLE RECT-1 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 91 BY 13.48. /* Query definitions */ &ANALYZE-SUSPEND DEFINE QUERY Br_Bankst FOR Bankst SCROLLING. &ANALYZE-RESUME /* Browse definitions */ DEFINE BROWSE Br_Bankst &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS Br_Bankst gSuchenBank _STRUCTURED QUERY Br_Bankst NO-LOCK DISPLAY Bankst.Bank FORMAT "zzz9":U Bankst.Clearing FORMAT "x(15)":U Bankst.Adr[1] COLUMN-LABEL "Bank" FORMAT "x(30)":U Bankst.Adr[4] COLUMN-LABEL "Ort" FORMAT "x(30)":U ENABLE Bankst.Clearing /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME WITH NO-ROW-MARKERS SEPARATORS SIZE 86 BY 9.43 BGCOLOR 15 EXPANDABLE. /* ************************ Frame Definitions *********************** */ DEFINE FRAME gSuchenBank F_Such_1 AT ROW 1.52 COL 20 COLON-ALIGNED F_Such_2 AT ROW 1.52 COL 38 COLON-ALIGNED F_Name AT ROW 3 COL 20 COLON-ALIGNED Br_Bankst AT ROW 4.71 COL 4.2 RECT-1 AT ROW 1.24 COL 2 SPACE(1.99) SKIP(0.13) WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE TITLE "Suchen einer Bank". /* *********************** 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 gSuchenBank /* ************************* 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 gSuchenBank Custom */ /* BROWSE-TAB Br_Bankst F_Name gSuchenBank */ ASSIGN FRAME gSuchenBank:SCROLLABLE = FALSE FRAME gSuchenBank:HIDDEN = TRUE. /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* Setting information for Queries and Browse Widgets fields */ &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE Br_Bankst /* Query rebuild information for BROWSE Br_Bankst _TblList = "AnaDat.Bankst" _Options = "NO-LOCK INDEXED-REPOSITION" _FldNameList[1] = AnaDat.Bankst.Bank _FldNameList[2] > AnaDat.Bankst.Clearing "Bankst.Clearing" ? ? "character" ? ? ? ? ? ? yes ? no no ? yes no no "U" "" "" _FldNameList[3] > AnaDat.Bankst.Adr[1] "Bankst.Adr[1]" "Bank" ? "character" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" _FldNameList[4] > AnaDat.Bankst.Adr[4] "Bankst.Adr[4]" "Ort" ? "character" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" _Query is NOT OPENED */ /* BROWSE Br_Bankst */ &ANALYZE-RESUME &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gSuchenBank /* Query rebuild information for DIALOG-BOX gSuchenBank _Options = "SHARE-LOCK" _Query is NOT OPENED */ /* DIALOG-BOX gSuchenBank */ &ANALYZE-RESUME /* ************************ Control Triggers ************************ */ &Scoped-define SELF-NAME gSuchenBank &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gSuchenBank gSuchenBank ON END-ERROR OF FRAME gSuchenBank /* Suchen einer Bank */ DO: ipBeginn = ''. RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gSuchenBank gSuchenBank ON WINDOW-CLOSE OF FRAME gSuchenBank /* Suchen einer Bank */ DO: ipBeginn = ''. RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define BROWSE-NAME Br_Bankst &Scoped-define SELF-NAME Br_Bankst &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_Bankst gSuchenBank ON END-ERROR OF Br_Bankst IN FRAME gSuchenBank DO: APPLY 'ENTRY' TO F_Such_1 IN FRAME {&FRAME-NAME}. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_Bankst gSuchenBank ON RETURN OF Br_Bankst IN FRAME gSuchenBank 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 = STRING(Bankst.Bank) + CHR(01) + Bankst.Clearing + CHR(01) + Bankst.Adr[01] + CHR(01) + Bankst.Adr[04]. RUN ENDE. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_Bankst gSuchenBank ON START-SEARCH OF Br_Bankst IN FRAME gSuchenBank 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_Such_1. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Name &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Name gSuchenBank ON CURSOR-DOWN OF F_Name IN FRAME gSuchenBank /* Bank */ DO: F_Name:SCREEN-VALUE = ''. APPLY 'TAB' TO SELF. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Name gSuchenBank ON RETURN OF F_Name IN FRAME gSuchenBank /* Bank */ DO: F_Name:SCREEN-VALUE = ''. APPLY 'TAB' TO SELF. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Name gSuchenBank ON VALUE-CHANGED OF F_Name IN FRAME gSuchenBank /* Bank */ DO: DO WITH FRAME {&FRAME-NAME}: VSort = 2. VSuchbe = SELF:SCREEN-VALUE. RUN OPENQUERY. APPLY 'END' TO F_Name. END. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Such_1 &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Such_1 gSuchenBank ON CURSOR-DOWN OF F_Such_1 IN FRAME gSuchenBank /* Bank / Ort */ DO: F_Such_1:SCREEN-VALUE = ''. APPLY 'ENTRY' TO {&BROWSE-NAME} IN FRAME {&FRAME-NAME}. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Such_1 gSuchenBank ON RETURN OF F_Such_1 IN FRAME gSuchenBank /* Bank / Ort */ DO: F_Such_1:SCREEN-VALUE = ''. APPLY 'TAB' TO SELF. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Such_1 gSuchenBank ON VALUE-CHANGED OF F_Such_1 IN FRAME gSuchenBank /* Bank / Ort */ DO: DO WITH FRAME {&FRAME-NAME}: VSort = 1. VSuchbe = SELF:SCREEN-VALUE. RUN OPENQUERY. APPLY 'END' TO F_Such_1. END. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Such_2 &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Such_2 gSuchenBank ON CURSOR-DOWN OF F_Such_2 IN FRAME gSuchenBank /* / */ DO: F_Such_2:SCREEN-VALUE = ''. APPLY 'ENTRY' TO {&BROWSE-NAME} IN FRAME {&FRAME-NAME}. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Such_2 gSuchenBank ON RETURN OF F_Such_2 IN FRAME gSuchenBank /* / */ DO: F_Such_2:SCREEN-VALUE = ''. APPLY 'TAB' TO SELF. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Such_2 gSuchenBank ON VALUE-CHANGED OF F_Such_2 IN FRAME gSuchenBank /* / */ DO: DO WITH FRAME {&FRAME-NAME}: VSort = 1. VSuchbe = ''. SUBSTRING(VSuchbe,01) = F_Such_1:SCREEN-VALUE. SUBSTRING(VSuchbe,11) = F_Such_2:SCREEN-VALUE. RUN OPENQUERY. APPLY 'END' TO F_Such_2. END. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gSuchenBank /* *************************** Main Block *************************** */ SESSION:DATA-ENTRY-RETURN = TRUE. VSort = 1. ipBeginn = ''. VSuchbe = ''. {src/adm2/dialogmn.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* ********************** Internal Procedures *********************** */ &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects gSuchenBank _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 gSuchenBank PROCEDURE createObjects : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ RUN SUPER. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI gSuchenBank _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 gSuchenBank. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gSuchenBank PROCEDURE enableObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ RUN SUPER. {&BROWSE-NAME}:READ-ONLY IN FRAME {&FRAME-NAME} = TRUE. RUN OPENQUERY. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gSuchenBank _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_Such_1 F_Such_2 F_Name WITH FRAME gSuchenBank. ENABLE F_Such_1 F_Such_2 F_Name Br_Bankst RECT-1 WITH FRAME gSuchenBank. VIEW FRAME gSuchenBank. {&OPEN-BROWSERS-IN-QUERY-gSuchenBank} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gSuchenBank 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 gSuchenBank PROCEDURE OPENQUERY : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ IF NUM-RESULTS("{&BROWSE-NAME}") <> ? THEN CLOSE QUERY {&BROWSE-NAME}. DEF VAR aSuch AS CHAR NO-UNDO. DEF VAR bSuch AS CHAR NO-UNDO. CASE VSort: WHEN 1 THEN DO: aSuch = TRIM(SUBSTRING(VSuchbe,01,10)). bSuch = TRIM(SUBSTRING(VSuchbe,11,10)). OPEN QUERY {&BROWSE-NAME} FOR EACH Bankst USE-INDEX Bankst-k1 WHERE Bankst.Suchbe BEGINS aSuch AND SUBSTRING(Bankst.Suchbe,11) BEGINS bSuch NO-LOCK. END. WHEN 2 THEN DO: OPEN QUERY {&BROWSE-NAME} FOR EACH Bankst USE-INDEX Bankst-k1 WHERE Bankst.Adr[01] BEGINS VSuchbe NO-LOCK. END. END CASE. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME