g-suchen-femeld.w 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438
  1. &ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2
  2. &ANALYZE-RESUME
  3. /* Connected Databases
  4. anadat PROGRESS
  5. */
  6. &Scoped-define WINDOW-NAME CURRENT-WINDOW
  7. &Scoped-define FRAME-NAME gSuchenFemeld
  8. {adecomm/appserv.i}
  9. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gSuchenFemeld
  10. /*------------------------------------------------------------------------
  11. File:
  12. Description: from cntnrdlg.w - ADM2 SmartDialog Template
  13. Input Parameters:
  14. <none>
  15. Output Parameters:
  16. <none>
  17. Author:
  18. Created:
  19. ------------------------------------------------------------------------*/
  20. /* This .W file was created with the Progress AppBuilder. */
  21. /*----------------------------------------------------------------------*/
  22. /* Create an unnamed pool to store all the widgets created
  23. by this procedure. This is a good default which assures
  24. that this procedure's triggers and internal procedures
  25. will execute in this procedure's storage, and that proper
  26. cleanup will occur on deletion of the procedure. */
  27. CREATE WIDGET-POOL.
  28. /* *************************** Definitions ************************** */
  29. /* Parameters Definitions --- */
  30. DEF OUTPUT PARAMETER opNummer AS INT NO-UNDO.
  31. /* Local Variable Definitions --- */
  32. DEF VAR hQuery AS HANDLE NO-UNDO.
  33. { incl/dlgdefinition.i }
  34. { src/adm2/widgetprto.i }
  35. /* _UIB-CODE-BLOCK-END */
  36. &ANALYZE-RESUME
  37. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  38. /* ******************** Preprocessor Definitions ******************** */
  39. &Scoped-define PROCEDURE-TYPE SmartDialog
  40. &Scoped-define DB-AWARE no
  41. &Scoped-define ADM-CONTAINER DIALOG-BOX
  42. &Scoped-define ADM-SUPPORTED-LINKS Data-Target,Data-Source,Page-Target,Update-Source,Update-Target
  43. /* Name of designated FRAME-NAME and/or first browse and/or first query */
  44. &Scoped-define FRAME-NAME gSuchenFemeld
  45. &Scoped-define BROWSE-NAME Br_SuchenFemeld
  46. /* Internal Tables (found by Frame, Query & Browse Queries) */
  47. &Scoped-define INTERNAL-TABLES Femeld
  48. /* Definitions for BROWSE Br_SuchenFemeld */
  49. &Scoped-define FIELDS-IN-QUERY-Br_SuchenFemeld Femeld.Fenr Femeld.Fetext
  50. &Scoped-define ENABLED-FIELDS-IN-QUERY-Br_SuchenFemeld
  51. &Scoped-define QUERY-STRING-Br_SuchenFemeld FOR EACH Femeld NO-LOCK INDEXED-REPOSITION
  52. &Scoped-define OPEN-QUERY-Br_SuchenFemeld OPEN QUERY Br_SuchenFemeld FOR EACH Femeld NO-LOCK INDEXED-REPOSITION.
  53. &Scoped-define TABLES-IN-QUERY-Br_SuchenFemeld Femeld
  54. &Scoped-define FIRST-TABLE-IN-QUERY-Br_SuchenFemeld Femeld
  55. /* Definitions for DIALOG-BOX gSuchenFemeld */
  56. /* Standard List Definitions */
  57. &Scoped-Define ENABLED-OBJECTS RECT-2 F_Suchbe Br_SuchenFemeld Btn_OK ~
  58. Btn_Cancel
  59. &Scoped-Define DISPLAYED-OBJECTS F_Suchbe
  60. /* Custom List Definitions */
  61. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  62. /* _UIB-PREPROCESSOR-BLOCK-END */
  63. &ANALYZE-RESUME
  64. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _XFTR "SmartDialogCues" gSuchenFemeld _INLINE
  65. /* Actions: adecomm/_so-cue.w ? adecomm/_so-cued.p ? adecomm/_so-cuew.p */
  66. /* SmartDialog,ab,49267
  67. Destroy on next read */
  68. /* _UIB-CODE-BLOCK-END */
  69. &ANALYZE-RESUME
  70. /* *********************** Control Definitions ********************** */
  71. /* Define a dialog box */
  72. /* Definitions of the field level widgets */
  73. DEFINE BUTTON Btn_Cancel
  74. LABEL "abbrechen"
  75. SIZE 15 BY 1.
  76. DEFINE BUTTON Btn_OK AUTO-GO
  77. LABEL "OK"
  78. SIZE 15 BY 1.
  79. DEFINE VARIABLE F_Suchbe AS CHARACTER FORMAT "X(256)":U
  80. LABEL "Text"
  81. VIEW-AS FILL-IN NATIVE
  82. SIZE 40 BY 1
  83. BGCOLOR 15 NO-UNDO.
  84. DEFINE RECTANGLE RECT-2
  85. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  86. SIZE 94 BY 8.57.
  87. /* Query definitions */
  88. &ANALYZE-SUSPEND
  89. DEFINE QUERY Br_SuchenFemeld FOR
  90. Femeld SCROLLING.
  91. &ANALYZE-RESUME
  92. /* Browse definitions */
  93. DEFINE BROWSE Br_SuchenFemeld
  94. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS Br_SuchenFemeld gSuchenFemeld _STRUCTURED
  95. QUERY Br_SuchenFemeld NO-LOCK DISPLAY
  96. Femeld.Fenr FORMAT "zzzz":U
  97. Femeld.Fetext FORMAT "x(70)":U WIDTH 78.4
  98. /* _UIB-CODE-BLOCK-END */
  99. &ANALYZE-RESUME
  100. WITH NO-ROW-MARKERS SEPARATORS SIZE 90 BY 7.62 FIT-LAST-COLUMN.
  101. /* ************************ Frame Definitions *********************** */
  102. DEFINE FRAME gSuchenFemeld
  103. F_Suchbe AT ROW 1.52 COL 7 COLON-ALIGNED WIDGET-ID 4
  104. Br_SuchenFemeld AT ROW 3.38 COL 5 WIDGET-ID 200
  105. Btn_OK AT ROW 11.86 COL 20.2
  106. Btn_Cancel AT ROW 11.86 COL 66.2
  107. RECT-2 AT ROW 2.91 COL 3 WIDGET-ID 2
  108. SPACE(1.79) SKIP(2.46)
  109. WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER
  110. SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE
  111. TITLE "Meldung suchen" WIDGET-ID 100.
  112. /* *********************** Procedure Settings ************************ */
  113. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  114. /* Settings for THIS-PROCEDURE
  115. Type: SmartDialog
  116. Allow: Basic,Browse,DB-Fields,Query,Smart
  117. Container Links: Data-Target,Data-Source,Page-Target,Update-Source,Update-Target
  118. Design Page: 1
  119. Other Settings: COMPILE APPSERVER
  120. */
  121. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  122. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB gSuchenFemeld
  123. /* ************************* Included-Libraries *********************** */
  124. {src/adm2/containr.i}
  125. /* _UIB-CODE-BLOCK-END */
  126. &ANALYZE-RESUME
  127. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  128. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  129. /* SETTINGS FOR DIALOG-BOX gSuchenFemeld
  130. FRAME-NAME */
  131. /* BROWSE-TAB Br_SuchenFemeld F_Suchbe gSuchenFemeld */
  132. ASSIGN
  133. FRAME gSuchenFemeld:SCROLLABLE = FALSE
  134. FRAME gSuchenFemeld:HIDDEN = TRUE.
  135. /* _RUN-TIME-ATTRIBUTES-END */
  136. &ANALYZE-RESUME
  137. /* Setting information for Queries and Browse Widgets fields */
  138. &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE Br_SuchenFemeld
  139. /* Query rebuild information for BROWSE Br_SuchenFemeld
  140. _TblList = "AnaDat.Femeld"
  141. _Options = "NO-LOCK INDEXED-REPOSITION"
  142. _FldNameList[1] = AnaDat.Femeld.Fenr
  143. _FldNameList[2] > AnaDat.Femeld.Fetext
  144. "Fetext" ? ? "character" ? ? ? ? ? ? no ? no no "78.4" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  145. _Query is NOT OPENED
  146. */ /* BROWSE Br_SuchenFemeld */
  147. &ANALYZE-RESUME
  148. &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gSuchenFemeld
  149. /* Query rebuild information for DIALOG-BOX gSuchenFemeld
  150. _Options = "SHARE-LOCK"
  151. _Query is NOT OPENED
  152. */ /* DIALOG-BOX gSuchenFemeld */
  153. &ANALYZE-RESUME
  154. /* ************************ Control Triggers ************************ */
  155. &Scoped-define SELF-NAME gSuchenFemeld
  156. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gSuchenFemeld gSuchenFemeld
  157. ON END-ERROR OF FRAME gSuchenFemeld /* Meldung suchen */
  158. DO:
  159. RUN ENDE.
  160. RETURN NO-APPLY.
  161. END.
  162. /* _UIB-CODE-BLOCK-END */
  163. &ANALYZE-RESUME
  164. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gSuchenFemeld gSuchenFemeld
  165. ON WINDOW-CLOSE OF FRAME gSuchenFemeld /* Meldung suchen */
  166. DO:
  167. RUN ENDE.
  168. RETURN NO-APPLY.
  169. END.
  170. /* _UIB-CODE-BLOCK-END */
  171. &ANALYZE-RESUME
  172. &Scoped-define BROWSE-NAME Br_SuchenFemeld
  173. &Scoped-define SELF-NAME Br_SuchenFemeld
  174. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_SuchenFemeld gSuchenFemeld
  175. ON END-ERROR OF Br_SuchenFemeld IN FRAME gSuchenFemeld /* Browse 1 */
  176. DO:
  177. APPLY 'ENTRY' TO F_Suchbe IN FRAME {&FRAME-NAME}.
  178. RETURN NO-APPLY.
  179. END.
  180. /* _UIB-CODE-BLOCK-END */
  181. &ANALYZE-RESUME
  182. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_SuchenFemeld gSuchenFemeld
  183. ON RETURN OF Br_SuchenFemeld IN FRAME gSuchenFemeld /* Browse 1 */
  184. DO:
  185. IF hQuery:NUM-RESULTS = 0 OR
  186. hQuery:NUM-RESULTS = ? THEN RETURN NO-APPLY.
  187. BROWSE {&BROWSE-NAME}:FETCH-SELECTED-ROW(1).
  188. opNummer = Femeld.Fenr.
  189. RUN ENDE.
  190. RETURN NO-APPLY.
  191. END.
  192. /* _UIB-CODE-BLOCK-END */
  193. &ANALYZE-RESUME
  194. &Scoped-define SELF-NAME Btn_Cancel
  195. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Cancel gSuchenFemeld
  196. ON CHOOSE OF Btn_Cancel IN FRAME gSuchenFemeld /* abbrechen */
  197. DO:
  198. RUN ENDE.
  199. RETURN NO-APPLY.
  200. END.
  201. /* _UIB-CODE-BLOCK-END */
  202. &ANALYZE-RESUME
  203. &Scoped-define SELF-NAME Btn_OK
  204. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_OK gSuchenFemeld
  205. ON CHOOSE OF Btn_OK IN FRAME gSuchenFemeld /* OK */
  206. DO:
  207. btnOK = TRUE.
  208. RUN ENDE.
  209. RETURN NO-APPLY.
  210. END.
  211. /* _UIB-CODE-BLOCK-END */
  212. &ANALYZE-RESUME
  213. &Scoped-define SELF-NAME F_Suchbe
  214. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Suchbe gSuchenFemeld
  215. ON RETURN OF F_Suchbe IN FRAME gSuchenFemeld /* Text */
  216. DO:
  217. DEF VAR cString AS CHAR NO-UNDO.
  218. DEF VAR cWhere AS CHAR NO-UNDO.
  219. DEF VAR ii AS INT NO-UNDO.
  220. IF SELF:SCREEN-VALUE = '' THEN DO:
  221. APPLY 'ENTRY' TO SELF.
  222. RETURN NO-APPLY.
  223. END.
  224. ASSIGN F_Suchbe.
  225. cWhere = ''.
  226. DO ii = 1 TO NUM-ENTRIES(F_Suchbe, ' '):
  227. cString = REPLACE(ENTRY(ii, F_Suchbe, ' '), '*', '').
  228. cWhere = cWhere
  229. + (IF cWhere = '' THEN '' ELSE ' AND ')
  230. + 'Femeld.Fetext MATCHES "*'
  231. + cString
  232. + '*"'.
  233. END.
  234. cWhere = 'FOR EACH Femeld NO-LOCK WHERE '
  235. + cWhere.
  236. hQuery = BROWSE {&BROWSE-NAME}:QUERY.
  237. /* IF hQuery:QUERY-OPEN THEN hQuery:QUERY-CLOSE(). */
  238. hQuery:QUERY-PREPARE(cWhere).
  239. hQuery:QUERY-OPEN().
  240. END.
  241. /* _UIB-CODE-BLOCK-END */
  242. &ANALYZE-RESUME
  243. &UNDEFINE SELF-NAME
  244. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gSuchenFemeld
  245. /* *************************** Main Block *************************** */
  246. { incl/dlgmainblock.i }
  247. {src/adm2/dialogmn.i}
  248. /* _UIB-CODE-BLOCK-END */
  249. &ANALYZE-RESUME
  250. /* ********************** Internal Procedures *********************** */
  251. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects gSuchenFemeld _ADM-CREATE-OBJECTS
  252. PROCEDURE adm-create-objects :
  253. /*------------------------------------------------------------------------------
  254. Purpose: Create handles for all SmartObjects used in this procedure.
  255. After SmartObjects are initialized, then SmartLinks are added.
  256. Parameters: <none>
  257. ------------------------------------------------------------------------------*/
  258. END PROCEDURE.
  259. /* _UIB-CODE-BLOCK-END */
  260. &ANALYZE-RESUME
  261. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI gSuchenFemeld _DEFAULT-DISABLE
  262. PROCEDURE disable_UI :
  263. /*------------------------------------------------------------------------------
  264. Purpose: DISABLE the User Interface
  265. Parameters: <none>
  266. Notes: Here we clean-up the user-interface by deleting
  267. dynamic widgets we have created and/or hide
  268. frames. This procedure is usually called when
  269. we are ready to "clean-up" after running.
  270. ------------------------------------------------------------------------------*/
  271. /* Hide all frames. */
  272. HIDE FRAME gSuchenFemeld.
  273. END PROCEDURE.
  274. /* _UIB-CODE-BLOCK-END */
  275. &ANALYZE-RESUME
  276. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gSuchenFemeld
  277. PROCEDURE enableObject :
  278. /*------------------------------------------------------------------------------
  279. Purpose: Super Override
  280. Parameters:
  281. Notes:
  282. ------------------------------------------------------------------------------*/
  283. { incl/dlgenableobject.i }
  284. END PROCEDURE.
  285. /* _UIB-CODE-BLOCK-END */
  286. &ANALYZE-RESUME
  287. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gSuchenFemeld _DEFAULT-ENABLE
  288. PROCEDURE enable_UI :
  289. /*------------------------------------------------------------------------------
  290. Purpose: ENABLE the User Interface
  291. Parameters: <none>
  292. Notes: Here we display/view/enable the widgets in the
  293. user-interface. In addition, OPEN all queries
  294. associated with each FRAME and BROWSE.
  295. These statements here are based on the "Other
  296. Settings" section of the widget Property Sheets.
  297. ------------------------------------------------------------------------------*/
  298. DISPLAY F_Suchbe
  299. WITH FRAME gSuchenFemeld.
  300. ENABLE RECT-2 F_Suchbe Br_SuchenFemeld Btn_OK Btn_Cancel
  301. WITH FRAME gSuchenFemeld.
  302. VIEW FRAME gSuchenFemeld.
  303. {&OPEN-BROWSERS-IN-QUERY-gSuchenFemeld}
  304. END PROCEDURE.
  305. /* _UIB-CODE-BLOCK-END */
  306. &ANALYZE-RESUME
  307. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gSuchenFemeld
  308. PROCEDURE ENDE :
  309. /*------------------------------------------------------------------------------
  310. Purpose:
  311. Parameters: <none>
  312. Notes:
  313. ------------------------------------------------------------------------------*/
  314. IF btnOK THEN DO:
  315. END.
  316. { incl/dlgende.i }
  317. END PROCEDURE.
  318. /* _UIB-CODE-BLOCK-END */
  319. &ANALYZE-RESUME