d-drucker-neu.w 10.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292
  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. {adecomm/appserv.i}
  8. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS dTables
  9. /*------------------------------------------------------------------------
  10. File:
  11. Description: from DATA.W - Template For SmartData objects in the ADM
  12. Input Parameters:
  13. <none>
  14. Output Parameters:
  15. <none>
  16. Modified: February 24, 1999
  17. ------------------------------------------------------------------------*/
  18. /* This .W file was created with the Progress AppBuilder. */
  19. /*----------------------------------------------------------------------*/
  20. /* Create an unnamed pool to store all the widgets created
  21. by this procedure. This is a good default which assures
  22. that this procedure's triggers and internal procedures
  23. will execute in this procedure's storage, and that proper
  24. cleanup will occur on deletion of the procedure. */
  25. CREATE WIDGET-POOL.
  26. /* *************************** Definitions ************************** */
  27. /* Parameters Definitions --- */
  28. /* Local Variable Definitions --- */
  29. DEF VAR xWhere AS CHAR NO-UNDO.
  30. DEF VAR xSort AS CHAR NO-UNDO.
  31. DEF VAR Firma AS CHAR NO-UNDO.
  32. DEF VAR SAktiv AS LOG NO-UNDO INIT FALSE.
  33. /* _UIB-CODE-BLOCK-END */
  34. &ANALYZE-RESUME
  35. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  36. /* ******************** Preprocessor Definitions ******************** */
  37. &Scoped-define PROCEDURE-TYPE SmartDataObject
  38. &Scoped-define DB-AWARE yes
  39. &Scoped-define ADM-SUPPORTED-LINKS Data-Source,Data-Target,Navigation-Target,Update-Target,Commit-Target,Filter-Target
  40. /* Db-Required definitions. */
  41. &IF DEFINED(DB-REQUIRED) = 0 &THEN
  42. &GLOBAL-DEFINE DB-REQUIRED TRUE
  43. &ENDIF
  44. &GLOBAL-DEFINE DB-REQUIRED-START &IF {&DB-REQUIRED} &THEN
  45. &GLOBAL-DEFINE DB-REQUIRED-END &ENDIF
  46. &Scoped-define QUERY-NAME Query-Main
  47. /* Internal Tables (found by Frame, Query & Browse Queries) */
  48. &Scoped-define INTERNAL-TABLES Drucker
  49. /* Definitions for QUERY Query-Main */
  50. &Scoped-Define ENABLED-FIELDS Drucker Emul DruSchacht1 DruSchacht2 DruSchacht3 DruSchacht4 DruSchacht5~
  51. DruSchacht6 DruSchacht7 DruSchacht8 DruSchacht9
  52. &Scoped-define ENABLED-FIELDS-IN-Drucker Drucker Emul DruSchacht1 ~
  53. DruSchacht2 DruSchacht3 DruSchacht4 DruSchacht5 DruSchacht6 DruSchacht7 ~
  54. DruSchacht8 DruSchacht9
  55. &Scoped-Define DATA-FIELDS Drucker Emul DruSchacht1 DruSchacht2 DruSchacht3 DruSchacht4 DruSchacht5~
  56. DruSchacht6 DruSchacht7 DruSchacht8 DruSchacht9
  57. &Scoped-define DATA-FIELDS-IN-Drucker Drucker Emul DruSchacht1 DruSchacht2 ~
  58. DruSchacht3 DruSchacht4 DruSchacht5 DruSchacht6 DruSchacht7 DruSchacht8 ~
  59. DruSchacht9
  60. &Scoped-Define MANDATORY-FIELDS Drucker
  61. &Scoped-Define APPLICATION-SERVICE
  62. &Scoped-Define ASSIGN-LIST rowObject.DruSchacht1 = Drucker.DruSchacht[1]~
  63. rowObject.DruSchacht2 = Drucker.DruSchacht[2]~
  64. rowObject.DruSchacht3 = Drucker.DruSchacht[3]~
  65. rowObject.DruSchacht4 = Drucker.DruSchacht[4]~
  66. rowObject.DruSchacht5 = Drucker.DruSchacht[5]~
  67. rowObject.DruSchacht6 = Drucker.DruSchacht[6]~
  68. rowObject.DruSchacht7 = Drucker.DruSchacht[7]~
  69. rowObject.DruSchacht8 = Drucker.DruSchacht[8]~
  70. rowObject.DruSchacht9 = Drucker.DruSchacht[9]
  71. &Scoped-Define DATA-FIELD-DEFS "d-drucker-neu.i"
  72. &Scoped-define QUERY-STRING-Query-Main FOR EACH Drucker NO-LOCK INDEXED-REPOSITION
  73. {&DB-REQUIRED-START}
  74. &Scoped-define OPEN-QUERY-Query-Main OPEN QUERY Query-Main FOR EACH Drucker NO-LOCK INDEXED-REPOSITION.
  75. {&DB-REQUIRED-END}
  76. &Scoped-define TABLES-IN-QUERY-Query-Main Drucker
  77. &Scoped-define FIRST-TABLE-IN-QUERY-Query-Main Drucker
  78. /* Custom List Definitions */
  79. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  80. /* _UIB-PREPROCESSOR-BLOCK-END */
  81. &ANALYZE-RESUME
  82. /* ************************ Function Prototypes ********************** */
  83. {&DB-REQUIRED-START}
  84. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD openQuery dTables _DB-REQUIRED
  85. FUNCTION openQuery RETURNS LOGICAL
  86. ( /* parameter-definitions */ ) FORWARD.
  87. /* _UIB-CODE-BLOCK-END */
  88. &ANALYZE-RESUME
  89. {&DB-REQUIRED-END}
  90. /* *********************** Control Definitions ********************** */
  91. {&DB-REQUIRED-START}
  92. /* Query definitions */
  93. &ANALYZE-SUSPEND
  94. DEFINE QUERY Query-Main FOR
  95. Drucker SCROLLING.
  96. &ANALYZE-RESUME
  97. {&DB-REQUIRED-END}
  98. /* ************************ Frame Definitions *********************** */
  99. /* *********************** Procedure Settings ************************ */
  100. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  101. /* Settings for THIS-PROCEDURE
  102. Type: SmartDataObject
  103. Allow: Query
  104. Frames: 0
  105. Add Fields to: Neither
  106. Other Settings: PERSISTENT-ONLY COMPILE APPSERVER DB-AWARE
  107. */
  108. /* This procedure should always be RUN PERSISTENT. Report the error, */
  109. /* then cleanup and return. */
  110. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  111. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  112. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  113. RETURN.
  114. END.
  115. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  116. /* ************************* Create Window ************************** */
  117. &ANALYZE-SUSPEND _CREATE-WINDOW
  118. /* DESIGN Window definition (used by the UIB)
  119. CREATE WINDOW dTables ASSIGN
  120. HEIGHT = 2
  121. WIDTH = 65.2.
  122. /* END WINDOW DEFINITION */
  123. */
  124. &ANALYZE-RESUME
  125. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB dTables
  126. /* ************************* Included-Libraries *********************** */
  127. {src/adm2/data.i}
  128. /* _UIB-CODE-BLOCK-END */
  129. &ANALYZE-RESUME
  130. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  131. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  132. /* SETTINGS FOR WINDOW dTables
  133. VISIBLE,,RUN-PERSISTENT */
  134. /* _RUN-TIME-ATTRIBUTES-END */
  135. &ANALYZE-RESUME
  136. /* Setting information for Queries and Browse Widgets fields */
  137. &ANALYZE-SUSPEND _QUERY-BLOCK QUERY Query-Main
  138. /* Query rebuild information for SmartDataObject Query-Main
  139. _TblList = "AnaDat.Drucker"
  140. _Options = "NO-LOCK INDEXED-REPOSITION"
  141. _FldNameList[1] > AnaDat.Drucker.Drucker
  142. "Drucker" "Drucker" ? "x(60)" "character" ? ? ? ? ? ? yes ? yes 60 no ?
  143. _FldNameList[2] > AnaDat.Drucker.Emul
  144. "Emul" "Emul" ? ? "character" ? ? ? ? ? ? yes ? no 20 yes ?
  145. _FldNameList[3] > AnaDat.Drucker.DruSchacht[1]
  146. "DruSchacht[1]" "DruSchacht1" "Schacht Original" "x(20)" "character" ? ? ? ? ? ? yes ? no 20 yes ?
  147. _FldNameList[4] > AnaDat.Drucker.DruSchacht[2]
  148. "DruSchacht[2]" "DruSchacht2" "Schacht Kopien" "x(20)" "character" ? ? ? ? ? ? yes ? no 20 yes ?
  149. _FldNameList[5] > AnaDat.Drucker.DruSchacht[3]
  150. "DruSchacht[3]" "DruSchacht3" "Schacht BESR" "x(20)" "character" ? ? ? ? ? ? yes ? no 20 yes ?
  151. _FldNameList[6] > AnaDat.Drucker.DruSchacht[4]
  152. "DruSchacht[4]" "DruSchacht4" "BESR Art" "x(20)" "character" ? ? ? ? ? ? yes ? no 20 yes ?
  153. _FldNameList[7] > AnaDat.Drucker.DruSchacht[5]
  154. "DruSchacht[5]" "DruSchacht5" "Anzahl" "x(20)" "character" ? ? ? ? ? ? yes ? no 20 yes ?
  155. _FldNameList[8] > AnaDat.Drucker.DruSchacht[6]
  156. "DruSchacht[6]" "DruSchacht6" ? ? "character" ? ? ? ? ? ? yes ? no 30 yes ?
  157. _FldNameList[9] > AnaDat.Drucker.DruSchacht[7]
  158. "DruSchacht[7]" "DruSchacht7" ? ? "character" ? ? ? ? ? ? yes ? no 30 yes ?
  159. _FldNameList[10] > AnaDat.Drucker.DruSchacht[8]
  160. "DruSchacht[8]" "DruSchacht8" ? ? "character" ? ? ? ? ? ? yes ? no 30 yes ?
  161. _FldNameList[11] > AnaDat.Drucker.DruSchacht[9]
  162. "DruSchacht[9]" "DruSchacht9" ? ? "character" ? ? ? ? ? ? yes ? no 30 yes ?
  163. _Design-Parent is WINDOW dTables @ ( 1.14 , 2.6 )
  164. */ /* QUERY Query-Main */
  165. &ANALYZE-RESUME
  166. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK dTables
  167. /* *************************** Main Block *************************** */
  168. SAktiv = DYNAMIC-FUNCTION('getSuperAktiv':U) NO-ERROR.
  169. IF SAktiv THEN DO:
  170. Firma = DYNAMIC-FUNCTION('GETMANDANT':U) NO-ERROR.
  171. END.
  172. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  173. RUN initializeObject.
  174. &ENDIF
  175. /* _UIB-CODE-BLOCK-END */
  176. &ANALYZE-RESUME
  177. /* ********************** Internal Procedures *********************** */
  178. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI dTables _DEFAULT-DISABLE
  179. PROCEDURE disable_UI :
  180. /*------------------------------------------------------------------------------
  181. Purpose: DISABLE the User Interface
  182. Parameters: <none>
  183. Notes: Here we clean-up the user-interface by deleting
  184. dynamic widgets we have created and/or hide
  185. frames. This procedure is usually called when
  186. we are ready to "clean-up" after running.
  187. ------------------------------------------------------------------------------*/
  188. /* Hide all frames. */
  189. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  190. END PROCEDURE.
  191. /* _UIB-CODE-BLOCK-END */
  192. &ANALYZE-RESUME
  193. /* ************************ Function Implementations ***************** */
  194. {&DB-REQUIRED-START}
  195. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION openQuery dTables _DB-REQUIRED
  196. FUNCTION openQuery RETURNS LOGICAL
  197. ( /* parameter-definitions */ ) :
  198. /*------------------------------------------------------------------------------
  199. Purpose: Super Override
  200. Notes:
  201. ------------------------------------------------------------------------------*/
  202. /* xWhere = ''. */
  203. /* DYNAMIC-FUNCTION('setQueryWhere':U, INPUT xWhere). */
  204. /* xSort = ''. */
  205. /* DYNAMIC-FUNCTION('setQuerySort':U, INPUT xSort). */
  206. /* xWhere = ''. */
  207. /* DYNAMIC-FUNCTION('setQueryString':U, INPUT xWhere). */
  208. RETURN SUPER( ).
  209. END FUNCTION.
  210. /* _UIB-CODE-BLOCK-END */
  211. &ANALYZE-RESUME
  212. {&DB-REQUIRED-END}