b-ewkst2.w 9.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345
  1. &ANALYZE-SUSPEND _VERSION-NUMBER AB_v9r12 GUI ADM2
  2. &ANALYZE-RESUME
  3. /* Connected Databases
  4. anadat PROGRESS
  5. */
  6. &Scoped-define WINDOW-NAME CURRENT-WINDOW
  7. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS bTableWin
  8. /*------------------------------------------------------------------------
  9. File: adm2\src\browser.w
  10. Description: SmartDataBrowser Object
  11. Input Parameters:
  12. <none>
  13. Output Parameters:
  14. <none>
  15. ------------------------------------------------------------------------*/
  16. /* This .W file was created with the Progress AppBuilder. */
  17. /*----------------------------------------------------------------------*/
  18. /* Create an unnamed pool to store all the widgets created
  19. by this procedure. This is a good default which assures
  20. that this procedure's triggers and internal procedures
  21. will execute in this procedure's storage, and that proper
  22. cleanup will occur on deletion of the procedure. */
  23. CREATE WIDGET-POOL.
  24. /* *************************** Definitions ************************** */
  25. /* Parameters Definitions --- */
  26. /* Local Variable Definitions --- */
  27. /* _UIB-CODE-BLOCK-END */
  28. &ANALYZE-RESUME
  29. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  30. /* ******************** Preprocessor Definitions ******************** */
  31. &Scoped-define PROCEDURE-TYPE SmartDataBrowser
  32. &Scoped-define DB-AWARE no
  33. &Scoped-define ADM-SUPPORTED-LINKS TableIO-Target,Data-Target,Update-Source
  34. /* Include file with RowObject temp-table definition */
  35. &Scoped-define DATA-FIELD-DEFS "d-ewkst2.i"
  36. /* Name of first Frame and/or Browse and/or first Query */
  37. &Scoped-define FRAME-NAME F-Main
  38. &Scoped-define BROWSE-NAME br_table
  39. /* Internal Tables (found by Frame, Query & Browse Queries) */
  40. &Scoped-define INTERNAL-TABLES rowObject
  41. /* Definitions for BROWSE br_table */
  42. &Scoped-define FIELDS-IN-QUERY-br_table rowObject.Cd_2 ~
  43. rowObject.Bezeichnung
  44. &Scoped-define ENABLED-FIELDS-IN-QUERY-br_table
  45. &Scoped-define OPEN-QUERY-br_table OPEN QUERY br_table FOR EACH rowObject.
  46. &Scoped-define TABLES-IN-QUERY-br_table rowObject
  47. &Scoped-define FIRST-TABLE-IN-QUERY-br_table rowObject
  48. /* Definitions for FRAME F-Main */
  49. /* Standard List Definitions */
  50. &Scoped-Define ENABLED-OBJECTS br_table RECT-6
  51. /* Custom List Definitions */
  52. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  53. /* _UIB-PREPROCESSOR-BLOCK-END */
  54. &ANALYZE-RESUME
  55. /* *********************** Control Definitions ********************** */
  56. /* Definitions of the field level widgets */
  57. DEFINE RECTANGLE RECT-6
  58. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  59. SIZE 42 BY 7.14.
  60. /* Query definitions */
  61. &ANALYZE-SUSPEND
  62. DEFINE TEMP-TABLE RowObject
  63. {{&DATA-FIELD-DEFS}}
  64. {src/adm2/robjflds.i}.
  65. DEFINE QUERY br_table FOR
  66. rowObject SCROLLING.
  67. &ANALYZE-RESUME
  68. /* Browse definitions */
  69. DEFINE BROWSE br_table
  70. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_table bTableWin _STRUCTURED
  71. QUERY br_table NO-LOCK DISPLAY
  72. Cd_2 COLUMN-LABEL "Cd" FORMAT "99":U WIDTH 4
  73. Bezeichnung FORMAT "x(30)":U
  74. /* _UIB-CODE-BLOCK-END */
  75. &ANALYZE-RESUME
  76. WITH NO-ASSIGN NO-AUTO-VALIDATE NO-ROW-MARKERS SEPARATORS SIZE 40 BY 6.67
  77. BGCOLOR 15 .
  78. /* ************************ Frame Definitions *********************** */
  79. DEFINE FRAME F-Main
  80. br_table AT ROW 1.48 COL 3
  81. RECT-6 AT ROW 1.24 COL 2
  82. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
  83. SIDE-LABELS NO-UNDERLINE THREE-D
  84. AT COL 1 ROW 1 SCROLLABLE .
  85. /* *********************** Procedure Settings ************************ */
  86. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  87. /* Settings for THIS-PROCEDURE
  88. Type: SmartDataBrowser
  89. Data Source: "d-ewkst2.w"
  90. Allow: Basic,Browse
  91. Frames: 1
  92. Add Fields to: Neither
  93. Other Settings: PERSISTENT-ONLY COMPILE
  94. */
  95. /* This procedure should always be RUN PERSISTENT. Report the error, */
  96. /* then cleanup and return. */
  97. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  98. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  99. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  100. RETURN.
  101. END.
  102. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  103. /* ************************* Create Window ************************** */
  104. &ANALYZE-SUSPEND _CREATE-WINDOW
  105. /* DESIGN Window definition (used by the UIB)
  106. CREATE WINDOW bTableWin ASSIGN
  107. HEIGHT = 7.86
  108. WIDTH = 49.8.
  109. /* END WINDOW DEFINITION */
  110. */
  111. &ANALYZE-RESUME
  112. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB bTableWin
  113. /* ************************* Included-Libraries *********************** */
  114. {src/adm2/browser.i}
  115. /* _UIB-CODE-BLOCK-END */
  116. &ANALYZE-RESUME
  117. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  118. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  119. /* SETTINGS FOR WINDOW bTableWin
  120. NOT-VISIBLE,,RUN-PERSISTENT */
  121. /* SETTINGS FOR FRAME F-Main
  122. NOT-VISIBLE Size-to-Fit */
  123. /* BROWSE-TAB br_table 1 F-Main */
  124. ASSIGN
  125. FRAME F-Main:SCROLLABLE = FALSE
  126. FRAME F-Main:HIDDEN = TRUE.
  127. /* _RUN-TIME-ATTRIBUTES-END */
  128. &ANALYZE-RESUME
  129. /* Setting information for Queries and Browse Widgets fields */
  130. &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE br_table
  131. /* Query rebuild information for BROWSE br_table
  132. _TblList = "rowObject"
  133. _Options = "NO-LOCK INDEXED-REPOSITION"
  134. _FldNameList[1] > _<SDO>.rowObject.Cd_2
  135. "Cd_2" "Cd" ? "integer" ? ? ? ? ? ? no "?" no no "4" yes no no "U" "" ""
  136. _FldNameList[2] = _<SDO>.rowObject.Bezeichnung
  137. _Query is NOT OPENED
  138. */ /* BROWSE br_table */
  139. &ANALYZE-RESUME
  140. &ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
  141. /* Query rebuild information for FRAME F-Main
  142. _Options = "NO-LOCK"
  143. _Query is NOT OPENED
  144. */ /* FRAME F-Main */
  145. &ANALYZE-RESUME
  146. /* ************************ Control Triggers ************************ */
  147. &Scoped-define BROWSE-NAME br_table
  148. &Scoped-define SELF-NAME br_table
  149. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  150. ON CTRL-END OF br_table IN FRAME F-Main
  151. DO:
  152. APPLY "END":U TO BROWSE {&BROWSE-NAME}.
  153. END.
  154. /* _UIB-CODE-BLOCK-END */
  155. &ANALYZE-RESUME
  156. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  157. ON CTRL-HOME OF br_table IN FRAME F-Main
  158. DO:
  159. APPLY "HOME":U TO BROWSE {&BROWSE-NAME}.
  160. END.
  161. /* _UIB-CODE-BLOCK-END */
  162. &ANALYZE-RESUME
  163. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  164. ON END OF br_table IN FRAME F-Main
  165. DO:
  166. {src/adm2/brsend.i}
  167. END.
  168. /* _UIB-CODE-BLOCK-END */
  169. &ANALYZE-RESUME
  170. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  171. ON HOME OF br_table IN FRAME F-Main
  172. DO:
  173. {src/adm2/brshome.i}
  174. END.
  175. /* _UIB-CODE-BLOCK-END */
  176. &ANALYZE-RESUME
  177. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  178. ON OFF-END OF br_table IN FRAME F-Main
  179. DO:
  180. {src/adm2/brsoffnd.i}
  181. END.
  182. /* _UIB-CODE-BLOCK-END */
  183. &ANALYZE-RESUME
  184. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  185. ON OFF-HOME OF br_table IN FRAME F-Main
  186. DO:
  187. {src/adm2/brsoffhm.i}
  188. END.
  189. /* _UIB-CODE-BLOCK-END */
  190. &ANALYZE-RESUME
  191. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  192. ON ROW-ENTRY OF br_table IN FRAME F-Main
  193. DO:
  194. {src/adm2/brsentry.i}
  195. END.
  196. /* _UIB-CODE-BLOCK-END */
  197. &ANALYZE-RESUME
  198. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  199. ON ROW-LEAVE OF br_table IN FRAME F-Main
  200. DO:
  201. {src/adm2/brsleave.i}
  202. END.
  203. /* _UIB-CODE-BLOCK-END */
  204. &ANALYZE-RESUME
  205. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  206. ON SCROLL-NOTIFY OF br_table IN FRAME F-Main
  207. DO:
  208. {src/adm2/brsscrol.i}
  209. END.
  210. /* _UIB-CODE-BLOCK-END */
  211. &ANALYZE-RESUME
  212. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  213. ON VALUE-CHANGED OF br_table IN FRAME F-Main
  214. DO:
  215. {src/adm2/brschnge.i}
  216. END.
  217. /* _UIB-CODE-BLOCK-END */
  218. &ANALYZE-RESUME
  219. &UNDEFINE SELF-NAME
  220. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK bTableWin
  221. /* *************************** Main Block *************************** */
  222. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  223. RUN initializeObject.
  224. &ENDIF
  225. /* _UIB-CODE-BLOCK-END */
  226. &ANALYZE-RESUME
  227. /* ********************** Internal Procedures *********************** */
  228. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI bTableWin _DEFAULT-DISABLE
  229. PROCEDURE disable_UI :
  230. /*------------------------------------------------------------------------------
  231. Purpose: DISABLE the User Interface
  232. Parameters: <none>
  233. Notes: Here we clean-up the user-interface by deleting
  234. dynamic widgets we have created and/or hide
  235. frames. This procedure is usually called when
  236. we are ready to "clean-up" after running.
  237. ------------------------------------------------------------------------------*/
  238. /* Hide all frames. */
  239. HIDE FRAME F-Main.
  240. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  241. END PROCEDURE.
  242. /* _UIB-CODE-BLOCK-END */
  243. &ANALYZE-RESUME