d-ruestdaten.w 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548
  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. &glob DATA-LOGIC-PROCEDURE .p
  30. &SCOPED-DEFINE Tabelle RuestDaten
  31. &SCOPED-DEFINE TabWhere /* USE-INDEX Benutzer-k1 ~
  32. WHERE {&Tabelle}.Benutzer = tRowObject.Benutzer
  33. */
  34. { incl/datdefinition.i }
  35. /* _UIB-CODE-BLOCK-END */
  36. &ANALYZE-RESUME
  37. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  38. /* ******************** Preprocessor Definitions ******************** */
  39. &Scoped-define PROCEDURE-TYPE SmartDataObject
  40. &Scoped-define DB-AWARE yes
  41. &Scoped-define ADM-SUPPORTED-LINKS Data-Source,Data-Target,Navigation-Target,Update-Target,Commit-Target,Filter-Target
  42. /* Db-Required definitions. */
  43. &IF DEFINED(DB-REQUIRED) = 0 &THEN
  44. &GLOBAL-DEFINE DB-REQUIRED TRUE
  45. &ENDIF
  46. &GLOBAL-DEFINE DB-REQUIRED-START &IF {&DB-REQUIRED} &THEN
  47. &GLOBAL-DEFINE DB-REQUIRED-END &ENDIF
  48. &Scoped-define QUERY-NAME Query-Main
  49. /* Internal Tables (found by Frame, Query & Browse Queries) */
  50. &Scoped-define INTERNAL-TABLES RuestDaten
  51. /* Definitions for QUERY Query-Main */
  52. &Scoped-Define ENABLED-FIELDS Firma RuestArt Platz AS_Doku AS_Drucker AS_Schrift AS_Anzahl AS_TotZZ~
  53. AS_KopfZZ AS_FussZZ AS_Schacht LA_Doku LA_Drucker LA_Schrift LA_Anzahl~
  54. LA_TotZZ LA_KopfZZ LA_FussZZ LA_Schacht PA_Doku PA_Drucker PA_Schrift~
  55. PA_Anzahl PA_TotZZ PA_KopfZZ PA_FussZZ PA_Schacht RU_Doku RU_Drucker~
  56. RU_Schrift RU_Anzahl RU_TotZZ RU_KopfZZ RU_FussZZ RU_Schacht
  57. &Scoped-define ENABLED-FIELDS-IN-RuestDaten Firma RuestArt Platz AS_Doku ~
  58. AS_Drucker AS_Schrift AS_Anzahl AS_TotZZ AS_KopfZZ AS_FussZZ AS_Schacht ~
  59. LA_Doku LA_Drucker LA_Schrift LA_Anzahl LA_TotZZ LA_KopfZZ LA_FussZZ ~
  60. LA_Schacht PA_Doku PA_Drucker PA_Schrift PA_Anzahl PA_TotZZ PA_KopfZZ ~
  61. PA_FussZZ PA_Schacht RU_Doku RU_Drucker RU_Schrift RU_Anzahl RU_TotZZ ~
  62. RU_KopfZZ RU_FussZZ RU_Schacht
  63. &Scoped-Define DATA-FIELDS Firma RuestArt Platz AS_Doku AS_Drucker AS_Schrift AS_Anzahl AS_TotZZ~
  64. AS_KopfZZ AS_FussZZ AS_Schacht LA_Doku LA_Drucker LA_Schrift LA_Anzahl~
  65. LA_TotZZ LA_KopfZZ LA_FussZZ LA_Schacht PA_Doku PA_Drucker PA_Schrift~
  66. PA_Anzahl PA_TotZZ PA_KopfZZ PA_FussZZ PA_Schacht RU_Doku RU_Drucker~
  67. RU_Schrift RU_Anzahl RU_TotZZ RU_KopfZZ RU_FussZZ RU_Schacht
  68. &Scoped-define DATA-FIELDS-IN-RuestDaten Firma RuestArt Platz AS_Doku ~
  69. AS_Drucker AS_Schrift AS_Anzahl AS_TotZZ AS_KopfZZ AS_FussZZ AS_Schacht ~
  70. LA_Doku LA_Drucker LA_Schrift LA_Anzahl LA_TotZZ LA_KopfZZ LA_FussZZ ~
  71. LA_Schacht PA_Doku PA_Drucker PA_Schrift PA_Anzahl PA_TotZZ PA_KopfZZ ~
  72. PA_FussZZ PA_Schacht RU_Doku RU_Drucker RU_Schrift RU_Anzahl RU_TotZZ ~
  73. RU_KopfZZ RU_FussZZ RU_Schacht
  74. &Scoped-Define MANDATORY-FIELDS
  75. &Scoped-Define APPLICATION-SERVICE
  76. &Scoped-Define ASSIGN-LIST
  77. &Scoped-Define DATA-FIELD-DEFS "d-ruestdaten.i"
  78. &Scoped-Define DATA-TABLE-NO-UNDO NO-UNDO
  79. &Scoped-define QUERY-STRING-Query-Main FOR EACH RuestDaten NO-LOCK INDEXED-REPOSITION
  80. {&DB-REQUIRED-START}
  81. &Scoped-define OPEN-QUERY-Query-Main OPEN QUERY Query-Main FOR EACH RuestDaten NO-LOCK INDEXED-REPOSITION.
  82. {&DB-REQUIRED-END}
  83. &Scoped-define TABLES-IN-QUERY-Query-Main RuestDaten
  84. &Scoped-define FIRST-TABLE-IN-QUERY-Query-Main RuestDaten
  85. /* Custom List Definitions */
  86. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  87. /* _UIB-PREPROCESSOR-BLOCK-END */
  88. &ANALYZE-RESUME
  89. /* ************************ Function Prototypes ********************** */
  90. {&DB-REQUIRED-START}
  91. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD getQueryBuffer dTables _DB-REQUIRED
  92. FUNCTION getQueryBuffer RETURNS HANDLE
  93. ( /* parameter-definitions */ ) FORWARD.
  94. /* _UIB-CODE-BLOCK-END */
  95. &ANALYZE-RESUME
  96. {&DB-REQUIRED-END}
  97. {&DB-REQUIRED-START}
  98. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD openQuery dTables _DB-REQUIRED
  99. FUNCTION openQuery RETURNS LOGICAL
  100. ( /* parameter-definitions */ ) FORWARD.
  101. /* _UIB-CODE-BLOCK-END */
  102. &ANALYZE-RESUME
  103. {&DB-REQUIRED-END}
  104. /* *********************** Control Definitions ********************** */
  105. {&DB-REQUIRED-START}
  106. /* Query definitions */
  107. &ANALYZE-SUSPEND
  108. DEFINE QUERY Query-Main FOR
  109. RuestDaten SCROLLING.
  110. &ANALYZE-RESUME
  111. {&DB-REQUIRED-END}
  112. /* ************************ Frame Definitions *********************** */
  113. /* *********************** Procedure Settings ************************ */
  114. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  115. /* Settings for THIS-PROCEDURE
  116. Type: SmartDataObject
  117. Allow: Query
  118. Frames: 0
  119. Add Fields to: Neither
  120. Other Settings: PERSISTENT-ONLY COMPILE APPSERVER DB-AWARE
  121. */
  122. /* This procedure should always be RUN PERSISTENT. Report the error, */
  123. /* then cleanup and return. */
  124. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  125. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  126. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  127. RETURN.
  128. END.
  129. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  130. /* ************************* Create Window ************************** */
  131. &ANALYZE-SUSPEND _CREATE-WINDOW
  132. /* DESIGN Window definition (used by the UIB)
  133. CREATE WINDOW dTables ASSIGN
  134. HEIGHT = 1.62
  135. WIDTH = 46.6.
  136. /* END WINDOW DEFINITION */
  137. */
  138. &ANALYZE-RESUME
  139. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB dTables
  140. /* ************************* Included-Libraries *********************** */
  141. {src/adm2/data.i}
  142. /* _UIB-CODE-BLOCK-END */
  143. &ANALYZE-RESUME
  144. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  145. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  146. /* SETTINGS FOR WINDOW dTables
  147. VISIBLE,,RUN-PERSISTENT */
  148. /* _RUN-TIME-ATTRIBUTES-END */
  149. &ANALYZE-RESUME
  150. /* Setting information for Queries and Browse Widgets fields */
  151. &ANALYZE-SUSPEND _QUERY-BLOCK QUERY Query-Main
  152. /* Query rebuild information for SmartDataObject Query-Main
  153. _TblList = "AnaDat.RuestDaten"
  154. _Options = "NO-LOCK INDEXED-REPOSITION"
  155. _FldNameList[1] > AnaDat.RuestDaten.Firma
  156. "Firma" "Firma" ? ? "character" ? ? ? ? ? ? yes ? no 8 yes ?
  157. _FldNameList[2] > AnaDat.RuestDaten.RuestArt
  158. "RuestArt" "RuestArt" ? ? "integer" ? ? ? ? ? ? yes ? no 8.2 yes ?
  159. _FldNameList[3] > AnaDat.RuestDaten.Platz
  160. "Platz" "Platz" ? ? "integer" ? ? ? ? ? ? yes ? no 4.6 yes ?
  161. _FldNameList[4] > AnaDat.RuestDaten.AS_Doku
  162. "AS_Doku" "AS_Doku" "Dokument Drucken" ? "logical" ? ? ? ? ? ? yes ? no 9.2 yes ?
  163. _FldNameList[5] > AnaDat.RuestDaten.AS_Drucker
  164. "AS_Drucker" "AS_Drucker" "Drucker" ? "character" ? ? ? ? ? ? yes ? no 40 yes ?
  165. _FldNameList[6] > AnaDat.RuestDaten.AS_Schrift
  166. "AS_Schrift" "AS_Schrift" "Schrift" ? "character" ? ? ? ? ? ? yes ? no 40 yes ?
  167. _FldNameList[7] > AnaDat.RuestDaten.AS_Anzahl
  168. "AS_Anzahl" "AS_Anzahl" "Anzahl" ? "integer" ? ? ? ? ? ? yes ? no 10.4 yes ?
  169. _FldNameList[8] > AnaDat.RuestDaten.AS_TotZZ
  170. "AS_TotZZ" "AS_TotZZ" "Total Zeilen" ? "integer" ? ? ? ? ? ? yes ? no 10 yes ?
  171. _FldNameList[9] > AnaDat.RuestDaten.AS_KopfZZ
  172. "AS_KopfZZ" "AS_KopfZZ" "Leere Kopfzeilen" ? "integer" ? ? ? ? ? ? yes ? no 11.2 yes ?
  173. _FldNameList[10] > AnaDat.RuestDaten.AS_FussZZ
  174. "AS_FussZZ" "AS_FussZZ" "leere Fusszeilen" ? "integer" ? ? ? ? ? ? yes ? no 11.2 yes ?
  175. _FldNameList[11] > AnaDat.RuestDaten.AS_Schacht
  176. "AS_Schacht" "AS_Schacht" "Schacht" ? "integer" ? ? ? ? ? ? yes ? no 12 yes ?
  177. _FldNameList[12] > AnaDat.RuestDaten.LA_Doku
  178. "LA_Doku" "LA_Doku" "Dokument Drucken" ? "logical" ? ? ? ? ? ? yes ? no 9 yes ?
  179. _FldNameList[13] > AnaDat.RuestDaten.LA_Drucker
  180. "LA_Drucker" "LA_Drucker" "Drucker" ? "character" ? ? ? ? ? ? yes ? no 40 yes ?
  181. _FldNameList[14] > AnaDat.RuestDaten.LA_Schrift
  182. "LA_Schrift" "LA_Schrift" "Schrift" ? "character" ? ? ? ? ? ? yes ? no 40 yes ?
  183. _FldNameList[15] > AnaDat.RuestDaten.LA_Anzahl
  184. "LA_Anzahl" "LA_Anzahl" "Anzahl" ? "integer" ? ? ? ? ? ? yes ? no 10.2 yes ?
  185. _FldNameList[16] > AnaDat.RuestDaten.LA_TotZZ
  186. "LA_TotZZ" "LA_TotZZ" "Total Zeilen" ? "integer" ? ? ? ? ? ? yes ? no 9.8 yes ?
  187. _FldNameList[17] > AnaDat.RuestDaten.LA_KopfZZ
  188. "LA_KopfZZ" "LA_KopfZZ" "Leere Kopfzeilen" ? "integer" ? ? ? ? ? ? yes ? no 11 yes ?
  189. _FldNameList[18] > AnaDat.RuestDaten.LA_FussZZ
  190. "LA_FussZZ" "LA_FussZZ" "leere Fusszeilen" ? "integer" ? ? ? ? ? ? yes ? no 11 yes ?
  191. _FldNameList[19] > AnaDat.RuestDaten.LA_Schacht
  192. "LA_Schacht" "LA_Schacht" "Schacht" ? "integer" ? ? ? ? ? ? yes ? no 11.8 yes ?
  193. _FldNameList[20] > AnaDat.RuestDaten.PA_Doku
  194. "PA_Doku" "PA_Doku" "Dokument Drucken" ? "logical" ? ? ? ? ? ? yes ? no 9.2 yes ?
  195. _FldNameList[21] > AnaDat.RuestDaten.PA_Drucker
  196. "PA_Drucker" "PA_Drucker" "Drucker" ? "character" ? ? ? ? ? ? yes ? no 40 yes ?
  197. _FldNameList[22] > AnaDat.RuestDaten.PA_Schrift
  198. "PA_Schrift" "PA_Schrift" "Schrift" ? "character" ? ? ? ? ? ? yes ? no 40 yes ?
  199. _FldNameList[23] > AnaDat.RuestDaten.PA_Anzahl
  200. "PA_Anzahl" "PA_Anzahl" "Anzahl" ? "integer" ? ? ? ? ? ? yes ? no 10.4 yes ?
  201. _FldNameList[24] > AnaDat.RuestDaten.PA_TotZZ
  202. "PA_TotZZ" "PA_TotZZ" "Total Zeilen" ? "integer" ? ? ? ? ? ? yes ? no 10 yes ?
  203. _FldNameList[25] > AnaDat.RuestDaten.PA_KopfZZ
  204. "PA_KopfZZ" "PA_KopfZZ" "Leere Kopfzeilen" ? "integer" ? ? ? ? ? ? yes ? no 11.2 yes ?
  205. _FldNameList[26] > AnaDat.RuestDaten.PA_FussZZ
  206. "PA_FussZZ" "PA_FussZZ" "leere Fusszeilen" ? "integer" ? ? ? ? ? ? yes ? no 11.2 yes ?
  207. _FldNameList[27] > AnaDat.RuestDaten.PA_Schacht
  208. "PA_Schacht" "PA_Schacht" "Schacht" ? "integer" ? ? ? ? ? ? yes ? no 12 yes ?
  209. _FldNameList[28] > AnaDat.RuestDaten.RU_Doku
  210. "RU_Doku" "RU_Doku" "Dokument Drucken" ? "logical" ? ? ? ? ? ? yes ? no 9.6 yes ?
  211. _FldNameList[29] > AnaDat.RuestDaten.RU_Drucker
  212. "RU_Drucker" "RU_Drucker" "Drucker" ? "character" ? ? ? ? ? ? yes ? no 40 yes ?
  213. _FldNameList[30] > AnaDat.RuestDaten.RU_Schrift
  214. "RU_Schrift" "RU_Schrift" "Schrift" ? "character" ? ? ? ? ? ? yes ? no 40 yes ?
  215. _FldNameList[31] > AnaDat.RuestDaten.RU_Anzahl
  216. "RU_Anzahl" "RU_Anzahl" "Anzahl" ? "integer" ? ? ? ? ? ? yes ? no 10.8 yes ?
  217. _FldNameList[32] > AnaDat.RuestDaten.RU_TotZZ
  218. "RU_TotZZ" "RU_TotZZ" "Total Zeilen" ? "integer" ? ? ? ? ? ? yes ? no 10.4 yes ?
  219. _FldNameList[33] > AnaDat.RuestDaten.RU_KopfZZ
  220. "RU_KopfZZ" "RU_KopfZZ" "Leere Kopfzeilen" ? "integer" ? ? ? ? ? ? yes ? no 11.6 yes ?
  221. _FldNameList[34] > AnaDat.RuestDaten.RU_FussZZ
  222. "RU_FussZZ" "RU_FussZZ" "leere Fusszeilen" ? "integer" ? ? ? ? ? ? yes ? no 11.6 yes ?
  223. _FldNameList[35] > AnaDat.RuestDaten.RU_Schacht
  224. "RU_Schacht" "RU_Schacht" "Schacht" ? "integer" ? ? ? ? ? ? yes ? no 12.4 yes ?
  225. _Design-Parent is WINDOW dTables @ ( 1.14 , 2.6 )
  226. */ /* QUERY Query-Main */
  227. &ANALYZE-RESUME
  228. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK dTables
  229. /* *************************** Main Block *************************** */
  230. { incl/datmainblock.i }
  231. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  232. RUN initializeObject.
  233. &ENDIF
  234. /* _UIB-CODE-BLOCK-END */
  235. &ANALYZE-RESUME
  236. /* ********************** Internal Procedures *********************** */
  237. {&DB-REQUIRED-START}
  238. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE dataAvailable dTables _DB-REQUIRED
  239. PROCEDURE dataAvailable :
  240. /*------------------------------------------------------------------------------
  241. Purpose: Super Override
  242. Parameters:
  243. Notes:
  244. ------------------------------------------------------------------------------*/
  245. { incl/datdataavailable.i }
  246. END PROCEDURE.
  247. /* _UIB-CODE-BLOCK-END */
  248. &ANALYZE-RESUME
  249. {&DB-REQUIRED-END}
  250. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI dTables _DEFAULT-DISABLE
  251. PROCEDURE disable_UI :
  252. /*------------------------------------------------------------------------------
  253. Purpose: DISABLE the User Interface
  254. Parameters: <none>
  255. Notes: Here we clean-up the user-interface by deleting
  256. dynamic widgets we have created and/or hide
  257. frames. This procedure is usually called when
  258. we are ready to "clean-up" after running.
  259. ------------------------------------------------------------------------------*/
  260. /* Hide all frames. */
  261. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  262. END PROCEDURE.
  263. /* _UIB-CODE-BLOCK-END */
  264. &ANALYZE-RESUME
  265. {&DB-REQUIRED-START}
  266. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE INAKTIVIEREN dTables _DB-REQUIRED
  267. PROCEDURE INAKTIVIEREN :
  268. /*------------------------------------------------------------------------------
  269. Purpose:
  270. Parameters: <none>
  271. Notes:
  272. ------------------------------------------------------------------------------*/
  273. { incl/datinaktivieren.i }
  274. END PROCEDURE.
  275. /* _UIB-CODE-BLOCK-END */
  276. &ANALYZE-RESUME
  277. {&DB-REQUIRED-END}
  278. {&DB-REQUIRED-START}
  279. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject dTables _DB-REQUIRED
  280. PROCEDURE initializeObject :
  281. /*------------------------------------------------------------------------------
  282. Purpose: Super Override
  283. Parameters:
  284. Notes:
  285. ------------------------------------------------------------------------------*/
  286. { incl/datinitialize.i }
  287. END PROCEDURE.
  288. /* _UIB-CODE-BLOCK-END */
  289. &ANALYZE-RESUME
  290. {&DB-REQUIRED-END}
  291. {&DB-REQUIRED-START}
  292. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE REAKTIVIEREN dTables _DB-REQUIRED
  293. PROCEDURE REAKTIVIEREN :
  294. /*------------------------------------------------------------------------------
  295. Purpose:
  296. Parameters: <none>
  297. Notes:
  298. ------------------------------------------------------------------------------*/
  299. { incl/datreaktivieren.i }
  300. END PROCEDURE.
  301. /* _UIB-CODE-BLOCK-END */
  302. &ANALYZE-RESUME
  303. {&DB-REQUIRED-END}
  304. {&DB-REQUIRED-START}
  305. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE REPOS_TABELLE dTables _DB-REQUIRED
  306. PROCEDURE REPOS_TABELLE :
  307. /*------------------------------------------------------------------------------
  308. Purpose:
  309. Parameters: <none>
  310. Notes:
  311. ------------------------------------------------------------------------------*/
  312. { incl/datrepos.i }
  313. END PROCEDURE.
  314. /* _UIB-CODE-BLOCK-END */
  315. &ANALYZE-RESUME
  316. {&DB-REQUIRED-END}
  317. {&DB-REQUIRED-START}
  318. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SET_FILTER dTables _DB-REQUIRED
  319. PROCEDURE SET_FILTER :
  320. /*------------------------------------------------------------------------------
  321. Purpose:
  322. Parameters: <none>
  323. Notes:
  324. ------------------------------------------------------------------------------*/
  325. { incl/datsetfilter.i }
  326. END PROCEDURE.
  327. /* _UIB-CODE-BLOCK-END */
  328. &ANALYZE-RESUME
  329. {&DB-REQUIRED-END}
  330. {&DB-REQUIRED-START}
  331. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SET_OPENFLAG dTables _DB-REQUIRED
  332. PROCEDURE SET_OPENFLAG :
  333. /*------------------------------------------------------------------------------
  334. Purpose:
  335. Parameters: <none>
  336. Notes:
  337. ------------------------------------------------------------------------------*/
  338. { incl/datsetopenflag.i }
  339. END PROCEDURE.
  340. /* _UIB-CODE-BLOCK-END */
  341. &ANALYZE-RESUME
  342. {&DB-REQUIRED-END}
  343. {&DB-REQUIRED-START}
  344. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SET_SORT dTables _DB-REQUIRED
  345. PROCEDURE SET_SORT :
  346. /*------------------------------------------------------------------------------
  347. Purpose:
  348. Parameters: <none>
  349. Notes:
  350. ------------------------------------------------------------------------------*/
  351. { incl/datsetsort.i }
  352. END PROCEDURE.
  353. /* _UIB-CODE-BLOCK-END */
  354. &ANALYZE-RESUME
  355. {&DB-REQUIRED-END}
  356. /* ************************ Function Implementations ***************** */
  357. {&DB-REQUIRED-START}
  358. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION getQueryBuffer dTables _DB-REQUIRED
  359. FUNCTION getQueryBuffer RETURNS HANDLE
  360. ( /* parameter-definitions */ ) :
  361. /*------------------------------------------------------------------------------
  362. Purpose:
  363. Notes:
  364. ------------------------------------------------------------------------------*/
  365. RETURN BUFFER rowObject:HANDLE.
  366. END FUNCTION.
  367. /* _UIB-CODE-BLOCK-END */
  368. &ANALYZE-RESUME
  369. {&DB-REQUIRED-END}
  370. {&DB-REQUIRED-START}
  371. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION openQuery dTables _DB-REQUIRED
  372. FUNCTION openQuery RETURNS LOGICAL
  373. ( /* parameter-definitions */ ) :
  374. /*------------------------------------------------------------------------------
  375. Purpose: Super Override
  376. Notes:
  377. ------------------------------------------------------------------------------*/
  378. DEF VAR Felder AS CHAR NO-UNDO.
  379. DEF VAR Inhalt AS CHAR NO-UNDO.
  380. DEF VAR ix AS INT NO-UNDO.
  381. DEF VAR cFeld AS CHAR NO-UNDO.
  382. /* IF NOT fOpen THEN RETURN FALSE. */
  383. xWhere = ''.
  384. xSort = ''.
  385. xString = ''.
  386. Felder = DYNAMIC-FUNCTION('getForeignFields':U) NO-ERROR.
  387. Inhalt = DYNAMIC-FUNCTION('getForeignValues':U) NO-ERROR.
  388. /* ix = LOOKUP('Feld', Felder, ',') / 2. */
  389. /* cFeld = ENTRY (ix , Inhalt, CHR(01)). */
  390. /* xWhere = 'Aufko.Firma = ' + QUOTER(Firma) + ' AND ' */
  391. /* + 'Aufko.Auf_Sta = ' + STRING(Auf_Sta) + ' '. */
  392. /* xString = 'FOR EACH Debop ' + xSort + 'WHERE ' */
  393. /* + 'Debop.Firma = "' + Firma + '" AND ' */
  394. /* + 'Debop.Knr = ' + STRING(Knr) + ' ' */
  395. /* + 'NO-LOCK BY Debop.FakDat DESCENDING INDEXED-REPOSITION '. */
  396. { incl/datopenquery.i }
  397. IF xWhere <> '' THEN DYNAMIC-FUNCTION('setQueryWhere':U , INPUT xWhere ).
  398. IF xSort <> '' THEN DYNAMIC-FUNCTION('setQuerySort':U , INPUT xSort ).
  399. IF xString <> '' THEN DYNAMIC-FUNCTION('setQueryString':U, INPUT xString).
  400. RETURN SUPER( ).
  401. END FUNCTION.
  402. /* _UIB-CODE-BLOCK-END */
  403. &ANALYZE-RESUME
  404. {&DB-REQUIRED-END}