ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/design/ibupdatesqleditor.lfm
Revision: 105
Committed: Thu Jan 18 14:37:32 2018 UTC (6 years, 3 months ago) by tony
File size: 13507 byte(s)
Log Message:
Property Editor Fixes

File Contents

# Content
1 object IBUpdateSQLEditorForm: TIBUpdateSQLEditorForm
2 Left = 442
3 Height = 410
4 Top = 421
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 Position = poScreenCenter
15 LCLVersion = '1.8.1.0'
16 object PageControl: TPageControl
17 Left = 8
18 Height = 352
19 Top = 8
20 Width = 641
21 ActivePage = FieldsPage
22 Anchors = [akTop, akLeft, akRight, akBottom]
23 TabIndex = 0
24 TabOrder = 0
25 object FieldsPage: TTabSheet
26 Caption = 'Options'
27 ClientHeight = 320
28 ClientWidth = 635
29 object GroupBox1: TGroupBox
30 Left = 8
31 Height = 315
32 Top = 4
33 Width = 617
34 Anchors = [akTop, akLeft, akRight, akBottom]
35 Caption = ' SQL Generation '
36 ClientHeight = 300
37 ClientWidth = 615
38 TabOrder = 0
39 object Label1: TLabel
40 Left = 12
41 Height = 14
42 Top = 18
43 Width = 73
44 Caption = 'Table &Name:'
45 ParentColor = False
46 end
47 object Label3: TLabel
48 Left = 288
49 Height = 14
50 Top = 16
51 Width = 62
52 Caption = '&Key Fields:'
53 ParentColor = False
54 end
55 object Label4: TLabel
56 Left = 458
57 Height = 14
58 Top = 18
59 Width = 110
60 Caption = 'Updateable &Fields:'
61 ParentColor = False
62 end
63 object GenerateButton: TButton
64 Left = 9
65 Height = 25
66 Top = 83
67 Width = 168
68 Caption = '&Generate SQL'
69 OnClick = GenerateButtonClick
70 TabOrder = 0
71 end
72 object QuoteFields: TCheckBox
73 Left = 9
74 Height = 22
75 Top = 160
76 Width = 125
77 Caption = '&Quote Identifiers'
78 TabOrder = 1
79 end
80 object IncludePrimaryKeys: TCheckBox
81 Left = 9
82 Height = 22
83 Top = 192
84 Width = 241
85 Caption = 'Include Primary keys in Update SQL'
86 TabOrder = 2
87 end
88 object GenerateParams: TCheckBox
89 Left = 9
90 Height = 22
91 Top = 128
92 Width = 171
93 Caption = 'Allow DSQL Placeholders'
94 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 Height = 61
123 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 TabOrder = 6
152 ExpandEditorPanelBelowRow = False
153 Descending = False
154 EditorBorderStyle = bsSingle
155 DefaultPositionAtEnd = False
156 end
157 object FieldNamesGrid: TIBDynamicGrid
158 Left = 458
159 Height = 216
160 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 Top = 248
199 Width = 134
200 Caption = 'Select/Deselect All'
201 OnClick = SelectSelectAllClick
202 TabOrder = 8
203 end
204 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 end
296 end
297 object SQLPage: TTabSheet
298 Caption = 'SQL'
299 ClientHeight = 320
300 ClientWidth = 635
301 OnShow = SQLPageShow
302 object Label2: TLabel
303 Left = 10
304 Height = 14
305 Top = 81
306 Width = 56
307 Caption = 'S&QL Text:'
308 ParentColor = False
309 end
310 object StatementType: TRadioGroup
311 Left = 10
312 Height = 49
313 Top = 9
314 Width = 266
315 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 ChildSizing.ControlsPerLine = 5
326 ClientHeight = 34
327 ClientWidth = 264
328 Columns = 5
329 ItemIndex = 0
330 Items.Strings = (
331 '&Modify'
332 '&Insert'
333 '&Delete'
334 '&Refresh'
335 )
336 OnClick = StatementTypeClick
337 TabOrder = 0
338 end
339 object TestBtn: TButton
340 Left = 539
341 Height = 25
342 Top = 31
343 Width = 75
344 Anchors = [akTop, akRight]
345 Caption = 'Test'
346 OnClick = TestBtnClick
347 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 TabOrder = 2
358 inherited SQLText: TSynEdit
359 Height = 191
360 Width = 616
361 OnChange = SQLMemoChange
362 end
363 inherited ToolBar1: TToolBar
364 Width = 616
365 end
366 inherited FieldNameList: TIBQuery
367 ParamData = <
368 item
369 DataType = ftUnknown
370 Name = 'RDB$RELATION_NAME'
371 ParamType = ptInput
372 end>
373 end
374 inherited PrimaryKeys: TIBQuery
375 ParamData = <
376 item
377 DataType = ftUnknown
378 Name = 'RDB$RELATION_NAME'
379 ParamType = ptInput
380 end>
381 end
382 inherited ProcInputParams: TIBQuery
383 ParamData = <
384 item
385 DataType = ftUnknown
386 Name = 'RDB$PROCEDURE_NAME'
387 ParamType = ptInput
388 end>
389 end
390 inherited ProcOutputParams: TIBQuery
391 ParamData = <
392 item
393 DataType = ftUnknown
394 Name = 'RDB$PROCEDURE_NAME'
395 ParamType = ptInput
396 end>
397 end
398 inherited IdentityCols: TIBQuery
399 ParamData = <
400 item
401 DataType = ftUnknown
402 Name = 'RDB$RELATION_NAME'
403 ParamType = ptInput
404 end>
405 end
406 inherited ReadOnlyFields: TIBQuery
407 ParamData = <
408 item
409 DataType = ftUnknown
410 Name = 'RDB$RELATION_NAME'
411 ParamType = ptInput
412 end>
413 end
414 end
415 end
416 end
417 object OkButton: TButton
418 Left = 480
419 Height = 25
420 Top = 376
421 Width = 75
422 Anchors = [akRight, akBottom]
423 Caption = '&OK'
424 Default = True
425 ModalResult = 1
426 TabOrder = 1
427 end
428 object CancelButton: TButton
429 Left = 573
430 Height = 25
431 Top = 376
432 Width = 75
433 Anchors = [akRight, akBottom]
434 Cancel = True
435 Caption = 'Cancel'
436 ModalResult = 2
437 TabOrder = 2
438 end
439 end