ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/design/ibupdatesqleditor.lfm
Revision: 106
Committed: Thu Jan 18 14:37:35 2018 UTC (6 years, 9 months ago) by tony
File size: 13671 byte(s)
Log Message:
Updates Merged

File Contents

# User Rev Content
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