1 |
tony |
5 |
object IBUpdateSQLEditorForm: TIBUpdateSQLEditorForm |
2 |
tony |
80 |
Left = 442 |
3 |
tony |
5 |
Height = 410 |
4 |
tony |
80 |
Top = 421 |
5 |
tony |
5 |
Width = 662 |
6 |
|
|
ActiveControl = PageControl |
7 |
|
|
BorderIcons = [biSystemMenu] |
8 |
|
|
BorderStyle = bsDialog |
9 |
|
|
Caption = 'UpdateSQL Editor' |
10 |
|
|
ClientHeight = 410 |
11 |
|
|
ClientWidth = 662 |
12 |
|
|
OnClose = FormClose |
13 |
|
|
OnShow = FormShow |
14 |
tony |
67 |
Position = poScreenCenter |
15 |
tony |
80 |
LCLVersion = '1.8.1.0' |
16 |
tony |
5 |
object PageControl: TPageControl |
17 |
tony |
80 |
Left = 8 |
18 |
tony |
5 |
Height = 352 |
19 |
|
|
Top = 8 |
20 |
|
|
Width = 641 |
21 |
tony |
105 |
ActivePage = FieldsPage |
22 |
tony |
5 |
Anchors = [akTop, akLeft, akRight, akBottom] |
23 |
tony |
105 |
TabIndex = 0 |
24 |
tony |
5 |
TabOrder = 0 |
25 |
|
|
object FieldsPage: TTabSheet |
26 |
|
|
Caption = 'Options' |
27 |
tony |
67 |
ClientHeight = 320 |
28 |
tony |
21 |
ClientWidth = 635 |
29 |
tony |
5 |
object GroupBox1: TGroupBox |
30 |
|
|
Left = 8 |
31 |
tony |
67 |
Height = 315 |
32 |
tony |
5 |
Top = 4 |
33 |
tony |
21 |
Width = 617 |
34 |
tony |
5 |
Anchors = [akTop, akLeft, akRight, akBottom] |
35 |
|
|
Caption = ' SQL Generation ' |
36 |
tony |
67 |
ClientHeight = 300 |
37 |
tony |
21 |
ClientWidth = 615 |
38 |
tony |
5 |
TabOrder = 0 |
39 |
|
|
object Label1: TLabel |
40 |
tony |
80 |
Left = 12 |
41 |
tony |
67 |
Height = 14 |
42 |
tony |
80 |
Top = 18 |
43 |
tony |
19 |
Width = 73 |
44 |
tony |
5 |
Caption = 'Table &Name:' |
45 |
|
|
ParentColor = False |
46 |
|
|
end |
47 |
|
|
object Label3: TLabel |
48 |
tony |
80 |
Left = 288 |
49 |
tony |
67 |
Height = 14 |
50 |
tony |
80 |
Top = 16 |
51 |
tony |
19 |
Width = 62 |
52 |
tony |
5 |
Caption = '&Key Fields:' |
53 |
|
|
ParentColor = False |
54 |
|
|
end |
55 |
|
|
object Label4: TLabel |
56 |
tony |
80 |
Left = 458 |
57 |
tony |
67 |
Height = 14 |
58 |
tony |
7 |
Top = 18 |
59 |
tony |
105 |
Width = 110 |
60 |
|
|
Caption = 'Updateable &Fields:' |
61 |
tony |
5 |
ParentColor = False |
62 |
|
|
end |
63 |
tony |
80 |
object GenerateButton: TButton |
64 |
tony |
5 |
Left = 9 |
65 |
|
|
Height = 25 |
66 |
|
|
Top = 83 |
67 |
|
|
Width = 168 |
68 |
|
|
Caption = '&Generate SQL' |
69 |
tony |
80 |
OnClick = GenerateButtonClick |
70 |
|
|
TabOrder = 0 |
71 |
tony |
5 |
end |
72 |
|
|
object QuoteFields: TCheckBox |
73 |
tony |
80 |
Left = 9 |
74 |
tony |
21 |
Height = 22 |
75 |
tony |
80 |
Top = 160 |
76 |
tony |
21 |
Width = 125 |
77 |
tony |
5 |
Caption = '&Quote Identifiers' |
78 |
tony |
80 |
TabOrder = 1 |
79 |
tony |
5 |
end |
80 |
tony |
7 |
object IncludePrimaryKeys: TCheckBox |
81 |
tony |
80 |
Left = 9 |
82 |
tony |
21 |
Height = 22 |
83 |
tony |
80 |
Top = 192 |
84 |
|
|
Width = 241 |
85 |
|
|
Caption = 'Include Primary keys in Update SQL' |
86 |
|
|
TabOrder = 2 |
87 |
tony |
7 |
end |
88 |
tony |
19 |
object GenerateParams: TCheckBox |
89 |
|
|
Left = 9 |
90 |
tony |
21 |
Height = 22 |
91 |
tony |
80 |
Top = 128 |
92 |
tony |
21 |
Width = 171 |
93 |
tony |
19 |
Caption = 'Allow DSQL Placeholders' |
94 |
tony |
80 |
TabOrder = 3 |
95 |
|
|
end |
96 |
|
|
object SelectTableNames: TIBLookupComboEditBox |
97 |
|
|
Left = 12 |
98 |
|
|
Height = 27 |
99 |
|
|
Top = 32 |
100 |
|
|
Width = 209 |
101 |
|
|
KeyField = 'RDB$RELATION_ID' |
102 |
|
|
ListField = 'RDB$RELATION_NAME' |
103 |
|
|
ListFieldIndex = 0 |
104 |
|
|
LookupCache = False |
105 |
|
|
ScrollListDataset = True |
106 |
|
|
TabOrder = 4 |
107 |
|
|
AutoInsert = False |
108 |
|
|
AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
109 |
|
|
ItemHeight = 0 |
110 |
|
|
end |
111 |
|
|
object IncludeSysTables: TCheckBox |
112 |
|
|
Left = 13 |
113 |
|
|
Height = 22 |
114 |
|
|
Top = 59 |
115 |
|
|
Width = 158 |
116 |
|
|
Caption = 'Include System Tables' |
117 |
|
|
OnChange = IncludeSysTablesChange |
118 |
|
|
TabOrder = 5 |
119 |
|
|
end |
120 |
|
|
object PrimaryKeysGrid: TIBDynamicGrid |
121 |
|
|
Left = 288 |
122 |
tony |
105 |
Height = 61 |
123 |
tony |
80 |
Top = 35 |
124 |
|
|
Width = 144 |
125 |
|
|
Color = clWindow |
126 |
|
|
Columns = < |
127 |
|
|
item |
128 |
|
|
ButtonStyle = cbsCheckboxColumn |
129 |
|
|
Title.Caption = 'SELECTED' |
130 |
|
|
Width = 30 |
131 |
|
|
FieldName = 'SELECTED' |
132 |
|
|
AutoSizeColumn = False |
133 |
|
|
InitialSortColumn = False |
134 |
|
|
DBLookupProperties.ItemHeight = 0 |
135 |
|
|
DBLookupProperties.ItemWidth = 0 |
136 |
|
|
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
137 |
|
|
end |
138 |
|
|
item |
139 |
|
|
Title.Caption = 'COLUMNNAME' |
140 |
|
|
Width = 64 |
141 |
|
|
FieldName = 'COLUMNNAME' |
142 |
|
|
AutoSizeColumn = True |
143 |
|
|
InitialSortColumn = False |
144 |
|
|
DBLookupProperties.ItemHeight = 0 |
145 |
|
|
DBLookupProperties.ItemWidth = 0 |
146 |
|
|
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
147 |
|
|
end> |
148 |
|
|
FixedCols = 0 |
149 |
|
|
Options = [dgEditing, dgColumnResize, dgColumnMove, dgRowLines, dgConfirmDelete, dgCancelOnExit, dgDisableDelete, dgDisableInsert] |
150 |
|
|
Scrollbars = ssAutoVertical |
151 |
tony |
19 |
TabOrder = 6 |
152 |
tony |
80 |
ExpandEditorPanelBelowRow = False |
153 |
|
|
Descending = False |
154 |
|
|
EditorBorderStyle = bsSingle |
155 |
|
|
DefaultPositionAtEnd = False |
156 |
tony |
19 |
end |
157 |
tony |
80 |
object FieldNamesGrid: TIBDynamicGrid |
158 |
|
|
Left = 458 |
159 |
tony |
105 |
Height = 216 |
160 |
tony |
80 |
Top = 32 |
161 |
|
|
Width = 144 |
162 |
|
|
Color = clWindow |
163 |
|
|
Columns = < |
164 |
|
|
item |
165 |
|
|
ButtonStyle = cbsCheckboxColumn |
166 |
|
|
Title.Caption = 'SELECTED' |
167 |
|
|
Width = 30 |
168 |
|
|
FieldName = 'SELECTED' |
169 |
|
|
AutoSizeColumn = False |
170 |
|
|
InitialSortColumn = False |
171 |
|
|
DBLookupProperties.ItemHeight = 0 |
172 |
|
|
DBLookupProperties.ItemWidth = 0 |
173 |
|
|
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
174 |
|
|
end |
175 |
|
|
item |
176 |
|
|
Title.Caption = 'COLUMNNAME' |
177 |
|
|
Width = 64 |
178 |
|
|
FieldName = 'COLUMNNAME' |
179 |
|
|
AutoSizeColumn = True |
180 |
|
|
InitialSortColumn = False |
181 |
|
|
DBLookupProperties.ItemHeight = 0 |
182 |
|
|
DBLookupProperties.ItemWidth = 0 |
183 |
|
|
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
184 |
|
|
end> |
185 |
|
|
DataSource = IBSQLEditFrame.FieldsSource |
186 |
|
|
FixedCols = 0 |
187 |
|
|
Options = [dgEditing, dgColumnResize, dgColumnMove, dgRowLines, dgConfirmDelete, dgCancelOnExit, dgDisableDelete, dgDisableInsert] |
188 |
|
|
Scrollbars = ssAutoVertical |
189 |
|
|
TabOrder = 7 |
190 |
|
|
ExpandEditorPanelBelowRow = False |
191 |
|
|
Descending = False |
192 |
|
|
EditorBorderStyle = bsSingle |
193 |
|
|
DefaultPositionAtEnd = False |
194 |
|
|
end |
195 |
|
|
object SelectSelectAll: TCheckBox |
196 |
|
|
Left = 456 |
197 |
|
|
Height = 22 |
198 |
tony |
105 |
Top = 248 |
199 |
tony |
80 |
Width = 134 |
200 |
|
|
Caption = 'Select/Deselect All' |
201 |
|
|
OnClick = SelectSelectAllClick |
202 |
|
|
TabOrder = 8 |
203 |
|
|
end |
204 |
tony |
105 |
object Label5: TLabel |
205 |
|
|
Left = 288 |
206 |
|
|
Height = 14 |
207 |
|
|
Top = 104 |
208 |
|
|
Width = 138 |
209 |
|
|
Caption = '&Computed By Columns' |
210 |
|
|
ParentColor = False |
211 |
|
|
end |
212 |
|
|
object Label6: TLabel |
213 |
|
|
Left = 289 |
214 |
|
|
Height = 14 |
215 |
|
|
Top = 176 |
216 |
|
|
Width = 103 |
217 |
|
|
Caption = '&Identity Columns' |
218 |
|
|
ParentColor = False |
219 |
|
|
end |
220 |
|
|
object ReadOnlyGrid: TIBDynamicGrid |
221 |
|
|
Left = 289 |
222 |
|
|
Height = 48 |
223 |
|
|
Top = 119 |
224 |
|
|
Width = 143 |
225 |
|
|
Color = clWindow |
226 |
|
|
Columns = < |
227 |
|
|
item |
228 |
|
|
ButtonStyle = cbsCheckboxColumn |
229 |
|
|
Title.Caption = 'SELECTED' |
230 |
|
|
Width = 30 |
231 |
|
|
FieldName = 'SELECTED' |
232 |
|
|
AutoSizeColumn = False |
233 |
|
|
InitialSortColumn = False |
234 |
|
|
DBLookupProperties.ItemHeight = 0 |
235 |
|
|
DBLookupProperties.ItemWidth = 0 |
236 |
|
|
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
237 |
|
|
end |
238 |
|
|
item |
239 |
|
|
Title.Caption = 'COLUMNNAME' |
240 |
|
|
Width = 64 |
241 |
|
|
FieldName = 'COLUMNNAME' |
242 |
|
|
AutoSizeColumn = True |
243 |
|
|
InitialSortColumn = False |
244 |
|
|
DBLookupProperties.ItemHeight = 0 |
245 |
|
|
DBLookupProperties.ItemWidth = 0 |
246 |
|
|
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
247 |
|
|
end> |
248 |
|
|
FixedCols = 0 |
249 |
|
|
Options = [dgEditing, dgColumnResize, dgColumnMove, dgRowLines, dgConfirmDelete, dgCancelOnExit, dgDisableDelete, dgDisableInsert] |
250 |
|
|
Scrollbars = ssAutoVertical |
251 |
|
|
TabOrder = 9 |
252 |
|
|
ExpandEditorPanelBelowRow = False |
253 |
|
|
Descending = False |
254 |
|
|
EditorBorderStyle = bsSingle |
255 |
|
|
DefaultPositionAtEnd = False |
256 |
|
|
end |
257 |
|
|
object IdentityGrid: TIBDynamicGrid |
258 |
|
|
Left = 288 |
259 |
|
|
Height = 56 |
260 |
|
|
Top = 192 |
261 |
|
|
Width = 143 |
262 |
|
|
Color = clWindow |
263 |
|
|
Columns = < |
264 |
|
|
item |
265 |
|
|
ButtonStyle = cbsCheckboxColumn |
266 |
|
|
Title.Caption = 'SELECTED' |
267 |
|
|
Width = 30 |
268 |
|
|
FieldName = 'SELECTED' |
269 |
|
|
AutoSizeColumn = False |
270 |
|
|
InitialSortColumn = False |
271 |
|
|
DBLookupProperties.ItemHeight = 0 |
272 |
|
|
DBLookupProperties.ItemWidth = 0 |
273 |
|
|
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
274 |
|
|
end |
275 |
|
|
item |
276 |
|
|
Title.Caption = 'COLUMNNAME' |
277 |
|
|
Width = 64 |
278 |
|
|
FieldName = 'COLUMNNAME' |
279 |
|
|
AutoSizeColumn = True |
280 |
|
|
InitialSortColumn = False |
281 |
|
|
DBLookupProperties.ItemHeight = 0 |
282 |
|
|
DBLookupProperties.ItemWidth = 0 |
283 |
|
|
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
284 |
|
|
end> |
285 |
|
|
DataSource = IBSQLEditFrame.IdentityColsSource |
286 |
|
|
FixedCols = 0 |
287 |
|
|
Options = [dgEditing, dgColumnResize, dgColumnMove, dgRowLines, dgConfirmDelete, dgCancelOnExit, dgDisableDelete, dgDisableInsert] |
288 |
|
|
Scrollbars = ssAutoVertical |
289 |
|
|
TabOrder = 10 |
290 |
|
|
ExpandEditorPanelBelowRow = False |
291 |
|
|
Descending = False |
292 |
|
|
EditorBorderStyle = bsSingle |
293 |
|
|
DefaultPositionAtEnd = False |
294 |
|
|
end |
295 |
tony |
5 |
end |
296 |
|
|
end |
297 |
|
|
object SQLPage: TTabSheet |
298 |
|
|
Caption = 'SQL' |
299 |
tony |
67 |
ClientHeight = 320 |
300 |
tony |
21 |
ClientWidth = 635 |
301 |
tony |
5 |
OnShow = SQLPageShow |
302 |
|
|
object Label2: TLabel |
303 |
|
|
Left = 10 |
304 |
tony |
80 |
Height = 14 |
305 |
tony |
5 |
Top = 81 |
306 |
tony |
19 |
Width = 56 |
307 |
tony |
5 |
Caption = 'S&QL Text:' |
308 |
|
|
ParentColor = False |
309 |
|
|
end |
310 |
|
|
object StatementType: TRadioGroup |
311 |
|
|
Left = 10 |
312 |
tony |
80 |
Height = 49 |
313 |
tony |
5 |
Top = 9 |
314 |
tony |
80 |
Width = 266 |
315 |
tony |
5 |
AutoFill = True |
316 |
|
|
AutoSize = True |
317 |
|
|
Caption = 'Statement Type' |
318 |
|
|
ChildSizing.LeftRightSpacing = 6 |
319 |
|
|
ChildSizing.TopBottomSpacing = 6 |
320 |
|
|
ChildSizing.EnlargeHorizontal = crsHomogenousChildResize |
321 |
|
|
ChildSizing.EnlargeVertical = crsHomogenousChildResize |
322 |
|
|
ChildSizing.ShrinkHorizontal = crsScaleChilds |
323 |
|
|
ChildSizing.ShrinkVertical = crsScaleChilds |
324 |
|
|
ChildSizing.Layout = cclLeftToRightThenTopToBottom |
325 |
tony |
80 |
ChildSizing.ControlsPerLine = 5 |
326 |
|
|
ClientHeight = 34 |
327 |
|
|
ClientWidth = 264 |
328 |
|
|
Columns = 5 |
329 |
tony |
5 |
ItemIndex = 0 |
330 |
|
|
Items.Strings = ( |
331 |
|
|
'&Modify' |
332 |
|
|
'&Insert' |
333 |
|
|
'&Delete' |
334 |
|
|
'&Refresh' |
335 |
|
|
) |
336 |
|
|
OnClick = StatementTypeClick |
337 |
tony |
80 |
TabOrder = 0 |
338 |
tony |
5 |
end |
339 |
tony |
7 |
object TestBtn: TButton |
340 |
tony |
19 |
Left = 539 |
341 |
tony |
5 |
Height = 25 |
342 |
|
|
Top = 31 |
343 |
|
|
Width = 75 |
344 |
|
|
Anchors = [akTop, akRight] |
345 |
|
|
Caption = 'Test' |
346 |
tony |
7 |
OnClick = TestBtnClick |
347 |
tony |
80 |
TabOrder = 1 |
348 |
|
|
end |
349 |
|
|
inline IBSQLEditFrame1: TIBSQLEditFrame |
350 |
|
|
Left = 12 |
351 |
|
|
Height = 217 |
352 |
|
|
Top = 95 |
353 |
|
|
Width = 616 |
354 |
|
|
Anchors = [akTop, akLeft, akRight, akBottom] |
355 |
|
|
ClientHeight = 217 |
356 |
|
|
ClientWidth = 616 |
357 |
tony |
5 |
TabOrder = 2 |
358 |
tony |
80 |
inherited SQLText: TSynEdit |
359 |
|
|
Height = 191 |
360 |
|
|
Width = 616 |
361 |
|
|
OnChange = SQLMemoChange |
362 |
|
|
end |
363 |
|
|
inherited ToolBar1: TToolBar |
364 |
|
|
Width = 616 |
365 |
tony |
106 |
inherited ToolButton3: TToolButton |
366 |
|
|
Height = 8 |
367 |
|
|
end |
368 |
|
|
inherited ToolButton7: TToolButton |
369 |
|
|
Height = 8 |
370 |
|
|
end |
371 |
tony |
80 |
end |
372 |
|
|
inherited FieldNameList: TIBQuery |
373 |
|
|
ParamData = < |
374 |
|
|
item |
375 |
|
|
DataType = ftUnknown |
376 |
|
|
Name = 'RDB$RELATION_NAME' |
377 |
|
|
ParamType = ptInput |
378 |
|
|
end> |
379 |
|
|
end |
380 |
|
|
inherited PrimaryKeys: TIBQuery |
381 |
|
|
ParamData = < |
382 |
|
|
item |
383 |
|
|
DataType = ftUnknown |
384 |
|
|
Name = 'RDB$RELATION_NAME' |
385 |
|
|
ParamType = ptInput |
386 |
|
|
end> |
387 |
|
|
end |
388 |
|
|
inherited ProcInputParams: TIBQuery |
389 |
|
|
ParamData = < |
390 |
|
|
item |
391 |
|
|
DataType = ftUnknown |
392 |
|
|
Name = 'RDB$PROCEDURE_NAME' |
393 |
|
|
ParamType = ptInput |
394 |
|
|
end> |
395 |
|
|
end |
396 |
|
|
inherited ProcOutputParams: TIBQuery |
397 |
|
|
ParamData = < |
398 |
|
|
item |
399 |
|
|
DataType = ftUnknown |
400 |
|
|
Name = 'RDB$PROCEDURE_NAME' |
401 |
|
|
ParamType = ptInput |
402 |
|
|
end> |
403 |
|
|
end |
404 |
tony |
105 |
inherited IdentityCols: TIBQuery |
405 |
|
|
ParamData = < |
406 |
|
|
item |
407 |
|
|
DataType = ftUnknown |
408 |
|
|
Name = 'RDB$RELATION_NAME' |
409 |
|
|
ParamType = ptInput |
410 |
|
|
end> |
411 |
|
|
end |
412 |
|
|
inherited ReadOnlyFields: TIBQuery |
413 |
|
|
ParamData = < |
414 |
|
|
item |
415 |
|
|
DataType = ftUnknown |
416 |
|
|
Name = 'RDB$RELATION_NAME' |
417 |
|
|
ParamType = ptInput |
418 |
|
|
end> |
419 |
|
|
end |
420 |
tony |
5 |
end |
421 |
|
|
end |
422 |
|
|
end |
423 |
|
|
object OkButton: TButton |
424 |
|
|
Left = 480 |
425 |
|
|
Height = 25 |
426 |
|
|
Top = 376 |
427 |
|
|
Width = 75 |
428 |
|
|
Anchors = [akRight, akBottom] |
429 |
|
|
Caption = '&OK' |
430 |
|
|
Default = True |
431 |
|
|
ModalResult = 1 |
432 |
|
|
TabOrder = 1 |
433 |
|
|
end |
434 |
|
|
object CancelButton: TButton |
435 |
|
|
Left = 573 |
436 |
|
|
Height = 25 |
437 |
|
|
Top = 376 |
438 |
|
|
Width = 75 |
439 |
|
|
Anchors = [akRight, akBottom] |
440 |
|
|
Cancel = True |
441 |
|
|
Caption = 'Cancel' |
442 |
|
|
ModalResult = 2 |
443 |
|
|
TabOrder = 2 |
444 |
|
|
end |
445 |
|
|
end |