d-debop.w 35 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869
  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. &SCOPED-DEFINE Tabelle Debop
  30. &SCOPED-DEFINE TabWhere USE-INDEX Debop-k1 ~
  31. WHERE {&Tabelle}.Firma = tRowObject.Firma ~
  32. AND {&Tabelle}.Knr = tRowObject.Knr ~
  33. AND {&Tabelle}.Faknr = tRowObject.Faknr
  34. { incl/datdefinition.i }
  35. /* _UIB-CODE-BLOCK-END */
  36. &ANALYZE-RESUME
  37. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  38. /* ******************** Preprocessor Definitions ******************** */
  39. &Global-define DATA-LOGIC-PROCEDURE .p
  40. &Scoped-define PROCEDURE-TYPE SmartDataObject
  41. &Scoped-define DB-AWARE yes
  42. &Scoped-define ADM-SUPPORTED-LINKS Data-Source,Data-Target,Navigation-Target,Update-Target,Commit-Target,Filter-Target
  43. /* Db-Required definitions. */
  44. &IF DEFINED(DB-REQUIRED) = 0 &THEN
  45. &GLOBAL-DEFINE DB-REQUIRED TRUE
  46. &ENDIF
  47. &GLOBAL-DEFINE DB-REQUIRED-START &IF {&DB-REQUIRED} &THEN
  48. &GLOBAL-DEFINE DB-REQUIRED-END &ENDIF
  49. &Scoped-define QUERY-NAME Query-Main
  50. /* Internal Tables (found by Frame, Query & Browse Queries) */
  51. &Scoped-define INTERNAL-TABLES Debop
  52. /* Definitions for QUERY Query-Main */
  53. &Scoped-Define ENABLED-FIELDS Faellig Fakbetr Fakbetr_FRW Fakdat Fakincl1 Fakincl2 Fakincl3 Fakincl4~
  54. Fakincl5 Fakincl6 Fakincl7 Fakincl8 Fakincl9 Fakincl10 Fakincl11 Fakincl12~
  55. Faknr Faktor Fakwpfl1 Fakwpfl2 Fakwpfl3 Fakwpfl4 Fakwpfl5 Fakwpfl6 Fakwpfl7~
  56. Fakwpfl8 Fakwpfl9 Fakwpfl10 Fakwpfl11 Fakwpfl12 Fakwpro1 Fakwpro2 Fakwpro3~
  57. Fakwpro4 Fakwpro5 Fakwpro6 Fakwpro7 Fakwpro8 Fakwpro9 Fakwpro10 Fakwpro11~
  58. Fakwpro12 Fakwust1 Fakwust2 Fakwust3 Fakwust4 Fakwust5 Fakwust6 Fakwust7~
  59. Fakwust8 Fakwust9 Fakwust10 Fakwust11 Fakwust12 Firma FRW Fr_Faknr Knr Kond~
  60. Konto Kte Kurs MahAnz MahDat MahStu Porto Saldo Saldo_FRW Skber Skber_FRW~
  61. Skonto Skonto_FRW Transp TrNr1 TrNr2 Verpack Vertr WustAbr WW WW_FRW~
  62. Zahbetr Zahbetr_FRW Zahdat ZahSkon1 ZahSkon2 ZahSkon3 ZahSkon4 ZahSkon5~
  63. ZahSkon6 ZahSkon7 ZahSkon8 ZahSkon9 ZahSkon10 ZahSkon11 ZahSkon12 Zahwpfl1~
  64. Zahwpfl2 Zahwpfl3 Zahwpfl4 Zahwpfl5 Zahwpfl6 Zahwpfl7 Zahwpfl8 Zahwpfl9~
  65. Zahwpfl10 Zahwpfl11 Zahwpfl12 Zahwust1 Zahwust2 Zahwust3 Zahwust4 Zahwust5~
  66. Zahwust6 Zahwust7 Zahwust8 Zahwust9 Zahwust10 Zahwust11 Zahwust12
  67. &Scoped-define ENABLED-FIELDS-IN-Debop Faellig Fakbetr Fakbetr_FRW Fakdat ~
  68. Fakincl1 Fakincl2 Fakincl3 Fakincl4 Fakincl5 Fakincl6 Fakincl7 Fakincl8 ~
  69. Fakincl9 Fakincl10 Fakincl11 Fakincl12 Faknr Faktor Fakwpfl1 Fakwpfl2 ~
  70. Fakwpfl3 Fakwpfl4 Fakwpfl5 Fakwpfl6 Fakwpfl7 Fakwpfl8 Fakwpfl9 Fakwpfl10 ~
  71. Fakwpfl11 Fakwpfl12 Fakwpro1 Fakwpro2 Fakwpro3 Fakwpro4 Fakwpro5 Fakwpro6 ~
  72. Fakwpro7 Fakwpro8 Fakwpro9 Fakwpro10 Fakwpro11 Fakwpro12 Fakwust1 Fakwust2 ~
  73. Fakwust3 Fakwust4 Fakwust5 Fakwust6 Fakwust7 Fakwust8 Fakwust9 Fakwust10 ~
  74. Fakwust11 Fakwust12 Firma FRW Fr_Faknr Knr Kond Konto Kte Kurs MahAnz ~
  75. MahDat MahStu Porto Saldo Saldo_FRW Skber Skber_FRW Skonto Skonto_FRW ~
  76. Transp TrNr1 TrNr2 Verpack Vertr WustAbr WW WW_FRW Zahbetr Zahbetr_FRW ~
  77. Zahdat ZahSkon1 ZahSkon2 ZahSkon3 ZahSkon4 ZahSkon5 ZahSkon6 ZahSkon7 ~
  78. ZahSkon8 ZahSkon9 ZahSkon10 ZahSkon11 ZahSkon12 Zahwpfl1 Zahwpfl2 Zahwpfl3 ~
  79. Zahwpfl4 Zahwpfl5 Zahwpfl6 Zahwpfl7 Zahwpfl8 Zahwpfl9 Zahwpfl10 Zahwpfl11 ~
  80. Zahwpfl12 Zahwust1 Zahwust2 Zahwust3 Zahwust4 Zahwust5 Zahwust6 Zahwust7 ~
  81. Zahwust8 Zahwust9 Zahwust10 Zahwust11 Zahwust12
  82. &Scoped-Define DATA-FIELDS Faellig Fakbetr Fakbetr_FRW Fakdat Fakincl1 Fakincl2 Fakincl3 Fakincl4~
  83. Fakincl5 Fakincl6 Fakincl7 Fakincl8 Fakincl9 Fakincl10 Fakincl11 Fakincl12~
  84. Faknr Faktor Fakwpfl1 Fakwpfl2 Fakwpfl3 Fakwpfl4 Fakwpfl5 Fakwpfl6 Fakwpfl7~
  85. Fakwpfl8 Fakwpfl9 Fakwpfl10 Fakwpfl11 Fakwpfl12 Fakwpro1 Fakwpro2 Fakwpro3~
  86. Fakwpro4 Fakwpro5 Fakwpro6 Fakwpro7 Fakwpro8 Fakwpro9 Fakwpro10 Fakwpro11~
  87. Fakwpro12 Fakwust1 Fakwust2 Fakwust3 Fakwust4 Fakwust5 Fakwust6 Fakwust7~
  88. Fakwust8 Fakwust9 Fakwust10 Fakwust11 Fakwust12 Firma FRW Fr_Faknr Knr Kond~
  89. Konto Kte Kurs MahAnz MahDat MahStu Porto Saldo Saldo_FRW Skber Skber_FRW~
  90. Skonto Skonto_FRW Transp TrNr1 TrNr2 Verpack Vertr WustAbr WW WW_FRW~
  91. Zahbetr Zahbetr_FRW Zahdat ZahSkon1 ZahSkon2 ZahSkon3 ZahSkon4 ZahSkon5~
  92. ZahSkon6 ZahSkon7 ZahSkon8 ZahSkon9 ZahSkon10 ZahSkon11 ZahSkon12 Zahwpfl1~
  93. Zahwpfl2 Zahwpfl3 Zahwpfl4 Zahwpfl5 Zahwpfl6 Zahwpfl7 Zahwpfl8 Zahwpfl9~
  94. Zahwpfl10 Zahwpfl11 Zahwpfl12 Zahwust1 Zahwust2 Zahwust3 Zahwust4 Zahwust5~
  95. Zahwust6 Zahwust7 Zahwust8 Zahwust9 Zahwust10 Zahwust11 Zahwust12
  96. &Scoped-define DATA-FIELDS-IN-Debop Faellig Fakbetr Fakbetr_FRW Fakdat ~
  97. Fakincl1 Fakincl2 Fakincl3 Fakincl4 Fakincl5 Fakincl6 Fakincl7 Fakincl8 ~
  98. Fakincl9 Fakincl10 Fakincl11 Fakincl12 Faknr Faktor Fakwpfl1 Fakwpfl2 ~
  99. Fakwpfl3 Fakwpfl4 Fakwpfl5 Fakwpfl6 Fakwpfl7 Fakwpfl8 Fakwpfl9 Fakwpfl10 ~
  100. Fakwpfl11 Fakwpfl12 Fakwpro1 Fakwpro2 Fakwpro3 Fakwpro4 Fakwpro5 Fakwpro6 ~
  101. Fakwpro7 Fakwpro8 Fakwpro9 Fakwpro10 Fakwpro11 Fakwpro12 Fakwust1 Fakwust2 ~
  102. Fakwust3 Fakwust4 Fakwust5 Fakwust6 Fakwust7 Fakwust8 Fakwust9 Fakwust10 ~
  103. Fakwust11 Fakwust12 Firma FRW Fr_Faknr Knr Kond Konto Kte Kurs MahAnz ~
  104. MahDat MahStu Porto Saldo Saldo_FRW Skber Skber_FRW Skonto Skonto_FRW ~
  105. Transp TrNr1 TrNr2 Verpack Vertr WustAbr WW WW_FRW Zahbetr Zahbetr_FRW ~
  106. Zahdat ZahSkon1 ZahSkon2 ZahSkon3 ZahSkon4 ZahSkon5 ZahSkon6 ZahSkon7 ~
  107. ZahSkon8 ZahSkon9 ZahSkon10 ZahSkon11 ZahSkon12 Zahwpfl1 Zahwpfl2 Zahwpfl3 ~
  108. Zahwpfl4 Zahwpfl5 Zahwpfl6 Zahwpfl7 Zahwpfl8 Zahwpfl9 Zahwpfl10 Zahwpfl11 ~
  109. Zahwpfl12 Zahwust1 Zahwust2 Zahwust3 Zahwust4 Zahwust5 Zahwust6 Zahwust7 ~
  110. Zahwust8 Zahwust9 Zahwust10 Zahwust11 Zahwust12
  111. &Scoped-Define MANDATORY-FIELDS Firma
  112. &Scoped-Define APPLICATION-SERVICE
  113. &Scoped-Define ASSIGN-LIST rowObject.Fakincl1 = Debop.Fakincl[1]~
  114. rowObject.Fakincl2 = Debop.Fakincl[2]~
  115. rowObject.Fakincl3 = Debop.Fakincl[3]~
  116. rowObject.Fakincl4 = Debop.Fakincl[4]~
  117. rowObject.Fakincl5 = Debop.Fakincl[5]~
  118. rowObject.Fakincl6 = Debop.Fakincl[6]~
  119. rowObject.Fakincl7 = Debop.Fakincl[7]~
  120. rowObject.Fakincl8 = Debop.Fakincl[8]~
  121. rowObject.Fakincl9 = Debop.Fakincl[9]~
  122. rowObject.Fakincl10 = Debop.Fakincl[10]~
  123. rowObject.Fakincl11 = Debop.Fakincl[11]~
  124. rowObject.Fakincl12 = Debop.Fakincl[12]~
  125. rowObject.Fakwpfl1 = Debop.Fakwpfl[1]~
  126. rowObject.Fakwpfl2 = Debop.Fakwpfl[2]~
  127. rowObject.Fakwpfl3 = Debop.Fakwpfl[3]~
  128. rowObject.Fakwpfl4 = Debop.Fakwpfl[4]~
  129. rowObject.Fakwpfl5 = Debop.Fakwpfl[5]~
  130. rowObject.Fakwpfl6 = Debop.Fakwpfl[6]~
  131. rowObject.Fakwpfl7 = Debop.Fakwpfl[7]~
  132. rowObject.Fakwpfl8 = Debop.Fakwpfl[8]~
  133. rowObject.Fakwpfl9 = Debop.Fakwpfl[9]~
  134. rowObject.Fakwpfl10 = Debop.Fakwpfl[10]~
  135. rowObject.Fakwpfl11 = Debop.Fakwpfl[11]~
  136. rowObject.Fakwpfl12 = Debop.Fakwpfl[12]~
  137. rowObject.Fakwpro1 = Debop.Fakwpro[1]~
  138. rowObject.Fakwpro2 = Debop.Fakwpro[2]~
  139. rowObject.Fakwpro3 = Debop.Fakwpro[3]~
  140. rowObject.Fakwpro4 = Debop.Fakwpro[4]~
  141. rowObject.Fakwpro5 = Debop.Fakwpro[5]~
  142. rowObject.Fakwpro6 = Debop.Fakwpro[6]~
  143. rowObject.Fakwpro7 = Debop.Fakwpro[7]~
  144. rowObject.Fakwpro8 = Debop.Fakwpro[8]~
  145. rowObject.Fakwpro9 = Debop.Fakwpro[9]~
  146. rowObject.Fakwpro10 = Debop.Fakwpro[10]~
  147. rowObject.Fakwpro11 = Debop.Fakwpro[11]~
  148. rowObject.Fakwpro12 = Debop.Fakwpro[12]~
  149. rowObject.Fakwust1 = Debop.Fakwust[1]~
  150. rowObject.Fakwust2 = Debop.Fakwust[2]~
  151. rowObject.Fakwust3 = Debop.Fakwust[3]~
  152. rowObject.Fakwust4 = Debop.Fakwust[4]~
  153. rowObject.Fakwust5 = Debop.Fakwust[5]~
  154. rowObject.Fakwust6 = Debop.Fakwust[6]~
  155. rowObject.Fakwust7 = Debop.Fakwust[7]~
  156. rowObject.Fakwust8 = Debop.Fakwust[8]~
  157. rowObject.Fakwust9 = Debop.Fakwust[9]~
  158. rowObject.Fakwust10 = Debop.Fakwust[10]~
  159. rowObject.Fakwust11 = Debop.Fakwust[11]~
  160. rowObject.Fakwust12 = Debop.Fakwust[12]~
  161. rowObject.ZahSkon1 = Debop.ZahSkon[1]~
  162. rowObject.ZahSkon2 = Debop.ZahSkon[2]~
  163. rowObject.ZahSkon3 = Debop.ZahSkon[3]~
  164. rowObject.ZahSkon4 = Debop.ZahSkon[4]~
  165. rowObject.ZahSkon5 = Debop.ZahSkon[5]~
  166. rowObject.ZahSkon6 = Debop.ZahSkon[6]~
  167. rowObject.ZahSkon7 = Debop.ZahSkon[7]~
  168. rowObject.ZahSkon8 = Debop.ZahSkon[8]~
  169. rowObject.ZahSkon9 = Debop.ZahSkon[9]~
  170. rowObject.ZahSkon10 = Debop.ZahSkon[10]~
  171. rowObject.ZahSkon11 = Debop.ZahSkon[11]~
  172. rowObject.ZahSkon12 = Debop.ZahSkon[12]~
  173. rowObject.Zahwpfl1 = Debop.Zahwpfl[1]~
  174. rowObject.Zahwpfl2 = Debop.Zahwpfl[2]~
  175. rowObject.Zahwpfl3 = Debop.Zahwpfl[3]~
  176. rowObject.Zahwpfl4 = Debop.Zahwpfl[4]~
  177. rowObject.Zahwpfl5 = Debop.Zahwpfl[5]~
  178. rowObject.Zahwpfl6 = Debop.Zahwpfl[6]~
  179. rowObject.Zahwpfl7 = Debop.Zahwpfl[7]~
  180. rowObject.Zahwpfl8 = Debop.Zahwpfl[8]~
  181. rowObject.Zahwpfl9 = Debop.Zahwpfl[9]~
  182. rowObject.Zahwpfl10 = Debop.Zahwpfl[10]~
  183. rowObject.Zahwpfl11 = Debop.Zahwpfl[11]~
  184. rowObject.Zahwpfl12 = Debop.Zahwpfl[12]~
  185. rowObject.Zahwust1 = Debop.Zahwust[1]~
  186. rowObject.Zahwust2 = Debop.Zahwust[2]~
  187. rowObject.Zahwust3 = Debop.Zahwust[3]~
  188. rowObject.Zahwust4 = Debop.Zahwust[4]~
  189. rowObject.Zahwust5 = Debop.Zahwust[5]~
  190. rowObject.Zahwust6 = Debop.Zahwust[6]~
  191. rowObject.Zahwust7 = Debop.Zahwust[7]~
  192. rowObject.Zahwust8 = Debop.Zahwust[8]~
  193. rowObject.Zahwust9 = Debop.Zahwust[9]~
  194. rowObject.Zahwust10 = Debop.Zahwust[10]~
  195. rowObject.Zahwust11 = Debop.Zahwust[11]~
  196. rowObject.Zahwust12 = Debop.Zahwust[12]
  197. &Scoped-Define DATA-FIELD-DEFS "d-debop.i"
  198. &Scoped-Define DATA-TABLE-NO-UNDO NO-UNDO
  199. &Scoped-define QUERY-STRING-Query-Main FOR EACH Debop NO-LOCK INDEXED-REPOSITION
  200. {&DB-REQUIRED-START}
  201. &Scoped-define OPEN-QUERY-Query-Main OPEN QUERY Query-Main FOR EACH Debop NO-LOCK INDEXED-REPOSITION.
  202. {&DB-REQUIRED-END}
  203. &Scoped-define TABLES-IN-QUERY-Query-Main Debop
  204. &Scoped-define FIRST-TABLE-IN-QUERY-Query-Main Debop
  205. /* Custom List Definitions */
  206. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  207. /* _UIB-PREPROCESSOR-BLOCK-END */
  208. &ANALYZE-RESUME
  209. /* ************************ Function Prototypes ********************** */
  210. {&DB-REQUIRED-START}
  211. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD getCurrentRecid dTables _DB-REQUIRED
  212. FUNCTION getCurrentRecid RETURNS RECID
  213. ( /* parameter-definitions */ ) FORWARD.
  214. /* _UIB-CODE-BLOCK-END */
  215. &ANALYZE-RESUME
  216. {&DB-REQUIRED-END}
  217. {&DB-REQUIRED-START}
  218. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD getQueryBuffer dTables _DB-REQUIRED
  219. FUNCTION getQueryBuffer RETURNS HANDLE
  220. ( /* parameter-definitions */ ) FORWARD.
  221. /* _UIB-CODE-BLOCK-END */
  222. &ANALYZE-RESUME
  223. {&DB-REQUIRED-END}
  224. {&DB-REQUIRED-START}
  225. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD openQuery dTables _DB-REQUIRED
  226. FUNCTION openQuery RETURNS LOGICAL
  227. ( /* parameter-definitions */ ) FORWARD.
  228. /* _UIB-CODE-BLOCK-END */
  229. &ANALYZE-RESUME
  230. {&DB-REQUIRED-END}
  231. /* *********************** Control Definitions ********************** */
  232. {&DB-REQUIRED-START}
  233. /* Query definitions */
  234. &ANALYZE-SUSPEND
  235. DEFINE QUERY Query-Main FOR
  236. Debop SCROLLING.
  237. &ANALYZE-RESUME
  238. {&DB-REQUIRED-END}
  239. /* ************************ Frame Definitions *********************** */
  240. /* *********************** Procedure Settings ************************ */
  241. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  242. /* Settings for THIS-PROCEDURE
  243. Type: SmartDataObject
  244. Allow: Query
  245. Frames: 0
  246. Add Fields to: Neither
  247. Other Settings: PERSISTENT-ONLY COMPILE APPSERVER DB-AWARE
  248. */
  249. /* This procedure should always be RUN PERSISTENT. Report the error, */
  250. /* then cleanup and return. */
  251. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  252. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  253. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  254. RETURN.
  255. END.
  256. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  257. /* ************************* Create Window ************************** */
  258. &ANALYZE-SUSPEND _CREATE-WINDOW
  259. /* DESIGN Window definition (used by the UIB)
  260. CREATE WINDOW dTables ASSIGN
  261. HEIGHT = 1.62
  262. WIDTH = 46.6.
  263. /* END WINDOW DEFINITION */
  264. */
  265. &ANALYZE-RESUME
  266. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB dTables
  267. /* ************************* Included-Libraries *********************** */
  268. {src/adm2/data.i}
  269. /* _UIB-CODE-BLOCK-END */
  270. &ANALYZE-RESUME
  271. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  272. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  273. /* SETTINGS FOR WINDOW dTables
  274. VISIBLE,,RUN-PERSISTENT */
  275. /* _RUN-TIME-ATTRIBUTES-END */
  276. &ANALYZE-RESUME
  277. /* Setting information for Queries and Browse Widgets fields */
  278. &ANALYZE-SUSPEND _QUERY-BLOCK QUERY Query-Main
  279. /* Query rebuild information for SmartDataObject Query-Main
  280. _TblList = "AnaDat.Debop"
  281. _Options = "NO-LOCK INDEXED-REPOSITION"
  282. _FldNameList[1] > AnaDat.Debop.Faellig
  283. "Faellig" "Faellig" ? ? "date" ? ? ? ? ? ? yes ? no 10.8 yes ?
  284. _FldNameList[2] > AnaDat.Debop.Fakbetr
  285. "Fakbetr" "Fakbetr" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  286. _FldNameList[3] > AnaDat.Debop.Fakbetr_FRW
  287. "Fakbetr_FRW" "Fakbetr_FRW" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  288. _FldNameList[4] > AnaDat.Debop.Fakdat
  289. "Fakdat" "Fakdat" ? ? "date" ? ? ? ? ? ? yes ? no 10.8 yes ?
  290. _FldNameList[5] > AnaDat.Debop.Fakincl[1]
  291. "Fakincl[1]" "Fakincl1" ? ? "logical" ? ? ? ? ? ? yes ? no 6.8 yes ?
  292. _FldNameList[6] > AnaDat.Debop.Fakincl[2]
  293. "Fakincl[2]" "Fakincl2" ? ? "logical" ? ? ? ? ? ? yes ? no 6.8 yes ?
  294. _FldNameList[7] > AnaDat.Debop.Fakincl[3]
  295. "Fakincl[3]" "Fakincl3" ? ? "logical" ? ? ? ? ? ? yes ? no 6.8 yes ?
  296. _FldNameList[8] > AnaDat.Debop.Fakincl[4]
  297. "Fakincl[4]" "Fakincl4" ? ? "logical" ? ? ? ? ? ? yes ? no 6.8 yes ?
  298. _FldNameList[9] > AnaDat.Debop.Fakincl[5]
  299. "Fakincl[5]" "Fakincl5" ? ? "logical" ? ? ? ? ? ? yes ? no 6.8 yes ?
  300. _FldNameList[10] > AnaDat.Debop.Fakincl[6]
  301. "Fakincl[6]" "Fakincl6" ? ? "logical" ? ? ? ? ? ? yes ? no 6.8 yes ?
  302. _FldNameList[11] > AnaDat.Debop.Fakincl[7]
  303. "Fakincl[7]" "Fakincl7" ? ? "logical" ? ? ? ? ? ? yes ? no 6.8 yes ?
  304. _FldNameList[12] > AnaDat.Debop.Fakincl[8]
  305. "Fakincl[8]" "Fakincl8" ? ? "logical" ? ? ? ? ? ? yes ? no 6.8 yes ?
  306. _FldNameList[13] > AnaDat.Debop.Fakincl[9]
  307. "Fakincl[9]" "Fakincl9" ? ? "logical" ? ? ? ? ? ? yes ? no 6.8 yes ?
  308. _FldNameList[14] > AnaDat.Debop.Fakincl[10]
  309. "Fakincl[10]" "Fakincl10" ? ? "logical" ? ? ? ? ? ? yes ? no 6.8 yes ?
  310. _FldNameList[15] > AnaDat.Debop.Fakincl[11]
  311. "Fakincl[11]" "Fakincl11" ? ? "logical" ? ? ? ? ? ? yes ? no 6.8 yes ?
  312. _FldNameList[16] > AnaDat.Debop.Fakincl[12]
  313. "Fakincl[12]" "Fakincl12" ? ? "logical" ? ? ? ? ? ? yes ? no 6.8 yes ?
  314. _FldNameList[17] > AnaDat.Debop.Faknr
  315. "Faknr" "Faknr" ? ? "integer" ? ? ? ? ? ? yes ? no 8.4 yes ?
  316. _FldNameList[18] > AnaDat.Debop.Faktor
  317. "Faktor" "Faktor" ? ? "integer" ? ? ? ? ? ? yes ? no 6 yes ?
  318. _FldNameList[19] > AnaDat.Debop.Fakwpfl[1]
  319. "Fakwpfl[1]" "Fakwpfl1" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  320. _FldNameList[20] > AnaDat.Debop.Fakwpfl[2]
  321. "Fakwpfl[2]" "Fakwpfl2" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  322. _FldNameList[21] > AnaDat.Debop.Fakwpfl[3]
  323. "Fakwpfl[3]" "Fakwpfl3" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  324. _FldNameList[22] > AnaDat.Debop.Fakwpfl[4]
  325. "Fakwpfl[4]" "Fakwpfl4" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  326. _FldNameList[23] > AnaDat.Debop.Fakwpfl[5]
  327. "Fakwpfl[5]" "Fakwpfl5" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  328. _FldNameList[24] > AnaDat.Debop.Fakwpfl[6]
  329. "Fakwpfl[6]" "Fakwpfl6" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  330. _FldNameList[25] > AnaDat.Debop.Fakwpfl[7]
  331. "Fakwpfl[7]" "Fakwpfl7" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  332. _FldNameList[26] > AnaDat.Debop.Fakwpfl[8]
  333. "Fakwpfl[8]" "Fakwpfl8" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  334. _FldNameList[27] > AnaDat.Debop.Fakwpfl[9]
  335. "Fakwpfl[9]" "Fakwpfl9" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  336. _FldNameList[28] > AnaDat.Debop.Fakwpfl[10]
  337. "Fakwpfl[10]" "Fakwpfl10" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  338. _FldNameList[29] > AnaDat.Debop.Fakwpfl[11]
  339. "Fakwpfl[11]" "Fakwpfl11" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  340. _FldNameList[30] > AnaDat.Debop.Fakwpfl[12]
  341. "Fakwpfl[12]" "Fakwpfl12" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  342. _FldNameList[31] > AnaDat.Debop.Fakwpro[1]
  343. "Fakwpro[1]" "Fakwpro1" ? ? "decimal" ? ? ? ? ? ? yes ? no 8.2 yes ?
  344. _FldNameList[32] > AnaDat.Debop.Fakwpro[2]
  345. "Fakwpro[2]" "Fakwpro2" ? ? "decimal" ? ? ? ? ? ? yes ? no 8.2 yes ?
  346. _FldNameList[33] > AnaDat.Debop.Fakwpro[3]
  347. "Fakwpro[3]" "Fakwpro3" ? ? "decimal" ? ? ? ? ? ? yes ? no 8.2 yes ?
  348. _FldNameList[34] > AnaDat.Debop.Fakwpro[4]
  349. "Fakwpro[4]" "Fakwpro4" ? ? "decimal" ? ? ? ? ? ? yes ? no 8.2 yes ?
  350. _FldNameList[35] > AnaDat.Debop.Fakwpro[5]
  351. "Fakwpro[5]" "Fakwpro5" ? ? "decimal" ? ? ? ? ? ? yes ? no 8.2 yes ?
  352. _FldNameList[36] > AnaDat.Debop.Fakwpro[6]
  353. "Fakwpro[6]" "Fakwpro6" ? ? "decimal" ? ? ? ? ? ? yes ? no 8.2 yes ?
  354. _FldNameList[37] > AnaDat.Debop.Fakwpro[7]
  355. "Fakwpro[7]" "Fakwpro7" ? ? "decimal" ? ? ? ? ? ? yes ? no 8.2 yes ?
  356. _FldNameList[38] > AnaDat.Debop.Fakwpro[8]
  357. "Fakwpro[8]" "Fakwpro8" ? ? "decimal" ? ? ? ? ? ? yes ? no 8.2 yes ?
  358. _FldNameList[39] > AnaDat.Debop.Fakwpro[9]
  359. "Fakwpro[9]" "Fakwpro9" ? ? "decimal" ? ? ? ? ? ? yes ? no 8.2 yes ?
  360. _FldNameList[40] > AnaDat.Debop.Fakwpro[10]
  361. "Fakwpro[10]" "Fakwpro10" ? ? "decimal" ? ? ? ? ? ? yes ? no 8.2 yes ?
  362. _FldNameList[41] > AnaDat.Debop.Fakwpro[11]
  363. "Fakwpro[11]" "Fakwpro11" ? ? "decimal" ? ? ? ? ? ? yes ? no 8.2 yes ?
  364. _FldNameList[42] > AnaDat.Debop.Fakwpro[12]
  365. "Fakwpro[12]" "Fakwpro12" ? ? "decimal" ? ? ? ? ? ? yes ? no 8.2 yes ?
  366. _FldNameList[43] > AnaDat.Debop.Fakwust[1]
  367. "Fakwust[1]" "Fakwust1" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  368. _FldNameList[44] > AnaDat.Debop.Fakwust[2]
  369. "Fakwust[2]" "Fakwust2" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  370. _FldNameList[45] > AnaDat.Debop.Fakwust[3]
  371. "Fakwust[3]" "Fakwust3" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  372. _FldNameList[46] > AnaDat.Debop.Fakwust[4]
  373. "Fakwust[4]" "Fakwust4" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  374. _FldNameList[47] > AnaDat.Debop.Fakwust[5]
  375. "Fakwust[5]" "Fakwust5" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  376. _FldNameList[48] > AnaDat.Debop.Fakwust[6]
  377. "Fakwust[6]" "Fakwust6" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  378. _FldNameList[49] > AnaDat.Debop.Fakwust[7]
  379. "Fakwust[7]" "Fakwust7" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  380. _FldNameList[50] > AnaDat.Debop.Fakwust[8]
  381. "Fakwust[8]" "Fakwust8" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  382. _FldNameList[51] > AnaDat.Debop.Fakwust[9]
  383. "Fakwust[9]" "Fakwust9" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  384. _FldNameList[52] > AnaDat.Debop.Fakwust[10]
  385. "Fakwust[10]" "Fakwust10" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  386. _FldNameList[53] > AnaDat.Debop.Fakwust[11]
  387. "Fakwust[11]" "Fakwust11" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  388. _FldNameList[54] > AnaDat.Debop.Fakwust[12]
  389. "Fakwust[12]" "Fakwust12" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  390. _FldNameList[55] > AnaDat.Debop.Firma
  391. "Firma" "Firma" ? ? "character" ? ? ? ? ? ? yes ? yes 8 yes ?
  392. _FldNameList[56] > AnaDat.Debop.FRW
  393. "FRW" "FRW" ? ? "character" ? ? ? ? ? ? yes ? no 5 yes ?
  394. _FldNameList[57] > AnaDat.Debop.Fr_Faknr
  395. "Fr_Faknr" "Fr_Faknr" ? ? "character" ? ? ? ? ? ? yes ? no 20 yes ?
  396. _FldNameList[58] > AnaDat.Debop.Knr
  397. "Knr" "Knr" ? ? "integer" ? ? ? ? ? ? yes ? no 7.2 yes ?
  398. _FldNameList[59] > AnaDat.Debop.Kond
  399. "Kond" "Kond" ? ? "integer" ? ? ? ? ? ? yes ? no 5 yes ?
  400. _FldNameList[60] > AnaDat.Debop.Konto
  401. "Konto" "Konto" ? ? "character" ? ? ? ? ? ? yes ? no 12 yes ?
  402. _FldNameList[61] > AnaDat.Debop.Kte
  403. "Kte" "Kte" ? ? "character" ? ? ? ? ? ? yes ? no 4 yes ?
  404. _FldNameList[62] > AnaDat.Debop.Kurs
  405. "Kurs" "Kurs" ? ? "decimal" ? ? ? ? ? ? yes ? no 9.6 yes ?
  406. _FldNameList[63] > AnaDat.Debop.MahAnz
  407. "MahAnz" "MahAnz" ? ? "integer" ? ? ? ? ? ? yes ? no 7.8 yes ?
  408. _FldNameList[64] > AnaDat.Debop.MahDat
  409. "MahDat" "MahDat" ? ? "date" ? ? ? ? ? ? yes ? no 10.8 yes ?
  410. _FldNameList[65] > AnaDat.Debop.MahStu
  411. "MahStu" "MahStu" ? ? "integer" ? ? ? ? ? ? yes ? no 7.4 yes ?
  412. _FldNameList[66] > AnaDat.Debop.Porto
  413. "Porto" "Porto" ? ? "decimal" ? ? ? ? ? ? yes ? no 7.8 yes ?
  414. _FldNameList[67] > AnaDat.Debop.Saldo
  415. "Saldo" "Saldo" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  416. _FldNameList[68] > AnaDat.Debop.Saldo_FRW
  417. "Saldo_FRW" "Saldo_FRW" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  418. _FldNameList[69] > AnaDat.Debop.Skber
  419. "Skber" "Skber" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  420. _FldNameList[70] > AnaDat.Debop.Skber_FRW
  421. "Skber_FRW" "Skber_FRW" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  422. _FldNameList[71] > AnaDat.Debop.Skonto
  423. "Skonto" "Skonto" ? ? "decimal" ? ? ? ? ? ? yes ? no 10.4 yes ?
  424. _FldNameList[72] > AnaDat.Debop.Skonto_FRW
  425. "Skonto_FRW" "Skonto_FRW" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  426. _FldNameList[73] > AnaDat.Debop.Transp
  427. "Transp" "Transp" ? ? "decimal" ? ? ? ? ? ? yes ? no 7.8 yes ?
  428. _FldNameList[74] > AnaDat.Debop.TrNr1
  429. "TrNr1" "TrNr1" ? ? "integer" ? ? ? ? ? ? yes ? no 9.6 yes ?
  430. _FldNameList[75] > AnaDat.Debop.TrNr2
  431. "TrNr2" "TrNr2" ? ? "integer" ? ? ? ? ? ? yes ? no 7.2 yes ?
  432. _FldNameList[76] > AnaDat.Debop.Verpack
  433. "Verpack" "Verpack" ? ? "decimal" ? ? ? ? ? ? yes ? no 8 yes ?
  434. _FldNameList[77] > AnaDat.Debop.Vertr
  435. "Vertr" "Vertr" ? ? "integer" ? ? ? ? ? ? yes ? no 4.4 yes ?
  436. _FldNameList[78] > AnaDat.Debop.WustAbr
  437. "WustAbr" "WustAbr" ? ? "logical" ? ? ? ? ? ? yes ? no 8.2 yes ?
  438. _FldNameList[79] > AnaDat.Debop.WW
  439. "WW" "WW" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  440. _FldNameList[80] > AnaDat.Debop.WW_FRW
  441. "WW_FRW" "WW_FRW" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  442. _FldNameList[81] > AnaDat.Debop.Zahbetr
  443. "Zahbetr" "Zahbetr" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  444. _FldNameList[82] > AnaDat.Debop.Zahbetr_FRW
  445. "Zahbetr_FRW" "Zahbetr_FRW" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  446. _FldNameList[83] > AnaDat.Debop.Zahdat
  447. "Zahdat" "Zahdat" ? ? "date" ? ? ? ? ? ? yes ? no 10.8 yes ?
  448. _FldNameList[84] > AnaDat.Debop.ZahSkon[1]
  449. "ZahSkon[1]" "ZahSkon1" ? ? "decimal" ? ? ? ? ? ? yes ? no 10.4 yes ?
  450. _FldNameList[85] > AnaDat.Debop.ZahSkon[2]
  451. "ZahSkon[2]" "ZahSkon2" ? ? "decimal" ? ? ? ? ? ? yes ? no 10.4 yes ?
  452. _FldNameList[86] > AnaDat.Debop.ZahSkon[3]
  453. "ZahSkon[3]" "ZahSkon3" ? ? "decimal" ? ? ? ? ? ? yes ? no 10.4 yes ?
  454. _FldNameList[87] > AnaDat.Debop.ZahSkon[4]
  455. "ZahSkon[4]" "ZahSkon4" ? ? "decimal" ? ? ? ? ? ? yes ? no 10.4 yes ?
  456. _FldNameList[88] > AnaDat.Debop.ZahSkon[5]
  457. "ZahSkon[5]" "ZahSkon5" ? ? "decimal" ? ? ? ? ? ? yes ? no 10.4 yes ?
  458. _FldNameList[89] > AnaDat.Debop.ZahSkon[6]
  459. "ZahSkon[6]" "ZahSkon6" ? ? "decimal" ? ? ? ? ? ? yes ? no 10.4 yes ?
  460. _FldNameList[90] > AnaDat.Debop.ZahSkon[7]
  461. "ZahSkon[7]" "ZahSkon7" ? ? "decimal" ? ? ? ? ? ? yes ? no 10.4 yes ?
  462. _FldNameList[91] > AnaDat.Debop.ZahSkon[8]
  463. "ZahSkon[8]" "ZahSkon8" ? ? "decimal" ? ? ? ? ? ? yes ? no 10.4 yes ?
  464. _FldNameList[92] > AnaDat.Debop.ZahSkon[9]
  465. "ZahSkon[9]" "ZahSkon9" ? ? "decimal" ? ? ? ? ? ? yes ? no 10.4 yes ?
  466. _FldNameList[93] > AnaDat.Debop.ZahSkon[10]
  467. "ZahSkon[10]" "ZahSkon10" ? ? "decimal" ? ? ? ? ? ? yes ? no 10.4 yes ?
  468. _FldNameList[94] > AnaDat.Debop.ZahSkon[11]
  469. "ZahSkon[11]" "ZahSkon11" ? ? "decimal" ? ? ? ? ? ? yes ? no 10.4 yes ?
  470. _FldNameList[95] > AnaDat.Debop.ZahSkon[12]
  471. "ZahSkon[12]" "ZahSkon12" ? ? "decimal" ? ? ? ? ? ? yes ? no 10.4 yes ?
  472. _FldNameList[96] > AnaDat.Debop.Zahwpfl[1]
  473. "Zahwpfl[1]" "Zahwpfl1" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  474. _FldNameList[97] > AnaDat.Debop.Zahwpfl[2]
  475. "Zahwpfl[2]" "Zahwpfl2" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  476. _FldNameList[98] > AnaDat.Debop.Zahwpfl[3]
  477. "Zahwpfl[3]" "Zahwpfl3" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  478. _FldNameList[99] > AnaDat.Debop.Zahwpfl[4]
  479. "Zahwpfl[4]" "Zahwpfl4" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  480. _FldNameList[100] > AnaDat.Debop.Zahwpfl[5]
  481. "Zahwpfl[5]" "Zahwpfl5" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  482. _FldNameList[101] > AnaDat.Debop.Zahwpfl[6]
  483. "Zahwpfl[6]" "Zahwpfl6" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  484. _FldNameList[102] > AnaDat.Debop.Zahwpfl[7]
  485. "Zahwpfl[7]" "Zahwpfl7" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  486. _FldNameList[103] > AnaDat.Debop.Zahwpfl[8]
  487. "Zahwpfl[8]" "Zahwpfl8" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  488. _FldNameList[104] > AnaDat.Debop.Zahwpfl[9]
  489. "Zahwpfl[9]" "Zahwpfl9" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  490. _FldNameList[105] > AnaDat.Debop.Zahwpfl[10]
  491. "Zahwpfl[10]" "Zahwpfl10" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  492. _FldNameList[106] > AnaDat.Debop.Zahwpfl[11]
  493. "Zahwpfl[11]" "Zahwpfl11" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  494. _FldNameList[107] > AnaDat.Debop.Zahwpfl[12]
  495. "Zahwpfl[12]" "Zahwpfl12" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  496. _FldNameList[108] > AnaDat.Debop.Zahwust[1]
  497. "Zahwust[1]" "Zahwust1" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  498. _FldNameList[109] > AnaDat.Debop.Zahwust[2]
  499. "Zahwust[2]" "Zahwust2" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  500. _FldNameList[110] > AnaDat.Debop.Zahwust[3]
  501. "Zahwust[3]" "Zahwust3" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  502. _FldNameList[111] > AnaDat.Debop.Zahwust[4]
  503. "Zahwust[4]" "Zahwust4" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  504. _FldNameList[112] > AnaDat.Debop.Zahwust[5]
  505. "Zahwust[5]" "Zahwust5" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  506. _FldNameList[113] > AnaDat.Debop.Zahwust[6]
  507. "Zahwust[6]" "Zahwust6" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  508. _FldNameList[114] > AnaDat.Debop.Zahwust[7]
  509. "Zahwust[7]" "Zahwust7" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  510. _FldNameList[115] > AnaDat.Debop.Zahwust[8]
  511. "Zahwust[8]" "Zahwust8" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  512. _FldNameList[116] > AnaDat.Debop.Zahwust[9]
  513. "Zahwust[9]" "Zahwust9" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  514. _FldNameList[117] > AnaDat.Debop.Zahwust[10]
  515. "Zahwust[10]" "Zahwust10" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  516. _FldNameList[118] > AnaDat.Debop.Zahwust[11]
  517. "Zahwust[11]" "Zahwust11" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  518. _FldNameList[119] > AnaDat.Debop.Zahwust[12]
  519. "Zahwust[12]" "Zahwust12" ? ? "decimal" ? ? ? ? ? ? yes ? no 14 yes ?
  520. _Design-Parent is WINDOW dTables @ ( 1.14 , 2.6 )
  521. */ /* QUERY Query-Main */
  522. &ANALYZE-RESUME
  523. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK dTables
  524. /* *************************** Main Block *************************** */
  525. { incl/datmainblock.i }
  526. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  527. RUN initializeObject.
  528. &ENDIF
  529. /* _UIB-CODE-BLOCK-END */
  530. &ANALYZE-RESUME
  531. /* ********************** Internal Procedures *********************** */
  532. {&DB-REQUIRED-START}
  533. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE dataAvailable dTables _DB-REQUIRED
  534. PROCEDURE dataAvailable :
  535. /*------------------------------------------------------------------------------
  536. Purpose: Super Override
  537. Parameters:
  538. Notes:
  539. ------------------------------------------------------------------------------*/
  540. { incl/datdataavailable.i }
  541. END PROCEDURE.
  542. /* _UIB-CODE-BLOCK-END */
  543. &ANALYZE-RESUME
  544. {&DB-REQUIRED-END}
  545. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI dTables _DEFAULT-DISABLE
  546. PROCEDURE disable_UI :
  547. /*------------------------------------------------------------------------------
  548. Purpose: DISABLE the User Interface
  549. Parameters: <none>
  550. Notes: Here we clean-up the user-interface by deleting
  551. dynamic widgets we have created and/or hide
  552. frames. This procedure is usually called when
  553. we are ready to "clean-up" after running.
  554. ------------------------------------------------------------------------------*/
  555. /* Hide all frames. */
  556. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  557. END PROCEDURE.
  558. /* _UIB-CODE-BLOCK-END */
  559. &ANALYZE-RESUME
  560. {&DB-REQUIRED-START}
  561. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE INAKTIVIEREN dTables _DB-REQUIRED
  562. PROCEDURE INAKTIVIEREN :
  563. /*------------------------------------------------------------------------------
  564. Purpose:
  565. Parameters: <none>
  566. Notes:
  567. ------------------------------------------------------------------------------*/
  568. { incl/datinaktivieren.i }
  569. END PROCEDURE.
  570. /* _UIB-CODE-BLOCK-END */
  571. &ANALYZE-RESUME
  572. {&DB-REQUIRED-END}
  573. {&DB-REQUIRED-START}
  574. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject dTables _DB-REQUIRED
  575. PROCEDURE initializeObject :
  576. /*------------------------------------------------------------------------------
  577. Purpose: Super Override
  578. Parameters:
  579. Notes:
  580. ------------------------------------------------------------------------------*/
  581. { incl/datinitialize.i }
  582. END PROCEDURE.
  583. /* _UIB-CODE-BLOCK-END */
  584. &ANALYZE-RESUME
  585. {&DB-REQUIRED-END}
  586. {&DB-REQUIRED-START}
  587. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE REAKTIVIEREN dTables _DB-REQUIRED
  588. PROCEDURE REAKTIVIEREN :
  589. /*------------------------------------------------------------------------------
  590. Purpose:
  591. Parameters: <none>
  592. Notes:
  593. ------------------------------------------------------------------------------*/
  594. { incl/datreaktivieren.i }
  595. END PROCEDURE.
  596. /* _UIB-CODE-BLOCK-END */
  597. &ANALYZE-RESUME
  598. {&DB-REQUIRED-END}
  599. {&DB-REQUIRED-START}
  600. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE REPOS_TABELLE dTables _DB-REQUIRED
  601. PROCEDURE REPOS_TABELLE :
  602. /*------------------------------------------------------------------------------
  603. Purpose:
  604. Parameters: <none>
  605. Notes:
  606. ------------------------------------------------------------------------------*/
  607. { incl/datrepos.i }
  608. END PROCEDURE.
  609. /* _UIB-CODE-BLOCK-END */
  610. &ANALYZE-RESUME
  611. {&DB-REQUIRED-END}
  612. {&DB-REQUIRED-START}
  613. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SET_FILTER dTables _DB-REQUIRED
  614. PROCEDURE SET_FILTER :
  615. /*------------------------------------------------------------------------------
  616. Purpose:
  617. Parameters: <none>
  618. Notes:
  619. ------------------------------------------------------------------------------*/
  620. { incl/datsetfilter.i }
  621. END PROCEDURE.
  622. /* _UIB-CODE-BLOCK-END */
  623. &ANALYZE-RESUME
  624. {&DB-REQUIRED-END}
  625. {&DB-REQUIRED-START}
  626. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SET_OPENFLAG dTables _DB-REQUIRED
  627. PROCEDURE SET_OPENFLAG :
  628. /*------------------------------------------------------------------------------
  629. Purpose:
  630. Parameters: <none>
  631. Notes:
  632. ------------------------------------------------------------------------------*/
  633. { incl/datsetopenflag.i }
  634. END PROCEDURE.
  635. /* _UIB-CODE-BLOCK-END */
  636. &ANALYZE-RESUME
  637. {&DB-REQUIRED-END}
  638. {&DB-REQUIRED-START}
  639. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SET_SORT dTables _DB-REQUIRED
  640. PROCEDURE SET_SORT :
  641. /*------------------------------------------------------------------------------
  642. Purpose:
  643. Parameters: <none>
  644. Notes:
  645. ------------------------------------------------------------------------------*/
  646. { incl/datsetsort.i }
  647. END PROCEDURE.
  648. /* _UIB-CODE-BLOCK-END */
  649. &ANALYZE-RESUME
  650. {&DB-REQUIRED-END}
  651. /* ************************ Function Implementations ***************** */
  652. {&DB-REQUIRED-START}
  653. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION getCurrentRecid dTables _DB-REQUIRED
  654. FUNCTION getCurrentRecid RETURNS RECID
  655. ( /* parameter-definitions */ ) :
  656. /*------------------------------------------------------------------------------
  657. Purpose:
  658. Notes:
  659. ------------------------------------------------------------------------------*/
  660. { incl/datgetcurrentrecid.i }
  661. END FUNCTION.
  662. /* _UIB-CODE-BLOCK-END */
  663. &ANALYZE-RESUME
  664. {&DB-REQUIRED-END}
  665. {&DB-REQUIRED-START}
  666. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION getQueryBuffer dTables _DB-REQUIRED
  667. FUNCTION getQueryBuffer RETURNS HANDLE
  668. ( /* parameter-definitions */ ) :
  669. /*------------------------------------------------------------------------------
  670. Purpose:
  671. Notes:
  672. ------------------------------------------------------------------------------*/
  673. RETURN BUFFER rowObject:HANDLE.
  674. END FUNCTION.
  675. /* _UIB-CODE-BLOCK-END */
  676. &ANALYZE-RESUME
  677. {&DB-REQUIRED-END}
  678. {&DB-REQUIRED-START}
  679. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION openQuery dTables _DB-REQUIRED
  680. FUNCTION openQuery RETURNS LOGICAL
  681. ( /* parameter-definitions */ ) :
  682. /*------------------------------------------------------------------------------
  683. Purpose: Super Override
  684. Notes:
  685. ------------------------------------------------------------------------------*/
  686. DEF VAR Felder AS CHAR NO-UNDO.
  687. DEF VAR Inhalt AS CHAR NO-UNDO.
  688. DEF VAR ix AS INT NO-UNDO.
  689. DEF VAR cFeld AS CHAR NO-UNDO.
  690. /* IF NOT fOpen THEN RETURN FALSE. */
  691. xWhere = ''.
  692. xSort = ''.
  693. xString = ''.
  694. Felder = DYNAMIC-FUNCTION('getForeignFields':U) NO-ERROR.
  695. Inhalt = DYNAMIC-FUNCTION('getForeignValues':U) NO-ERROR.
  696. /* ix = LOOKUP('Feld', Felder, ',') / 2. */
  697. /* cFeld = ENTRY (ix , Inhalt, CHR(01)). */
  698. /* xWhere = 'Aufko.Firma = ' + QUOTER(Firma) + ' AND ' */
  699. /* + 'Aufko.Auf_Sta = ' + STRING(Auf_Sta) + ' '. */
  700. /* xString = 'FOR EACH Debop ' + xSort + 'WHERE ' */
  701. /* + 'Debop.Firma = "' + Firma + '" AND ' */
  702. /* + 'Debop.Knr = ' + STRING(Knr) + ' ' */
  703. /* + 'NO-LOCK BY Debop.FakDat DESCENDING INDEXED-REPOSITION '. */
  704. { incl/datopenquery.i }
  705. IF xWhere <> '' THEN DYNAMIC-FUNCTION('setQueryWhere':U , INPUT xWhere ).
  706. IF xSort <> '' THEN DYNAMIC-FUNCTION('setQuerySort':U , INPUT xSort ).
  707. IF xString <> '' THEN DYNAMIC-FUNCTION('setQueryString':U, INPUT xString).
  708. RETURN SUPER( ).
  709. END FUNCTION.
  710. /* _UIB-CODE-BLOCK-END */
  711. &ANALYZE-RESUME
  712. {&DB-REQUIRED-END}