b-fakart.w 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368
  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. &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-fakart.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 CodeI Bez1 Bez2 Int_1 Int_2 Int_3 ~
  43. Dec_1 Dec_2 Flag_1
  44. &Scoped-define ENABLED-FIELDS-IN-QUERY-br_table
  45. &Scoped-define QUERY-STRING-br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION
  46. &Scoped-define OPEN-QUERY-br_table OPEN QUERY br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION.
  47. &Scoped-define TABLES-IN-QUERY-br_table rowObject
  48. &Scoped-define FIRST-TABLE-IN-QUERY-br_table rowObject
  49. /* Definitions for FRAME F-Main */
  50. /* Standard List Definitions */
  51. &Scoped-Define ENABLED-OBJECTS RECT-1 br_table
  52. /* Custom List Definitions */
  53. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  54. /* _UIB-PREPROCESSOR-BLOCK-END */
  55. &ANALYZE-RESUME
  56. /* *********************** Control Definitions ********************** */
  57. /* Definitions of the field level widgets */
  58. DEFINE RECTANGLE RECT-1
  59. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  60. SIZE 106 BY 7.14.
  61. /* Query definitions */
  62. &ANALYZE-SUSPEND
  63. DEFINE TEMP-TABLE RowObject NO-UNDO
  64. {{&DATA-FIELD-DEFS}}
  65. {src/adm2/robjflds.i}.
  66. DEFINE QUERY br_table FOR
  67. rowObject SCROLLING.
  68. &ANALYZE-RESUME
  69. /* Browse definitions */
  70. DEFINE BROWSE br_table
  71. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_table bTableWin _STRUCTURED
  72. QUERY br_table NO-LOCK DISPLAY
  73. CodeI COLUMN-LABEL "Cd" FORMAT "99":U WIDTH 3
  74. Bez1 COLUMN-LABEL "Dokumentbezeichnung" FORMAT "x(30)":U
  75. Bez2 FORMAT "x(30)":U
  76. Int_1 COLUMN-LABEL "NA" FORMAT "99":U WIDTH 4
  77. Int_2 COLUMN-LABEL "NS" FORMAT "99":U WIDTH 4
  78. Int_3 FORMAT "zzz,zz9":U WIDTH 4
  79. Dec_1 COLUMN-LABEL "DM" FORMAT "9":U WIDTH 4
  80. Dec_2 COLUMN-LABEL "Rü" FORMAT "99":U WIDTH 4
  81. Flag_1 COLUMN-LABEL "Fest" FORMAT "yes/no":U WIDTH 5
  82. /* _UIB-CODE-BLOCK-END */
  83. &ANALYZE-RESUME
  84. WITH NO-ASSIGN NO-AUTO-VALIDATE NO-ROW-MARKERS SEPARATORS SIZE 100.4 BY 6.67
  85. BGCOLOR 15 FIT-LAST-COLUMN.
  86. /* ************************ Frame Definitions *********************** */
  87. DEFINE FRAME F-Main
  88. br_table AT ROW 1.48 COL 3
  89. RECT-1 AT ROW 1.24 COL 2
  90. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
  91. SIDE-LABELS NO-UNDERLINE THREE-D
  92. AT COL 1 ROW 1 SCROLLABLE .
  93. /* *********************** Procedure Settings ************************ */
  94. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  95. /* Settings for THIS-PROCEDURE
  96. Type: SmartDataBrowser
  97. Data Source: "d-fakart.w"
  98. Allow: Basic,Browse
  99. Frames: 1
  100. Add Fields to: Neither
  101. Other Settings: PERSISTENT-ONLY COMPILE
  102. */
  103. /* This procedure should always be RUN PERSISTENT. Report the error, */
  104. /* then cleanup and return. */
  105. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  106. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  107. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  108. RETURN.
  109. END.
  110. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  111. /* ************************* Create Window ************************** */
  112. &ANALYZE-SUSPEND _CREATE-WINDOW
  113. /* DESIGN Window definition (used by the UIB)
  114. CREATE WINDOW bTableWin ASSIGN
  115. HEIGHT = 7.62
  116. WIDTH = 108.8.
  117. /* END WINDOW DEFINITION */
  118. */
  119. &ANALYZE-RESUME
  120. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB bTableWin
  121. /* ************************* Included-Libraries *********************** */
  122. {src/adm2/browser.i}
  123. /* _UIB-CODE-BLOCK-END */
  124. &ANALYZE-RESUME
  125. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  126. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  127. /* SETTINGS FOR WINDOW bTableWin
  128. NOT-VISIBLE,,RUN-PERSISTENT */
  129. /* SETTINGS FOR FRAME F-Main
  130. NOT-VISIBLE Size-to-Fit */
  131. /* BROWSE-TAB br_table RECT-1 F-Main */
  132. ASSIGN
  133. FRAME F-Main:SCROLLABLE = FALSE
  134. FRAME F-Main: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_table
  139. /* Query rebuild information for BROWSE br_table
  140. _TblList = "rowObject"
  141. _Options = "NO-LOCK INDEXED-REPOSITION"
  142. _FldNameList[1] > _<SDO>.rowObject.CodeI
  143. "CodeI" "Cd" ? "integer" ? ? ? ? ? ? no "?" no no "3" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  144. _FldNameList[2] > _<SDO>.rowObject.Bez1
  145. "Bez1" "Dokumentbezeichnung" ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  146. _FldNameList[3] > _<SDO>.rowObject.Bez2
  147. "Bez2" ? ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  148. _FldNameList[4] > _<SDO>.rowObject.Int_1
  149. "Int_1" "NA" ? "integer" ? ? ? ? ? ? no "?" no no "4" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  150. _FldNameList[5] > _<SDO>.rowObject.Int_2
  151. "Int_2" "NS" ? "integer" ? ? ? ? ? ? no "?" no no "4" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  152. _FldNameList[6] > _<SDO>.rowObject.Int_3
  153. "Int_3" ? ? "integer" ? ? ? ? ? ? no "?" no no "4" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  154. _FldNameList[7] > _<SDO>.rowObject.Dec_1
  155. "Dec_1" "DM" ? "decimal" ? ? ? ? ? ? no "?" no no "4" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  156. _FldNameList[8] > _<SDO>.rowObject.Dec_2
  157. "Dec_2" "Rü" ? "decimal" ? ? ? ? ? ? no "?" no no "4" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  158. _FldNameList[9] > _<SDO>.rowObject.Flag_1
  159. "Flag_1" "Fest" ? "logical" ? ? ? ? ? ? no ? no no "5" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  160. _Query is NOT OPENED
  161. */ /* BROWSE br_table */
  162. &ANALYZE-RESUME
  163. &ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
  164. /* Query rebuild information for FRAME F-Main
  165. _Options = "NO-LOCK"
  166. _Query is NOT OPENED
  167. */ /* FRAME F-Main */
  168. &ANALYZE-RESUME
  169. /* ************************ Control Triggers ************************ */
  170. &Scoped-define BROWSE-NAME br_table
  171. &Scoped-define SELF-NAME br_table
  172. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  173. ON CTRL-END OF br_table IN FRAME F-Main
  174. DO:
  175. APPLY "END":U TO BROWSE {&BROWSE-NAME}.
  176. END.
  177. /* _UIB-CODE-BLOCK-END */
  178. &ANALYZE-RESUME
  179. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  180. ON CTRL-HOME OF br_table IN FRAME F-Main
  181. DO:
  182. APPLY "HOME":U TO BROWSE {&BROWSE-NAME}.
  183. END.
  184. /* _UIB-CODE-BLOCK-END */
  185. &ANALYZE-RESUME
  186. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  187. ON END OF br_table IN FRAME F-Main
  188. DO:
  189. {src/adm2/brsend.i}
  190. END.
  191. /* _UIB-CODE-BLOCK-END */
  192. &ANALYZE-RESUME
  193. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  194. ON HOME OF br_table IN FRAME F-Main
  195. DO:
  196. {src/adm2/brshome.i}
  197. END.
  198. /* _UIB-CODE-BLOCK-END */
  199. &ANALYZE-RESUME
  200. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  201. ON OFF-END OF br_table IN FRAME F-Main
  202. DO:
  203. {src/adm2/brsoffnd.i}
  204. END.
  205. /* _UIB-CODE-BLOCK-END */
  206. &ANALYZE-RESUME
  207. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  208. ON OFF-HOME OF br_table IN FRAME F-Main
  209. DO:
  210. {src/adm2/brsoffhm.i}
  211. END.
  212. /* _UIB-CODE-BLOCK-END */
  213. &ANALYZE-RESUME
  214. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  215. ON ROW-ENTRY OF br_table IN FRAME F-Main
  216. DO:
  217. {src/adm2/brsentry.i}
  218. END.
  219. /* _UIB-CODE-BLOCK-END */
  220. &ANALYZE-RESUME
  221. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  222. ON ROW-LEAVE OF br_table IN FRAME F-Main
  223. DO:
  224. {src/adm2/brsleave.i}
  225. END.
  226. /* _UIB-CODE-BLOCK-END */
  227. &ANALYZE-RESUME
  228. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  229. ON SCROLL-NOTIFY OF br_table IN FRAME F-Main
  230. DO:
  231. {src/adm2/brsscrol.i}
  232. END.
  233. /* _UIB-CODE-BLOCK-END */
  234. &ANALYZE-RESUME
  235. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  236. ON VALUE-CHANGED OF br_table IN FRAME F-Main
  237. DO:
  238. {src/adm2/brschnge.i}
  239. END.
  240. /* _UIB-CODE-BLOCK-END */
  241. &ANALYZE-RESUME
  242. &UNDEFINE SELF-NAME
  243. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK bTableWin
  244. /* *************************** Main Block *************************** */
  245. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  246. RUN initializeObject.
  247. &ENDIF
  248. /* _UIB-CODE-BLOCK-END */
  249. &ANALYZE-RESUME
  250. /* ********************** Internal Procedures *********************** */
  251. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI bTableWin _DEFAULT-DISABLE
  252. PROCEDURE disable_UI :
  253. /*------------------------------------------------------------------------------
  254. Purpose: DISABLE the User Interface
  255. Parameters: <none>
  256. Notes: Here we clean-up the user-interface by deleting
  257. dynamic widgets we have created and/or hide
  258. frames. This procedure is usually called when
  259. we are ready to "clean-up" after running.
  260. ------------------------------------------------------------------------------*/
  261. /* Hide all frames. */
  262. HIDE FRAME F-Main.
  263. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  264. END PROCEDURE.
  265. /* _UIB-CODE-BLOCK-END */
  266. &ANALYZE-RESUME