scrap/dbcleardown.w

   1
   2 ON DELETE OF accttran OVERRIDE DO: END.
   3 FOR each accttran:
   4   delete accttran.
   5 END.
   6
   7
   8 ON DELETE OF document OVERRIDE DO: END.
   9 FOR each document:
  10   delete document.
  11 END.
  12
  13 ON DELETE OF accountbalance OVERRIDE DO: END.
  14 FOR each accountbalance:
  15   delete accountbalance.
  16 END.
  17
  18 ON DELETE OF voucher OVERRIDE DO: END.
  19 FOR each voucher:
  20   delete voucher.
  21 END.
  22
  23 ON DELETE OF voucherline OVERRIDE DO: END.
  24 FOR each voucherline:
  25   delete voucherline.
  26 END.
  27
  28 ON DELETE OF invoice OVERRIDE DO: END.
  29 FOR each invoice:
  30   delete invoice.
  31 END.
  32
  33 ON DELETE OF invoiceline OVERRIDE DO: END.
  34 FOR each invoiceline:
  35   delete invoiceline.
  36 END.
  37
  38 /* ON DELETE OF tenant OVERRIDE DO: END.   */
  39 /* FOR each tenant:                        */
  40 /*   delete tenant.                        */
  41 /* END.                                    */
  42 /*                                         */
  43 /* ON DELETE OF creditor OVERRIDE DO: END. */
  44 /* FOR each creditor:                      */
  45 /*   delete creditor.                      */
  46 /* END.                                    */
  47
  48 /*
  49 ON DELETE OF note OVERRIDE DO: END.
  50 FOR each note:
  51   delete note.
  52 END.
  53  */
  54
  55 ON DELETE OF cheque OVERRIDE DO: END.
  56 FOR each cheque:
  57   delete cheque.
  58 END.
  59
  60 /* ON DELETE OF contact OVERRIDE DO: END.      */
  61 /* FOR each contact:                           */
  62 /*   delete contact.                           */
  63 /* END.                                        */
  64 /*                                             */
  65 /* ON DELETE OF person OVERRIDE DO: END.       */
  66 /* FOR each person:                            */
  67 /*   delete person.                            */
  68 /* END.                                        */
  69 /*                                             */
  70 /* ON DELETE OF postaldetail OVERRIDE DO: END. */
  71 /* FOR each postaldetail:                      */
  72 /*   delete postaldetail.                      */
  73 /* END.                                        */
  74 /*                                             */
  75 /* ON DELETE OF phonedetail OVERRIDE DO: END.  */
  76 /* FOR each phonedetail:                       */
  77 /*   delete phonedetail.                       */
  78 /* END.                                        */
  79
  80 ON DELETE OF accountsummary OVERRIDE DO: END.
  81 FOR each accountsummary:
  82   delete accountsummary.
  83 END.
  84
  85 ON DELETE OF closinggroup OVERRIDE DO: END.
  86 FOR each closinggroup:
  87   delete closinggroup.
  88 END.
  89
  90 ON DELETE OF periodicdetail OVERRIDE DO: END.
  91 FOR each periodicdetail:
  92   delete periodicdetail.
  93 END.
  94
  95 /* ON DELETE OF approver OVERRIDE DO: END. */
  96 /* FOR each approver:                      */
  97 /*   delete approver.                      */
  98 /* END.                                    */
  99 /*                                         */
 100
 101 ON DELETE OF invoiceline OVERRIDE DO: END.
 102 FOR each invoiceline:
 103   delete invoiceline.
 104 END.
 105
 106 /* ON DELETE OF bankaccount OVERRIDE DO: END. */
 107 /* FOR each bankaccount:                      */
 108 /*   delete bankaccount.                      */
 109 /* END.                                       */
 110
 111 /* ON DELETE OF bankimportexception OVERRIDE DO: END. */
 112 /* FOR each bankimportexception:                      */
 113 /*   delete bankimportexception.                      */
 114 /* END.                                               */
 115
 116 ON DELETE OF BATCH OVERRIDE DO: END.
 117 FOR each batch:
 118   delete batch.
 119 END.
 120
 121 /* ON DELETE OF company OVERRIDE DO: END.      */
 122 /* FOR each company:                           */
 123 /*   delete company.                           */
 124 /* END.                                        */
 125 /*                                             */
 126 /* ON DELETE OF contract OVERRIDE DO: END.     */
 127 /* FOR each contract:                          */
 128 /*   delete contract.                          */
 129 /* END.                                        */
 130 /*                                             */
 131 /* ON DELETE OF directorship OVERRIDE DO: END. */
 132 /* FOR each directorship:                      */
 133 /*   delete directorship.                      */
 134 /* END.                                        */
 135 /*                                             */
 136 /* ON DELETE OF guarantor OVERRIDE DO: END.    */
 137 /* FOR each guarantor:                         */
 138 /*   delete guarantor.                         */
 139 /* END.                                        */
 140
 141 ON DELETE OF leasehistory OVERRIDE DO: END.
 142 FOR each leasehistory:
 143   delete leasehistory.
 144 END.
 145
 146 ON DELETE OF newaccttrans OVERRIDE DO: END.
 147 FOR each newaccttrans:
 148   delete newaccttrans.
 149 END.
 150
 151 ON DELETE OF newdocument OVERRIDE DO: END.
 152 FOR each newdocument:
 153   delete newdocument.
 154 END.
 155
 156 ON DELETE OF newbatch OVERRIDE DO: END.
 157 FOR each newbatch:
 158   delete newbatch.
 159 END.
 160
 161 ON DELETE OF order OVERRIDE DO: END.
 162 FOR each order:
 163   delete order.
 164 END.
 165
 166 /* ON DELETE OF outgoingdescription OVERRIDE DO: END. */
 167 /* FOR each outgoingdescription:                      */
 168 /*   delete outgoingdescription.                      */
 169 /* END.                                               */
 170 /*                                                    */
 171 /* ON DELETE OF outgoingsbasis OVERRIDE DO: END.      */
 172 /* FOR each outgoingsbasis:                           */
 173 /*   delete outgoingsbasis.                           */
 174 /* END.                                               */
 175 /*                                                    */
 176
 177 ON DELETE OF project OVERRIDE DO: END.
 178 FOR each project:
 179   delete project.
 180 END.
 181
 182 ON DELETE OF projectbudget OVERRIDE DO: END.
 183 FOR each projectbudget:
 184   delete projectbudget.
 185 END.
 186
 187 /* ON DELETE OF property OVERRIDE DO: END.          */
 188 /* FOR each property:                               */
 189 /*   delete property.                               */
 190 /* END.                                             */
 191 /*                                                  */
 192 /* ON DELETE OF propertyoutgoing OVERRIDE DO: END.  */
 193 /* FOR each propertyoutgoing:                       */
 194 /*   delete propertyoutgoing.                       */
 195 /* END.                                             */
 196 /*                                                  */
 197 /* ON DELETE OF propertytitle OVERRIDE DO: END.     */
 198 /* FOR each propertytitle:                          */
 199 /*   delete propertytitle.                          */
 200 /* END.                                             */
 201 /*                                                  */
 202 /* ON DELETE OF propertyview OVERRIDE DO: END.      */
 203 /* FOR each propertyview:                           */
 204 /*   delete propertyview.                           */
 205 /* END.                                             */
 206 /*                                                  */
 207 /* ON DELETE OF propforecast OVERRIDE DO: END.      */
 208 /* FOR each propforecast:                           */
 209 /*   delete propforecast.                           */
 210 /* END.                                             */
 211 /*                                                  */
 212 /* ON DELETE OF region OVERRIDE DO: END.            */
 213 /* FOR each region:                                 */
 214 /*   delete region.                                 */
 215 /* END.                                             */
 216 /*                                                  */
 217 /* ON DELETE OF rentreview OVERRIDE DO: END.        */
 218 /* FOR each rentreview:                             */
 219 /*   delete rentreview.                             */
 220 /* END.                                             */
 221 /*                                                  */
 222 /* ON DELETE OF rentalspace OVERRIDE DO: END.       */
 223 /* FOR each rentalspace:                            */
 224 /*   delete rentalspace.                            */
 225 /* END.                                             */
 226 /*                                                  */
 227 /* ON DELETE OF rentspacehistory OVERRIDE DO: END.  */
 228 /* FOR each rentspacehistory:                       */
 229 /*   delete rentspacehistory.                       */
 230 /* END.                                             */
 231 /*                                   */
 232 /* ON DELETE OF rp OVERRIDE DO: END. */
 233 /*  FOR each rp:                     */
 234 /*    delete rp.                     */
 235 /*  END.                             */
 236 /*                                   */
 237 /* ON DELETE OF scenario OVERRIDE DO: END.          */
 238 /* FOR each scenario:                               */
 239 /*   delete scenario.                               */
 240 /* END.                                             */
 241 /*                                                  */
 242 /* ON DELETE OF scenarioparameter OVERRIDE DO: END. */
 243 /* FOR each scenarioparameter:                      */
 244 /*   delete scenarioparameter.                      */
 245 /* END.                                             */
 246 /*                                                  */
 247 /* ON DELETE OF shareholder OVERRIDE DO: END.       */
 248 /* FOR each shareholder:                            */
 249 /*   delete shareholder.                            */
 250 /* END.                                             */
 251 /*                                                  */
 252 /* ON DELETE OF streetfrontage OVERRIDE DO: END.    */
 253 /* FOR each streetfrontage:                         */
 254 /*   delete streetfrontage.                         */
 255 /* END.                                             */
 256 /*                                                  */
 257 /* ON DELETE OF sublease OVERRIDE DO: END.          */
 258 /* FOR each sublease:                               */
 259 /*   delete sublease.                               */
 260 /* END.                                             */
 261 /*                                                  */
 262 /* ON DELETE OF supplymeter OVERRIDE DO: END.       */
 263 /* FOR each supplymeter:                            */
 264 /*   delete supplymeter.                            */
 265 /* END.                                             */
 266 /*                                                  */
 267 /* ON DELETE OF tenancylease OVERRIDE DO: END.      */
 268 /* FOR each tenancylease:                           */
 269 /*   delete tenancylease.                           */
 270 /* END.                                             */
 271 /*                                                  */
 272 /* ON DELETE OF tenancyoutgoing OVERRIDE DO: END.   */
 273 /* FOR each tenancyoutgoing:                        */
 274 /*   delete tenancyoutgoing.                        */
 275 /* END.                                             */
 276 /*                                                  */
 277 /* ON DELETE OF valuation OVERRIDE DO: END.         */
 278 /* FOR each valuation:                              */
 279 /*   delete valuation.                              */
 280 /* END.                                             */
 281
 282 ON DELETE OF variation OVERRIDE DO: END.
 283 FOR each variation:
 284   delete variation.
 285 END.
 286
 287 ON DELETE OF variationflow OVERRIDE DO: END.
 288 FOR each variationflow:
 289   delete variationflow.
 290 END.
 291
 292 /* ON DELETE OF persondetail OVERRIDE DO: END. */
 293 /* FOR each persondetail:                           */
 294 /*   delete persondetail.                           */
 295 /* END.                                             */
 296
 297 ON DELETE OF audittrail OVERRIDE DO: END.
 298 FOR each audittrail:
 299   delete audittrail.
 300 END.
 301
 302
 303
 304
 305
 306
 307
 308
 309
 310
 311
 312
 313
 314
 315
 316
 317
 318
 319
 320
 321
 322
 323
 324
 325
 326
 327
 328
 329
 330
 331
 332
 333
 334
 335
 336
 337