b-fehlwerte.w 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481
  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. { incl/tmpbrowser.i }
  28. {src/adm2/widgetprto.i}
  29. /* _UIB-CODE-BLOCK-END */
  30. &ANALYZE-RESUME
  31. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  32. /* ******************** Preprocessor Definitions ******************** */
  33. &Scoped-define PROCEDURE-TYPE SmartDataBrowser
  34. &Scoped-define DB-AWARE no
  35. &Scoped-define ADM-SUPPORTED-LINKS TableIO-Target,Data-Target,Update-Source
  36. /* Include file with RowObject temp-table definition */
  37. &Scoped-define DATA-FIELD-DEFS "d-fehlwerte.i"
  38. /* Name of designated FRAME-NAME and/or first browse and/or first query */
  39. &Scoped-define FRAME-NAME F-Main
  40. &Scoped-define BROWSE-NAME br_table
  41. /* Internal Tables (found by Frame, Query & Browse Queries) */
  42. &Scoped-define INTERNAL-TABLES rowObject
  43. /* Definitions for BROWSE br_table */
  44. &Scoped-define FIELDS-IN-QUERY-br_table rowObject.Art ~
  45. rowObject.Beschreibung rowObject.FeldType rowObject.Inhalt
  46. &Scoped-define ENABLED-FIELDS-IN-QUERY-br_table
  47. &Scoped-define QUERY-STRING-br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION
  48. &Scoped-define OPEN-QUERY-br_table OPEN QUERY br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION.
  49. &Scoped-define TABLES-IN-QUERY-br_table rowObject
  50. &Scoped-define FIRST-TABLE-IN-QUERY-br_table rowObject
  51. /* Definitions for FRAME F-Main */
  52. /* Standard List Definitions */
  53. &Scoped-Define ENABLED-OBJECTS RECT-1 br_table
  54. /* Custom List Definitions */
  55. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  56. /* _UIB-PREPROCESSOR-BLOCK-END */
  57. &ANALYZE-RESUME
  58. /* ************************ Function Prototypes ********************** */
  59. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD setZeilenfarbe bTableWin
  60. FUNCTION setZeilenfarbe RETURNS LOGICAL
  61. ( ipFarbe AS INT ) FORWARD.
  62. /* _UIB-CODE-BLOCK-END */
  63. &ANALYZE-RESUME
  64. /* *********************** Control Definitions ********************** */
  65. /* Definitions of the field level widgets */
  66. DEFINE RECTANGLE RECT-1
  67. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  68. SIZE 130 BY 7.14.
  69. /* Query definitions */
  70. &ANALYZE-SUSPEND
  71. DEFINE TEMP-TABLE RowObject NO-UNDO
  72. {{&DATA-FIELD-DEFS}}
  73. {src/adm2/robjflds.i}.
  74. DEFINE QUERY br_table FOR
  75. rowObject SCROLLING.
  76. &ANALYZE-RESUME
  77. /* Browse definitions */
  78. DEFINE BROWSE br_table
  79. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_table bTableWin _STRUCTURED
  80. QUERY br_table NO-LOCK DISPLAY
  81. rowObject.Art FORMAT "x(20)":U
  82. rowObject.Beschreibung FORMAT "x(250)":U WIDTH 50
  83. rowObject.FeldType FORMAT "99":U
  84. rowObject.Inhalt FORMAT "x(60)":U WIDTH 40
  85. /* _UIB-CODE-BLOCK-END */
  86. &ANALYZE-RESUME
  87. WITH NO-ASSIGN NO-AUTO-VALIDATE NO-ROW-MARKERS SEPARATORS SIZE 128 BY 6.67.
  88. /* ************************ Frame Definitions *********************** */
  89. DEFINE FRAME F-Main
  90. br_table AT ROW 1.48 COL 3 WIDGET-ID 200
  91. RECT-1 AT ROW 1.24 COL 2 WIDGET-ID 2
  92. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
  93. SIDE-LABELS NO-UNDERLINE THREE-D
  94. AT COL 1 ROW 1 SCROLLABLE WIDGET-ID 100.
  95. /* *********************** Procedure Settings ************************ */
  96. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  97. /* Settings for THIS-PROCEDURE
  98. Type: SmartDataBrowser
  99. Data Source: "d-fehlwerte.w"
  100. Allow: Basic,Browse
  101. Frames: 1
  102. Add Fields to: Neither
  103. Other Settings: PERSISTENT-ONLY COMPILE
  104. */
  105. /* This procedure should always be RUN PERSISTENT. Report the error, */
  106. /* then cleanup and return. */
  107. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  108. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  109. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  110. RETURN.
  111. END.
  112. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  113. /* ************************* Create Window ************************** */
  114. &ANALYZE-SUSPEND _CREATE-WINDOW
  115. /* DESIGN Window definition (used by the UIB)
  116. CREATE WINDOW bTableWin ASSIGN
  117. HEIGHT = 7.62
  118. WIDTH = 132.
  119. /* END WINDOW DEFINITION */
  120. */
  121. &ANALYZE-RESUME
  122. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB bTableWin
  123. /* ************************* Included-Libraries *********************** */
  124. {src/adm2/browser.i}
  125. /* _UIB-CODE-BLOCK-END */
  126. &ANALYZE-RESUME
  127. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  128. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  129. /* SETTINGS FOR WINDOW bTableWin
  130. NOT-VISIBLE,,RUN-PERSISTENT */
  131. /* SETTINGS FOR FRAME F-Main
  132. NOT-VISIBLE FRAME-NAME Size-to-Fit */
  133. /* BROWSE-TAB br_table RECT-1 F-Main */
  134. ASSIGN
  135. FRAME F-Main:SCROLLABLE = FALSE
  136. FRAME F-Main:HIDDEN = TRUE.
  137. /* _RUN-TIME-ATTRIBUTES-END */
  138. &ANALYZE-RESUME
  139. /* Setting information for Queries and Browse Widgets fields */
  140. &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE br_table
  141. /* Query rebuild information for BROWSE br_table
  142. _TblList = "rowObject"
  143. _Options = "NO-LOCK INDEXED-REPOSITION"
  144. _FldNameList[1] > _<SDO>.rowObject.Art
  145. "rowObject.Art" ? ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  146. _FldNameList[2] > _<SDO>.rowObject.Beschreibung
  147. "rowObject.Beschreibung" ? ? "character" ? ? ? ? ? ? no "?" no no "50" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  148. _FldNameList[3] > _<SDO>.rowObject.FeldType
  149. "rowObject.FeldType" ? ? "integer" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  150. _FldNameList[4] > _<SDO>.rowObject.Inhalt
  151. "rowObject.Inhalt" ? ? "character" ? ? ? ? ? ? no ? no no "40" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  152. _Query is NOT OPENED
  153. */ /* BROWSE br_table */
  154. &ANALYZE-RESUME
  155. &ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
  156. /* Query rebuild information for FRAME F-Main
  157. _Options = "NO-LOCK"
  158. _Query is NOT OPENED
  159. */ /* FRAME F-Main */
  160. &ANALYZE-RESUME
  161. /* ************************ Control Triggers ************************ */
  162. &Scoped-define BROWSE-NAME br_table
  163. &Scoped-define SELF-NAME br_table
  164. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  165. ON CTRL-END OF br_table IN FRAME F-Main
  166. DO:
  167. APPLY "END":U TO BROWSE {&BROWSE-NAME}.
  168. END.
  169. /* _UIB-CODE-BLOCK-END */
  170. &ANALYZE-RESUME
  171. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  172. ON CTRL-HOME OF br_table IN FRAME F-Main
  173. DO:
  174. APPLY "HOME":U TO BROWSE {&BROWSE-NAME}.
  175. END.
  176. /* _UIB-CODE-BLOCK-END */
  177. &ANALYZE-RESUME
  178. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  179. ON DEFAULT-ACTION OF br_table IN FRAME F-Main
  180. DO:
  181. {src/adm2/brsdefault.i}
  182. END.
  183. /* _UIB-CODE-BLOCK-END */
  184. &ANALYZE-RESUME
  185. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  186. ON END OF br_table IN FRAME F-Main
  187. DO:
  188. {src/adm2/brsend.i}
  189. END.
  190. /* _UIB-CODE-BLOCK-END */
  191. &ANALYZE-RESUME
  192. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  193. ON HOME OF br_table IN FRAME F-Main
  194. DO:
  195. {src/adm2/brshome.i}
  196. END.
  197. /* _UIB-CODE-BLOCK-END */
  198. &ANALYZE-RESUME
  199. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  200. ON LEFT-MOUSE-CLICK OF br_table IN FRAME F-Main
  201. DO:
  202. APPLY 'ENTRY' TO {&BROWSE-NAME}.
  203. END.
  204. /* _UIB-CODE-BLOCK-END */
  205. &ANALYZE-RESUME
  206. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  207. ON LEFT-MOUSE-DBLCLICK OF br_table IN FRAME F-Main
  208. DO:
  209. IF NOT VALID-HANDLE( hFenster ) THEN RETURN NO-APPLY.
  210. RUN TOOLBAR IN hFenster ( INPUT 'UPDATE' ).
  211. RETURN NO-APPLY.
  212. END.
  213. /* _UIB-CODE-BLOCK-END */
  214. &ANALYZE-RESUME
  215. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  216. ON OFF-END OF br_table IN FRAME F-Main
  217. DO:
  218. {src/adm2/brsoffnd.i}
  219. END.
  220. /* _UIB-CODE-BLOCK-END */
  221. &ANALYZE-RESUME
  222. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  223. ON OFF-HOME OF br_table IN FRAME F-Main
  224. DO:
  225. {src/adm2/brsoffhm.i}
  226. END.
  227. /* _UIB-CODE-BLOCK-END */
  228. &ANALYZE-RESUME
  229. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  230. ON ROW-ENTRY OF br_table IN FRAME F-Main
  231. DO:
  232. {src/adm2/brsentry.i}
  233. END.
  234. /* _UIB-CODE-BLOCK-END */
  235. &ANALYZE-RESUME
  236. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  237. ON ROW-LEAVE OF br_table IN FRAME F-Main
  238. DO:
  239. {src/adm2/brsleave.i}
  240. END.
  241. /* _UIB-CODE-BLOCK-END */
  242. &ANALYZE-RESUME
  243. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  244. ON SCROLL-NOTIFY OF br_table IN FRAME F-Main
  245. DO:
  246. {src/adm2/brsscrol.i}
  247. END.
  248. /* _UIB-CODE-BLOCK-END */
  249. &ANALYZE-RESUME
  250. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  251. ON START-SEARCH OF br_table IN FRAME F-Main
  252. DO:
  253. { incl/brwstartsearch.i }
  254. END.
  255. /* _UIB-CODE-BLOCK-END */
  256. &ANALYZE-RESUME
  257. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  258. ON VALUE-CHANGED OF br_table IN FRAME F-Main
  259. DO:
  260. {src/adm2/brschnge.i}
  261. END.
  262. /* _UIB-CODE-BLOCK-END */
  263. &ANALYZE-RESUME
  264. &UNDEFINE SELF-NAME
  265. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK bTableWin
  266. /* *************************** Main Block *************************** */
  267. { incl/brwmainblock.i }
  268. { incl/brwinternproc.i }
  269. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  270. RUN initializeObject.
  271. &ENDIF
  272. /* _UIB-CODE-BLOCK-END */
  273. &ANALYZE-RESUME
  274. /* ********************** Internal Procedures *********************** */
  275. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE destroyObject bTableWin
  276. PROCEDURE destroyObject :
  277. /*------------------------------------------------------------------------------
  278. Purpose: Super Override
  279. Parameters:
  280. Notes:
  281. ------------------------------------------------------------------------------*/
  282. DEF VAR hBrowser AS HANDLE NO-UNDO.
  283. hBrowser = {&BROWSE-NAME}:HANDLE IN FRAME {&FRAME-NAME}.
  284. DYNAMIC-FUNCTION('setBrowserDaten':U, INPUT hBrowser,
  285. INPUT Sektion ) NO-ERROR.
  286. RUN SUPER.
  287. /* Code placed here will execute AFTER standard behavior. */
  288. END PROCEDURE.
  289. /* _UIB-CODE-BLOCK-END */
  290. &ANALYZE-RESUME
  291. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI bTableWin _DEFAULT-DISABLE
  292. PROCEDURE disable_UI :
  293. /*------------------------------------------------------------------------------
  294. Purpose: DISABLE the User Interface
  295. Parameters: <none>
  296. Notes: Here we clean-up the user-interface by deleting
  297. dynamic widgets we have created and/or hide
  298. frames. This procedure is usually called when
  299. we are ready to "clean-up" after running.
  300. ------------------------------------------------------------------------------*/
  301. /* Hide all frames. */
  302. HIDE FRAME F-Main.
  303. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  304. END PROCEDURE.
  305. /* _UIB-CODE-BLOCK-END */
  306. &ANALYZE-RESUME
  307. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_BROWSE bTableWin
  308. PROCEDURE ENTRY_BROWSE :
  309. /*------------------------------------------------------------------------------
  310. Purpose:
  311. Parameters: <none>
  312. Notes:
  313. ------------------------------------------------------------------------------*/
  314. APPLY 'ENTRY' TO {&BROWSE-NAME} IN FRAME {&FRAME-NAME}.
  315. RETURN NO-APPLY.
  316. END PROCEDURE.
  317. /* _UIB-CODE-BLOCK-END */
  318. &ANALYZE-RESUME
  319. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject bTableWin
  320. PROCEDURE initializeObject :
  321. /*------------------------------------------------------------------------------
  322. Purpose: Super Override
  323. Parameters:
  324. Notes:
  325. ------------------------------------------------------------------------------*/
  326. { incl/brwinitialize.i }
  327. END PROCEDURE.
  328. /* _UIB-CODE-BLOCK-END */
  329. &ANALYZE-RESUME
  330. /* ************************ Function Implementations ***************** */
  331. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION setZeilenfarbe bTableWin
  332. FUNCTION setZeilenfarbe RETURNS LOGICAL
  333. ( ipFarbe AS INT ) :
  334. /*------------------------------------------------------------------------------
  335. Purpose:
  336. Notes:
  337. ------------------------------------------------------------------------------*/
  338. { incl/brwsetzeilenfarbe.i }
  339. END FUNCTION.
  340. /* _UIB-CODE-BLOCK-END */
  341. &ANALYZE-RESUME