1 |
object Form1: TForm1
|
2 |
Left = 420
|
3 |
Height = 619
|
4 |
Top = 241
|
5 |
Width = 854
|
6 |
Caption = 'SQL Parser'
|
7 |
ClientHeight = 619
|
8 |
ClientWidth = 854
|
9 |
DefaultMonitor = dmPrimary
|
10 |
Position = poScreenCenter
|
11 |
LCLVersion = '1.8.0.4'
|
12 |
object Label1: TLabel
|
13 |
Left = 14
|
14 |
Height = 14
|
15 |
Top = 24
|
16 |
Width = 74
|
17 |
Caption = 'Original SQL'
|
18 |
ParentColor = False
|
19 |
end
|
20 |
object OriginalSQL: TMemo
|
21 |
Left = 16
|
22 |
Height = 160
|
23 |
Top = 43
|
24 |
Width = 400
|
25 |
ScrollBars = ssAutoVertical
|
26 |
TabOrder = 0
|
27 |
end
|
28 |
object Label2: TLabel
|
29 |
Left = 16
|
30 |
Height = 14
|
31 |
Top = 208
|
32 |
Width = 126
|
33 |
Caption = 'Add to Where Clause'
|
34 |
ParentColor = False
|
35 |
end
|
36 |
object WhereCondition: TEdit
|
37 |
Left = 17
|
38 |
Height = 24
|
39 |
Top = 224
|
40 |
Width = 400
|
41 |
TabOrder = 1
|
42 |
end
|
43 |
object WhereConditionType: TRadioGroup
|
44 |
Left = 17
|
45 |
Height = 56
|
46 |
Top = 264
|
47 |
Width = 399
|
48 |
AutoFill = True
|
49 |
ChildSizing.LeftRightSpacing = 6
|
50 |
ChildSizing.EnlargeHorizontal = crsHomogenousChildResize
|
51 |
ChildSizing.EnlargeVertical = crsHomogenousChildResize
|
52 |
ChildSizing.ShrinkHorizontal = crsScaleChilds
|
53 |
ChildSizing.ShrinkVertical = crsScaleChilds
|
54 |
ChildSizing.Layout = cclLeftToRightThenTopToBottom
|
55 |
ChildSizing.ControlsPerLine = 1
|
56 |
ClientHeight = 54
|
57 |
ClientWidth = 397
|
58 |
ItemIndex = 0
|
59 |
Items.Strings = (
|
60 |
'AND with Existing Condition'
|
61 |
'OR with Existing Condition'
|
62 |
)
|
63 |
TabOrder = 2
|
64 |
end
|
65 |
object Button1: TButton
|
66 |
Left = 262
|
67 |
Height = 30
|
68 |
Top = 568
|
69 |
Width = 152
|
70 |
Caption = 'Generate Updated SQL'
|
71 |
OnClick = Button1Click
|
72 |
TabOrder = 3
|
73 |
end
|
74 |
object Label3: TLabel
|
75 |
Left = 440
|
76 |
Height = 14
|
77 |
Top = 24
|
78 |
Width = 91
|
79 |
Caption = 'Generated SQL'
|
80 |
ParentColor = False
|
81 |
end
|
82 |
object GeneratedSQL: TMemo
|
83 |
Left = 440
|
84 |
Height = 557
|
85 |
Top = 43
|
86 |
Width = 400
|
87 |
Anchors = [akTop, akLeft, akRight, akBottom]
|
88 |
ScrollBars = ssAutoVertical
|
89 |
TabOrder = 4
|
90 |
end
|
91 |
object WhereAllUnions: TCheckBox
|
92 |
Left = 24
|
93 |
Height = 22
|
94 |
Top = 328
|
95 |
Width = 257
|
96 |
Caption = 'Apply to each Union in SQL Statement'
|
97 |
TabOrder = 5
|
98 |
end
|
99 |
object Label4: TLabel
|
100 |
Left = 14
|
101 |
Height = 14
|
102 |
Top = 360
|
103 |
Width = 129
|
104 |
Caption = 'Add to Having Clause'
|
105 |
ParentColor = False
|
106 |
end
|
107 |
object HavingCondition: TEdit
|
108 |
Left = 15
|
109 |
Height = 24
|
110 |
Top = 376
|
111 |
Width = 400
|
112 |
TabOrder = 6
|
113 |
end
|
114 |
object HavingConditionType: TRadioGroup
|
115 |
Left = 15
|
116 |
Height = 56
|
117 |
Top = 416
|
118 |
Width = 399
|
119 |
AutoFill = True
|
120 |
ChildSizing.LeftRightSpacing = 6
|
121 |
ChildSizing.EnlargeHorizontal = crsHomogenousChildResize
|
122 |
ChildSizing.EnlargeVertical = crsHomogenousChildResize
|
123 |
ChildSizing.ShrinkHorizontal = crsScaleChilds
|
124 |
ChildSizing.ShrinkVertical = crsScaleChilds
|
125 |
ChildSizing.Layout = cclLeftToRightThenTopToBottom
|
126 |
ChildSizing.ControlsPerLine = 1
|
127 |
ClientHeight = 54
|
128 |
ClientWidth = 397
|
129 |
ItemIndex = 0
|
130 |
Items.Strings = (
|
131 |
'AND with Existing Condition'
|
132 |
'OR with Existing Condition'
|
133 |
)
|
134 |
TabOrder = 7
|
135 |
end
|
136 |
object HavingAllUnions: TCheckBox
|
137 |
Left = 22
|
138 |
Height = 22
|
139 |
Top = 480
|
140 |
Width = 257
|
141 |
Caption = 'Apply to each Union in SQL Statement'
|
142 |
TabOrder = 8
|
143 |
end
|
144 |
object Label5: TLabel
|
145 |
Left = 15
|
146 |
Height = 14
|
147 |
Top = 520
|
148 |
Width = 178
|
149 |
Caption = 'Replacement Order By Clause'
|
150 |
ParentColor = False
|
151 |
end
|
152 |
object OrderBy: TEdit
|
153 |
Left = 16
|
154 |
Height = 24
|
155 |
Top = 536
|
156 |
Width = 398
|
157 |
TabOrder = 9
|
158 |
end
|
159 |
end
|