-
Notifications
You must be signed in to change notification settings - Fork 23
/
wImportLoad.w
813 lines (631 loc) · 26.9 KB
/
wImportLoad.w
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
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
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
&ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI
&ANALYZE-RESUME
&Scoped-define WINDOW-NAME wImportLoad
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS wImportLoad
/*------------------------------------------------------------------------
Name : wImportLoad.w
Desc : Load data file
----------------------------------------------------------------------*/
/* This .W file was created with the Progress AppBuilder. */
/*----------------------------------------------------------------------*/
CREATE WIDGET-POOL.
{ DataDigger.i }
/* Parameters Definitions --- */
DEFINE INPUT PARAMETER plReadOnlyDigger AS LOGICAL NO-UNDO.
DEFINE INPUT PARAMETER TABLE-HANDLE pihXmlTable.
DEFINE INPUT PARAMETER picDatabase AS CHARACTER NO-UNDO.
DEFINE INPUT PARAMETER picTableName AS CHARACTER NO-UNDO.
DEFINE INPUT PARAMETER TABLE FOR ttField.
DEFINE INPUT PARAMETER TABLE FOR ttColumn.
DEFINE OUTPUT PARAMETER polSuccess AS LOGICAL NO-UNDO INITIAL ?.
DEFINE OUTPUT PARAMETER porRepositionId AS ROWID NO-UNDO.
/* Local Variable Definitions --- */
{&_proparse_prolint-nowarn(varusage)}
DEFINE VARIABLE giNumRecords AS INTEGER NO-UNDO.
DEFINE VARIABLE ghXmlBuffer AS HANDLE NO-UNDO.
DEFINE VARIABLE ghXmlQuery AS HANDLE NO-UNDO.
DEFINE VARIABLE ghDataBrowse AS HANDLE NO-UNDO.
DEFINE VARIABLE giDataOddRowColor AS INTEGER NO-UNDO EXTENT 2.
DEFINE VARIABLE giDataEvenRowColor AS INTEGER NO-UNDO EXTENT 2.
DEFINE VARIABLE giDataErrorColor AS INTEGER NO-UNDO EXTENT 2.
DEFINE VARIABLE giMaxFilterHistory AS INTEGER NO-UNDO.
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
&ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
/* ******************** Preprocessor Definitions ******************** */
&Scoped-define PROCEDURE-TYPE Window
&Scoped-define DB-AWARE no
/* Name of designated FRAME-NAME and/or first browse and/or first query */
&Scoped-define FRAME-NAME frMain
/* Standard List Definitions */
&Scoped-Define ENABLED-OBJECTS btnBack btnFinish tgWriteTrigger
&Scoped-Define DISPLAYED-OBJECTS tgWriteTrigger
/* Custom List Definitions */
/* List-1,List-2,List-3,List-4,List-5,List-6 */
/* _UIB-PREPROCESSOR-BLOCK-END */
&ANALYZE-RESUME
/* *********************** Control Definitions ********************** */
/* Define the widget handle for the window */
DEFINE VAR wImportLoad AS WIDGET-HANDLE NO-UNDO.
/* Definitions of the field level widgets */
DEFINE BUTTON btnBack
LABEL "&Back"
SIZE-PIXELS 74 BY 24 TOOLTIP "cancel load data".
DEFINE BUTTON btnFinish
LABEL "&Finish"
SIZE-PIXELS 74 BY 24 TOOLTIP "load the data to the database".
DEFINE RECTANGLE rctData
EDGE-PIXELS 1 GRAPHIC-EDGE NO-FILL
SIZE-PIXELS 699 BY 455.
DEFINE VARIABLE tgWriteTrigger AS LOGICAL INITIAL yes
LABEL "Use &write trigger"
VIEW-AS TOGGLE-BOX
SIZE-PIXELS 120 BY 17 TOOLTIP "Enable write triggers or not" NO-UNDO.
/* ************************ Frame Definitions *********************** */
DEFINE FRAME frMain
btnBack AT Y 460 X 535
btnFinish AT Y 460 X 615
tgWriteTrigger AT Y 463 X 15
rctData AT Y 0 X 1
WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
SIDE-LABELS NO-UNDERLINE THREE-D
AT COL 1 ROW 1 SCROLLABLE
CANCEL-BUTTON btnBack.
/* *********************** Procedure Settings ************************ */
&ANALYZE-SUSPEND _PROCEDURE-SETTINGS
/* Settings for THIS-PROCEDURE
Type: Window
Allow: Basic,Browse,DB-Fields,Window,Query
Other Settings: COMPILE
*/
&ANALYZE-RESUME _END-PROCEDURE-SETTINGS
/* ************************* Create Window ************************** */
&ANALYZE-SUSPEND _CREATE-WINDOW
IF SESSION:DISPLAY-TYPE = "GUI":U THEN
CREATE WINDOW wImportLoad ASSIGN
HIDDEN = YES
TITLE = "Import Finalize"
HEIGHT-P = 494
WIDTH-P = 700
MAX-HEIGHT-P = 2079
MAX-WIDTH-P = 1600
VIRTUAL-HEIGHT-P = 2079
VIRTUAL-WIDTH-P = 1600
RESIZE = yes
SCROLL-BARS = no
STATUS-AREA = no
BGCOLOR = ?
FGCOLOR = ?
KEEP-FRAME-Z-ORDER = yes
THREE-D = yes
MESSAGE-AREA = no
SENSITIVE = yes.
ELSE {&WINDOW-NAME} = CURRENT-WINDOW.
/* END WINDOW DEFINITION */
&ANALYZE-RESUME
/* *********** Runtime Attributes and AppBuilder Settings *********** */
&ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
/* SETTINGS FOR WINDOW wImportLoad
NOT-VISIBLE,,RUN-PERSISTENT */
/* SETTINGS FOR FRAME frMain
NOT-VISIBLE FRAME-NAME Size-to-Fit */
ASSIGN
FRAME frMain:SCROLLABLE = FALSE
FRAME frMain:RESIZABLE = TRUE.
/* SETTINGS FOR RECTANGLE rctData IN FRAME frMain
NO-ENABLE */
ASSIGN
rctData:HIDDEN IN FRAME frMain = TRUE.
IF SESSION:DISPLAY-TYPE = "GUI":U AND VALID-HANDLE(wImportLoad)
THEN wImportLoad:HIDDEN = yes.
/* _RUN-TIME-ATTRIBUTES-END */
&ANALYZE-RESUME
/* ************************ Control Triggers ************************ */
&Scoped-define SELF-NAME wImportLoad
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL wImportLoad wImportLoad
ON END-ERROR OF wImportLoad /* Import Finalize */
OR ENDKEY OF {&WINDOW-NAME} ANYWHERE DO:
/* This case occurs when the user presses the "Esc" key.
In a persistently run window, just ignore this. If we did not, the
application would exit. */
IF THIS-PROCEDURE:PERSISTENT THEN RETURN NO-APPLY.
END.
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL wImportLoad wImportLoad
ON WINDOW-CLOSE OF wImportLoad /* Import Finalize */
OR "LEAVE" OF wImportLoad
DO:
/* This event will close the window and terminate the procedure. */
APPLY "CLOSE":U TO THIS-PROCEDURE.
RETURN NO-APPLY.
END.
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL wImportLoad wImportLoad
ON WINDOW-RESIZED OF wImportLoad /* Import Finalize */
DO:
RUN LockWindow (INPUT wImportLoad:HANDLE, INPUT YES).
DO WITH FRAME frMain:
/* Make 'em small so we don't get errors on resizing the window */
btnBack:X = 1.
btnBack:Y = 1.
btnFinish:X = 1.
btnFinish:Y = 1.
ghDataBrowse:WIDTH-PIXELS = 50.
ghDataBrowse:HEIGHT-PIXELS = 100.
tgWriteTrigger:Y = 1.
tgWriteTrigger:X = 1.
/* Set frame width */
FRAME frMain:WIDTH-PIXELS = wImportLoad:WIDTH-PIXELS NO-ERROR.
FRAME frMain:HEIGHT-PIXELS = wImportLoad:HEIGHT-PIXELS NO-ERROR.
/* Adjust the browse */
ghDataBrowse:WIDTH-PIXELS = FRAME frMain:WIDTH-PIXELS - 6.
ghDataBrowse:HEIGHT-PIXELS = FRAME frMain:HEIGHT-PIXELS - 30 - 10.
/* Set buttons + toggle for use of triggers */
tgWriteTrigger:Y = FRAME frMain:HEIGHT-PIXELS - 30.
tgWriteTrigger:X = 15.
btnFinish:X = FRAME frMain:WIDTH-PIXELS - 80.
btnFinish:Y = tgWriteTrigger:Y.
btnBack:X = btnFinish:X - btnBack:WIDTH-PIXELS - 10.
btnBack:Y = tgWriteTrigger:Y.
/* Save settings */
RUN saveWindowPos(wImportLoad:HANDLE,"DataDigger:ImportLoad").
END.
RUN showScrollBars(FRAME frMain:HANDLE, NO, NO).
RUN LockWindow (INPUT wImportLoad:HANDLE, INPUT NO).
END.
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
&Scoped-define SELF-NAME btnBack
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL btnBack wImportLoad
ON CHOOSE OF btnBack IN FRAME frMain /* Back */
OR ENDKEY OF {&WINDOW-NAME} ANYWHERE
DO:
polSuccess = FALSE.
APPLY "CLOSE" TO THIS-PROCEDURE.
END.
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
&Scoped-define SELF-NAME btnFinish
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL btnFinish wImportLoad
ON CHOOSE OF btnFinish IN FRAME frMain /* Finish */
OR 'GO' OF FRAME frMain
DO:
RUN btnFinishChoose (OUTPUT polSuccess).
IF NOT polSuccess THEN
RETURN NO-APPLY.
ELSE
APPLY 'close' TO THIS-PROCEDURE.
END.
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
&Scoped-define SELF-NAME tgWriteTrigger
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL tgWriteTrigger wImportLoad
ON VALUE-CHANGED OF tgWriteTrigger IN FRAME frMain /* Use write trigger */
DO:
setRegistry("DataDigger","EnableWriteTriggers", STRING(SELF:CHECKED) ).
END.
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
&UNDEFINE SELF-NAME
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK wImportLoad
/* *************************** Main Block *************************** */
/* Set CURRENT-WINDOW: this will parent dialog-boxes and frames. */
ASSIGN CURRENT-WINDOW = {&WINDOW-NAME}
THIS-PROCEDURE:CURRENT-WINDOW = {&WINDOW-NAME}.
/* The CLOSE event can be used from inside or outside the procedure to */
/* terminate it. */
ON CLOSE OF THIS-PROCEDURE
DO:
/* Save settings */
RUN saveWindowPos(wImportLoad:HANDLE,"DataDigger:ImportLoad").
IF VALID-HANDLE(ghXmlQuery) THEN
DO:
ghXmlQuery:QUERY-CLOSE().
DELETE OBJECT ghXmlQuery.
END.
RUN disable_UI.
END.
/* Best default for GUI applications is... */
PAUSE 0 BEFORE-HIDE.
/* Now enable the interface and wait for the exit condition. */
/* (NOTE: handle ERROR and END-KEY so cleanup code will always fire. */
MAIN-BLOCK:
DO ON ERROR UNDO MAIN-BLOCK, LEAVE MAIN-BLOCK
ON END-KEY UNDO MAIN-BLOCK, LEAVE MAIN-BLOCK:
/* Get fonts */
FRAME {&FRAME-NAME}:FONT = getFont('Default').
RUN enable_UI.
RUN initializeObject.
IF NOT THIS-PROCEDURE:PERSISTENT THEN
WAIT-FOR CLOSE OF THIS-PROCEDURE.
END.
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
/* ********************** Internal Procedures *********************** */
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE btnFinishChoose wImportLoad
PROCEDURE btnFinishChoose :
/* Proceed to procedure that actually loads the data
*/
DEFINE OUTPUT PARAMETER plSuccess AS LOGICAL NO-UNDO.
DEFINE VARIABLE lErrorsFound AS LOGICAL NO-UNDO.
RUN loadData(INPUT TRUE, OUTPUT lErrorsFound).
IF lErrorsFound THEN
DO:
MESSAGE "Your data was loaded, but with errors" VIEW-AS ALERT-BOX INFORMATION BUTTONS OK.
ASSIGN plSuccess = NO.
END.
ELSE
DO:
ASSIGN plSuccess = YES.
END.
END PROCEDURE. /* btnFinishChoose */
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE createBrowse wImportLoad
PROCEDURE createBrowse :
/* Create the browse
*/
DEFINE VARIABLE iColumnWidth AS INTEGER NO-UNDO.
DEFINE VARIABLE iMinWidth AS INTEGER NO-UNDO.
DEFINE VARIABLE cMyFormat AS CHARACTER NO-UNDO.
DEFINE VARIABLE iPos AS INTEGER NO-UNDO.
DEFINE VARIABLE cColumnName AS CHARACTER NO-UNDO.
DEFINE BUFFER bColumn FOR ttColumn.
DEFINE BUFFER bField FOR ttField.
/* Start building */
CREATE BROWSE ghDataBrowse
ASSIGN
NAME = "brData"
FRAME = FRAME frMain:HANDLE
FONT = getFont('Default')
QUERY = ghXmlQuery
MULTIPLE = TRUE
X = 3
Y = 3
WIDTH-PIXELS = 50 /* will be handled by resize routine */
HEIGHT-PIXELS = 100 /* will be handled by resize routine */
ROW-MARKERS = TRUE
SEPARATORS = TRUE
READ-ONLY = FALSE
SENSITIVE = TRUE
VISIBLE = FALSE
NO-VALIDATE = TRUE
COLUMN-RESIZABLE = TRUE
COLUMN-SCROLLING = TRUE /* scroll with whole columns at a time */
TRIGGERS:
ON "ROW-DISPLAY" PERSISTENT RUN dataRowDisplay IN THIS-PROCEDURE (ghXmlBuffer).
END TRIGGERS.
/* Add columns to the browse */
addColumnLoop:
FOR EACH bField BY bField.iOrder:
FOR EACH bColumn
WHERE bColumn.cTableCacheId = bField.cTableCacheId
AND bColumn.cFieldName = bField.cFieldName
AND bColumn.lShow = TRUE
BY bColumn.iColumnNr:
cMyFormat = getRegistry( SUBSTITUTE("DB:&1",bColumn.cDatabase)
, SUBSTITUTE("&1.&2:format",bColumn.cTableName, bColumn.cFieldName)
).
IF cMyFormat = ? THEN cMyFormat = bField.cFormat.
/* Autocorrect 2-digit years in date fields */
IF bField.cDataType = "DATE"
AND cMyFormat MATCHES "99.99.99" THEN cMyFormat = cMyFormat + "99".
/* Protect against "value could not be displayed using..." errors. */
IF ( bField.cDataType = "DECIMAL"
OR bField.cDataType = "RECID"
OR bField.cDataType BEGINS "INT") /* Use BEGINS to cover integer / int64 and extents of both */
AND NOT cMyFormat BEGINS "HH:MM" /* Skip time fields */ THEN
DO:
/* Add minus sign if needed */
IF INDEX(cMyFormat,"-") = 0 AND INDEX(cMyFormat,"+") = 0 THEN
cMyFormat = "-" + cMyFormat.
/* Add extra digit placeholders */
addDigits:
DO iPos = 1 TO LENGTH(cMyFormat):
IF LOOKUP(SUBSTRING(cMyFormat,iPos,1),">,Z,9") > 0 THEN
DO:
IF iPos = 1 THEN
cMyFormat = ">>>>>>>>>>>>>>>" + cMyFormat.
ELSE
cMyFormat = SUBSTRING(cMyFormat,1,iPos - 1) + ">>>>>>>>>>>>>>>" + SUBSTRING(cMyFormat,iPos).
LEAVE addDigits.
END.
END.
END.
/* Add a calculated column for integers with time format */
cColumnName = SUBSTITUTE("&1.&2", bColumn.cTableName, bColumn.cFullName).
IF ( bField.cDataType = "DECIMAL"
OR bField.cDataType BEGINS "INT") /* use BEGINS to cover integer / int64 and extents of both */
AND bField.cFormat BEGINS "HH:MM" THEN
DO:
bColumn.hColumn = ghDataBrowse:ADD-CALC-COLUMN("character","x(8)","", cColumnName ) NO-ERROR.
END.
ELSE
DO:
bColumn.hColumn = ghDataBrowse:ADD-LIKE-COLUMN(cColumnName).
END.
bColumn.hColumn:LABEL = bColumn.cFullName.
bColumn.hColumn:RESIZABLE = TRUE.
END.
END.
/* Show the browse */
ghDataBrowse:VISIBLE = TRUE.
adjustColumnWidth:
FOR EACH bColumn WHERE VALID-HANDLE(bColumn.hColumn):
/* Get last defined width from registry. Might have been set by user */
iColumnWidth = INTEGER(getRegistry(SUBSTITUTE("DB:&1",bColumn.cDatabase), SUBSTITUTE("&1.&2:width", bColumn.cTableName, bColumn.cFullname)) ) NO-ERROR.
/* If it's not set, calculate a width. Make sure it is not wider than 300px */
IF iColumnWidth = ? THEN iColumnWidth = MINIMUM(300, bColumn.hColumn:WIDTH-PIXELS).
/* Make sure the column is at least as wide as its name */
iMinWidth = FONT-TABLE:GET-TEXT-WIDTH-PIXELS(bColumn.cFullname,getFont("default")).
/* For the combo-filters, reserve some extra space for the arrow down */
/* And if the filter is of type COMBO, reserve some extra space for the arrow down */
IF giMaxFilterHistory > 0 THEN iMinWidth = iMinWidth + 21.
IF iColumnWidth < iMinWidth THEN iColumnWidth = iMinWidth.
bColumn.hColumn:WIDTH-PIXELS = iColumnWidth.
END.
END PROCEDURE.
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE dataRowDisplay wImportLoad
PROCEDURE dataRowDisplay :
/* Set the background color to another color to get an odd/even coloring of the rows.
*/
DEFINE INPUT PARAMETER phBrowseBuffer AS HANDLE NO-UNDO.
DEFINE BUFFER bColumn FOR ttColumn.
DEFINE BUFFER bField FOR ttField.
#Column:
FOR EACH bColumn, bField WHERE bField.cFieldName = bColumn.cFieldName:
IF NOT VALID-HANDLE(bColumn.hColumn) THEN NEXT #Column.
/* Alternate FG and BGcolor */
IF phBrowseBuffer:QUERY:CURRENT-RESULT-ROW MODULO 2 = 1 THEN
ASSIGN
bColumn.hColumn:FGCOLOR = giDataOddRowColor[1]
bColumn.hColumn:BGCOLOR = giDataOddRowColor[2].
ELSE
ASSIGN
bColumn.hColumn:FGCOLOR = giDataEvenRowColor[1]
bColumn.hColumn:BGCOLOR = giDataEvenRowColor[2].
IF bField.cFormat BEGINS "HH:MM" THEN
DO:
/* Try to format in time format */
bColumn.hColumn:SCREEN-VALUE = STRING(INTEGER(phBrowseBuffer:BUFFER-FIELD(bColumn.cFieldName):BUFFER-VALUE(bColumn.iExtent)), bField.cFormat) NO-ERROR.
/* If you type a crappy time format like HH:MAM:SS just ignore it */
IF ERROR-STATUS:ERROR THEN
bColumn.hColumn:SCREEN-VALUE = STRING(phBrowseBuffer:BUFFER-FIELD(bColumn.cFieldName):BUFFER-VALUE(bColumn.iExtent)).
END.
END.
END PROCEDURE. /* dataRowDisplay */
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI wImportLoad _DEFAULT-DISABLE
PROCEDURE disable_UI :
/*------------------------------------------------------------------------------
Purpose: DISABLE the User Interface
Parameters: <none>
Notes: Here we clean-up the user-interface by deleting
dynamic widgets we have created and/or hide
frames. This procedure is usually called when
we are ready to "clean-up" after running.
------------------------------------------------------------------------------*/
/* Delete the WINDOW we created */
IF SESSION:DISPLAY-TYPE = "GUI":U AND VALID-HANDLE(wImportLoad)
THEN DELETE WIDGET wImportLoad.
IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
END PROCEDURE.
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI wImportLoad _DEFAULT-ENABLE
PROCEDURE enable_UI :
/*------------------------------------------------------------------------------
Purpose: ENABLE the User Interface
Parameters: <none>
Notes: Here we display/view/enable the widgets in the
user-interface. In addition, OPEN all queries
associated with each FRAME and BROWSE.
These statements here are based on the "Other
Settings" section of the widget Property Sheets.
------------------------------------------------------------------------------*/
DISPLAY tgWriteTrigger
WITH FRAME frMain IN WINDOW wImportLoad.
ENABLE btnBack btnFinish tgWriteTrigger
WITH FRAME frMain IN WINDOW wImportLoad.
{&OPEN-BROWSERS-IN-QUERY-frMain}
END PROCEDURE.
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE hideNonExistingFields wImportLoad
PROCEDURE hideNonExistingFields :
/* Hide non-existing fields.
*/
DEFINE INPUT PARAMETER phBuffer AS HANDLE NO-UNDO.
DEFINE BUFFER bfField FOR ttField.
DEFINE BUFFER bfColumn FOR ttColumn.
/* Go thru the tt one by one and check whether the field
* is in the XML buffer. If not, hide the field from the user
*/
#Column:
FOR EACH bfField, EACH bfColumn WHERE bfColumn.cFieldName = bfField.cFieldName:
IF LOOKUP(bfField.cDataType, 'clob,blob,raw') > 0
OR LOOKUP(bfField.cFieldName, 'RECID,ROWID') > 0 THEN
DO:
bfColumn.lShow = FALSE.
bfColumn.hFilter = ?.
NEXT #Column.
END.
/* Save handle to the buffer in the tt */
bfColumn.hFilter = phBuffer:BUFFER-FIELD(bfColumn.cFieldName):HANDLE NO-ERROR.
bfColumn.lShow = VALID-HANDLE(bfColumn.hFilter).
END.
END PROCEDURE. /* hideNonExistingFields */
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject wImportLoad
PROCEDURE initializeObject :
/* Setup
*/
DEFINE VARIABLE cSetting AS CHARACTER NO-UNDO.
VIEW wImportLoad.
/* Get fonts */
FRAME {&FRAME-NAME}:FONT = getFont('Default').
/* Colors for odd/even data rows */
giDataOddRowColor[1] = getColor("DataRow:odd:fg" ).
giDataOddRowColor[2] = getColor("DataRow:odd:bg" ).
giDataEvenRowColor[1] = getColor("DataRow:even:fg").
giDataEvenRowColor[2] = getColor("DataRow:even:bg").
giDataErrorColor[1] = getColor("QueryError:even:fg"). /* default: yellow */
giDataErrorColor[2] = getColor("QueryError:even:fg"). /* default: red */
IF giDataErrorColor[1] = ? THEN giDataErrorColor[1] = 14.
IF giDataErrorColor[2] = ? THEN giDataErrorColor[2] = 12.
IF getRegistry("DataDigger:Colors","DataRow:UseSystem") = "YES" THEN
ASSIGN
giDataOddRowColor[1] = 1
giDataOddRowColor[2] = 24
giDataEvenRowColor[1] = 1
giDataEvenRowColor[2] = 15.
/* Maximum number OF history ON data filters */
giMaxFilterHistory = INTEGER(getRegistry("DataDigger", "MaxFilterHistory")).
IF giMaxFilterHistory = ? THEN giMaxFilterHistory = 10.
DO WITH FRAME {&FRAME-NAME}:
/* Use triggers or not? */
cSetting = getRegistry("DataDigger","EnableWriteTriggers").
IF cSetting = ? THEN cSetting = "yes".
tgWriteTrigger:CHECKED = LOGICAL(cSetting).
/* Window position and size */
/* Set title of the window */
wImportLoad:TITLE = SUBSTITUTE('Import &1.&2', picDatabase, picTableName).
/* Set minimum size of the window */
wImportLoad:MIN-WIDTH-PIXELS = 400.
wImportLoad:MIN-HEIGHT-PIXELS = 200.
/* to avoid scrollbars on the frame */
FRAME {&FRAME-NAME}:SCROLLABLE = FALSE.
/* Open query on provided xml data */
CREATE QUERY ghXmlQuery.
ghXmlBuffer = pihXmlTable:DEFAULT-BUFFER-HANDLE.
/* Set all fields to 'hidden' in the tt that are not in the buffer */
RUN hideNonExistingFields(ghXmlBuffer).
ghXmlQuery:ADD-BUFFER(ghXmlBuffer).
ghXmlQuery:QUERY-PREPARE(SUBSTITUTE("PRESELECT EACH &1",ghXmlBuffer:NAME)).
ghXmlQuery:QUERY-OPEN().
ghXmlQuery:GET-FIRST().
giNumRecords = ghXmlQuery:NUM-RESULTS.
END.
/* Create the browse */
RUN createBrowse.
/* Set window back to last known pos */
RUN restoreWindowPos(wImportLoad:HANDLE, "DataDigger:ImportLoad").
/* In read-only mode, disable FINISH button */
IF plReadOnlyDigger THEN btnFinish:SENSITIVE = FALSE.
END PROCEDURE. /* initializeObject */
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE loadData wImportLoad
PROCEDURE loadData :
/* Write changes to database, optionally roll back
*/
DEFINE INPUT PARAMETER plKeepData AS LOGICAL NO-UNDO.
DEFINE OUTPUT PARAMETER plErrorsFound AS LOGICAL NO-UNDO.
DEFINE VARIABLE hXmlQuery AS HANDLE NO-UNDO.
DEFINE VARIABLE hXmlBuffer AS HANDLE NO-UNDO.
DEFINE VARIABLE hDbBuffer AS HANDLE NO-UNDO.
DEFINE VARIABLE iField AS INTEGER NO-UNDO.
DEFINE VARIABLE lDisableTrigger AS LOGICAL NO-UNDO.
DEFINE VARIABLE cKeyFields AS CHARACTER NO-UNDO.
DEFINE VARIABLE cQuery AS CHARACTER NO-UNDO.
DEFINE VARIABLE lOk AS LOGICAL NO-UNDO.
/* Disable Triggers? */
lDisableTrigger = tgWriteTrigger:SCREEN-VALUE IN FRAME {&FRAME-NAME} = "no".
/* Prohibit editing of VST records */
IF picTableName BEGINS "_" THEN
DO:
RUN showHelp("CannotEditVst", "").
APPLY "close" TO THIS-PROCEDURE.
plErrorsFound = TRUE.
RETURN.
END.
/* Show that we're busy */
PROCESS EVENTS.
SESSION:SET-WAIT-STATE("general").
TransBlock:
DO TRANSACTION:
/* Get list of all Primary Unique index fields
* If the primary index is not unique, just give a list of unique fields
* If there are no unique fields, we need a list of all fields
*/
cKeyFields = getIndexFields(picDatabase, picTableName, "P,U").
IF cKeyFields = "" THEN cKeyFields = getIndexFields(picDatabase, picTableName, "U").
IF cKeyFields = "" THEN cKeyFields = getIndexFields(picDatabase, picTableName, "").
/* Create buffer on db table */
CREATE BUFFER hDbBuffer FOR TABLE SUBSTITUTE('&1.&2', picDatabase, picTableName) NO-ERROR.
/* Disable triggers if needed */
IF lDisableTrigger THEN
DO:
hDbBuffer:DISABLE-LOAD-TRIGGERS(FALSE).
hDbBuffer:DISABLE-DUMP-TRIGGERS( ).
END.
/* Open query on provided xml data */
CREATE QUERY hXmlQuery.
hXmlBuffer = pihXmlTable:DEFAULT-BUFFER-HANDLE.
hXmlQuery:ADD-BUFFER(hXmlBuffer).
hXmlQuery:QUERY-PREPARE(SUBSTITUTE("PRESELECT EACH &1",hXmlBuffer:NAME)).
hXmlQuery:QUERY-OPEN().
/* Walk through all records of the query */
XmlLoop:
REPEAT WHILE hXmlQuery:GET-NEXT():
/* See if there is a record in the database with the same unique key */
cQuery = "".
DO iField = 1 TO NUM-ENTRIES(cKeyFields):
cQuery = SUBSTITUTE("&1 &2 &3.&4.&5 = &6"
, cQuery
, (IF iField = 1 THEN "WHERE" ELSE "AND")
, picDatabase
, picTableName
, ENTRY(iField,cKeyFields)
, QUOTER(hXmlBuffer:BUFFER-FIELD(ENTRY(iField,cKeyFields)):BUFFER-VALUE)
).
END.
/* Find in database */
hDbBuffer:FIND-UNIQUE(cQuery, EXCLUSIVE-LOCK) NO-ERROR.
/* If nothing found, then the record from the tt is a new one */
IF NOT hDbBuffer:AVAILABLE THEN
DO:
hDbBuffer:BUFFER-CREATE() NO-ERROR.
IF ERROR-STATUS:ERROR THEN NEXT XmlLoop.
/* Save backup file when not a testrun */
IF plKeepData THEN
DO:
RUN dumpRecord(INPUT "Create", INPUT hDbBuffer, OUTPUT lOk).
IF NOT lOk THEN UNDO XmlLoop, NEXT XmlLoop.
END.
END.
/* Save backup file when this is not a testrun */
IF plKeepData AND NOT hDbBuffer:NEW THEN
DO:
RUN dumpRecord(INPUT "Update", INPUT hDbBuffer, OUTPUT lOk).
IF NOT lOk THEN UNDO XmlLoop, NEXT XmlLoop.
END.
/* Try to copy the data from the TT to the DB */
hDbBuffer:BUFFER-COPY(hXmlBuffer) NO-ERROR.
IF ERROR-STATUS:ERROR THEN
DO:
MESSAGE "Copy to database failed :(" VIEW-AS ALERT-BOX INFORMATION.
NEXT XmlLoop.
END.
/* Save rowid of first loaded record so DD can reposition to that */
IF porRepositionId = ? THEN porRepositionId = hDbBuffer:ROWID.
/* Let it go ... */
hXmlBuffer:BUFFER-RELEASE().
END. /* XmlLoop */
hXmlQuery:QUERY-CLOSE().
DELETE OBJECT hXmlQuery.
DELETE OBJECT hDbBuffer.
IF NOT plKeepData THEN UNDO TransBlock, LEAVE TransBlock.
lOk = TRUE.
END. /* transaction */
/* Unfreeze the window */
SESSION:SET-WAIT-STATE("").
END PROCEDURE. /* loadData */
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME