ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/design/ibsqleditor.lfm
(Generate patch)

Comparing ibx/trunk/design/ibsqleditor.lfm (file contents):
Revision 64 by tony, Thu Jun 29 11:11:22 2017 UTC vs.
Revision 106 by tony, Thu Jan 18 14:37:35 2018 UTC

# Line 1 | Line 1
1 < object IBSQLEditorForm: TIBSQLEditorForm
2 <  Left = 402
3 <  Height = 425
4 <  Top = 369
5 <  Width = 716
6 <  ActiveControl = PageControl
1 > inherited IBSQLEditorForm: TIBSQLEditorForm
2 >  Left = 582
3 >  Height = 555
4 >  Top = 415
5 >  Width = 776
6    Caption = 'IBSQL Editor'
7 <  ClientHeight = 425
8 <  ClientWidth = 716
10 <  DesignTimePPI = 92
7 >  ClientHeight = 555
8 >  ClientWidth = 776
9    OnShow = FormShow
10 <  LCLVersion = '1.8.0.2'
11 <  object Label3: TLabel
14 <    Left = 288
15 <    Height = 14
16 <    Top = 8
17 <    Width = 24
18 <    Caption = 'SQL'
19 <    ParentColor = False
20 <  end
21 <  object SQLText: TMemo
22 <    Left = 288
23 <    Height = 335
24 <    Top = 27
25 <    Width = 418
26 <    Anchors = [akTop, akLeft, akRight, akBottom]
27 <    ScrollBars = ssAutoBoth
28 <    TabOrder = 0
10 >  inherited Label3: TLabel
11 >    Left = 312
12    end
13 <  object GenerateBtn: TButton
14 <    Left = 267
15 <    Height = 30
16 <    Top = 374
17 <    Width = 104
18 <    Anchors = [akRight, akBottom]
19 <    Caption = 'Generate SQL'
13 >  inherited Button1: TButton
14 >    Left = 576
15 >    Top = 504
16 >  end
17 >  inherited Button2: TButton
18 >    Left = 664
19 >    Top = 504
20 >  end
21 >  inherited GenerateBtn: TButton
22 >    Left = 304
23 >    Top = 504
24      OnClick = GenerateBtnClick
38    TabOrder = 1
25    end
26 <  object Button2: TButton
27 <    Left = 627
28 <    Height = 30
29 <    Top = 374
30 <    Width = 72
31 <    Anchors = [akRight, akBottom]
32 <    Cancel = True
33 <    Caption = 'Cancel'
34 <    ModalResult = 2
35 <    TabOrder = 2
36 <  end
37 <  object QuoteFields: TCheckBox
38 <    Left = 16
39 <    Height = 22
40 <    Top = 392
55 <    Width = 125
56 <    Caption = '&Quote Identifiers'
57 <    TabOrder = 3
58 <  end
59 <  object Button1: TButton
60 <    Left = 539
61 <    Height = 30
62 <    Top = 373
63 <    Width = 72
64 <    Anchors = [akRight, akBottom]
65 <    Caption = 'OK'
66 <    Default = True
67 <    ModalResult = 1
68 <    TabOrder = 4
69 <  end
70 <  object PageControl: TPageControl
71 <    Left = 16
72 <    Height = 337
73 <    Top = 27
74 <    Width = 256
75 <    ActivePage = SelectPage
76 <    TabIndex = 0
77 <    TabOrder = 5
78 <    TabPosition = tpLeft
79 <    object SelectPage: TTabSheet
80 <      Caption = 'Select'
81 <      ClientHeight = 331
82 <      ClientWidth = 189
83 <      OnShow = SelectPageShow
84 <      object Label1: TLabel
85 <        Left = 7
86 <        Height = 14
87 <        Top = 3
88 <        Width = 69
89 <        Caption = 'Table Name'
90 <        ParentColor = False
91 <      end
92 <      object Label2: TLabel
93 <        Left = 7
94 <        Height = 14
95 <        Top = 53
96 <        Width = 33
97 <        Caption = 'Fields'
98 <        ParentColor = False
99 <      end
100 <      object Label4: TLabel
101 <        Left = 7
102 <        Height = 14
103 <        Top = 231
104 <        Width = 77
105 <        Caption = 'Primary Keys'
106 <        ParentColor = False
107 <      end
108 <      object SelectTableNames: TComboBox
109 <        Left = 7
110 <        Height = 27
111 <        Top = 19
112 <        Width = 174
113 <        Anchors = [akTop, akLeft, akRight]
114 <        AutoComplete = True
115 <        AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending]
116 <        ItemHeight = 0
117 <        OnCloseUp = SelectTableNamesCloseUp
118 <        TabOrder = 0
26 >  inherited TestBtn: TButton
27 >    Left = 440
28 >    Top = 504
29 >  end
30 >  inherited QuoteFields: TCheckBox
31 >    Left = 11
32 >    Top = 496
33 >  end
34 >  inherited PageControl: TPageControl
35 >    Left = 68
36 >    ShowTabs = False
37 >    inherited SelectPage: TTabSheet
38 >      ClientHeight = 450
39 >      inherited FieldNamesGrid: TIBDynamicGrid
40 >        Height = 104
41        end
42 <      object SelectFieldsList: TListBox
43 <        Left = 7
122 <        Height = 136
123 <        Hint = 'Select Fields to include in Select Statement or leave unselected to select all'
124 <        Top = 69
125 <        Width = 174
126 <        Anchors = [akTop, akLeft, akRight]
127 <        ItemHeight = 0
128 <        MultiSelect = True
129 <        OnDblClick = SelectFieldsListDblClick
130 <        ParentShowHint = False
131 <        ScrollWidth = 172
132 <        ShowHint = True
133 <        TabOrder = 1
134 <        TopIndex = -1
42 >      inherited SelectSelectAll: TCheckBox
43 >        Top = 424
44        end
45 <      object SelectPrimaryKeys: TListBox
46 <        Left = 7
138 <        Height = 77
139 <        Top = 247
140 <        Width = 174
141 <        Anchors = [akTop, akLeft, akRight, akBottom]
142 <        ItemHeight = 0
143 <        ScrollWidth = 172
144 <        TabOrder = 2
145 <        TopIndex = -1
45 >      inherited ReadOnlyGrid: TIBDynamicGrid
46 >        Left = 9
47        end
48      end
49 <    object InsertPage: TTabSheet
50 <      Caption = 'Insert'
150 <      ClientHeight = 331
151 <      ClientWidth = 189
152 <      OnShow = InsertPageShow
153 <      object Label8: TLabel
154 <        Left = 7
155 <        Height = 15
156 <        Top = 3
157 <        Width = 69
158 <        Caption = 'Table Name'
159 <        ParentColor = False
160 <      end
161 <      object Label9: TLabel
162 <        Left = 7
163 <        Height = 15
164 <        Top = 53
165 <        Width = 33
166 <        Caption = 'Fields'
167 <        ParentColor = False
168 <      end
169 <      object InsertTableNames: TComboBox
170 <        Left = 7
171 <        Height = 27
172 <        Top = 19
173 <        Width = 169
174 <        Anchors = [akTop, akLeft, akRight]
175 <        AutoComplete = True
176 <        AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending]
177 <        ItemHeight = 0
178 <        OnCloseUp = InsertTableNamesCloseUp
179 <        TabOrder = 0
180 <      end
181 <      object InsertFieldsList: TListBox
182 <        Left = 7
183 <        Height = 256
184 <        Hint = 'Select Fields to include in Insert  Statement or leave unselected to select all'
185 <        Top = 69
186 <        Width = 169
187 <        Anchors = [akTop, akLeft, akRight, akBottom]
188 <        ItemHeight = 0
189 <        MultiSelect = True
190 <        OnDblClick = SelectFieldsListDblClick
191 <        ParentShowHint = False
192 <        ScrollWidth = 167
193 <        ShowHint = True
194 <        TabOrder = 1
195 <        TopIndex = -1
196 <      end
49 >    inherited ExecutePage: TTabSheet
50 >      ClientHeight = 450
51      end
52 <    object ModifyPage: TTabSheet
53 <      Caption = 'Modify'
54 <      ClientHeight = 331
55 <      ClientWidth = 189
56 <      OnShow = ModifyPageShow
57 <      object Label10: TLabel
58 <        Left = 7
59 <        Height = 15
60 <        Top = 3
61 <        Width = 69
62 <        Caption = 'Table Name'
63 <        ParentColor = False
64 <      end
65 <      object Label11: TLabel
66 <        Left = 7
67 <        Height = 15
68 <        Top = 53
69 <        Width = 33
70 <        Caption = 'Fields'
217 <        ParentColor = False
218 <      end
219 <      object Label12: TLabel
220 <        Left = 7
221 <        Height = 15
222 <        Top = 228
223 <        Width = 77
224 <        Caption = 'Primary Keys'
225 <        ParentColor = False
226 <      end
227 <      object ModifyTableNames: TComboBox
228 <        Left = 7
229 <        Height = 27
230 <        Top = 19
231 <        Width = 169
232 <        Anchors = [akTop, akLeft, akRight]
233 <        AutoComplete = True
234 <        AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending]
235 <        ItemHeight = 0
236 <        OnCloseUp = ModifyTableNamesCloseUp
237 <        TabOrder = 0
238 <      end
239 <      object ModifyFieldsList: TListBox
240 <        Left = 7
241 <        Height = 104
242 <        Hint = 'Select Fields to include in Update Statement or leave unselected to select all'
243 <        Top = 69
244 <        Width = 169
245 <        Anchors = [akTop, akLeft, akRight]
246 <        ItemHeight = 0
247 <        MultiSelect = True
248 <        OnClick = SelectFieldsListDblClick
249 <        ScrollWidth = 167
250 <        TabOrder = 1
251 <        TopIndex = -1
252 <      end
253 <      object ModifyPrimaryKeys: TListBox
254 <        Left = 7
255 <        Height = 77
256 <        Top = 244
257 <        Width = 169
258 <        Anchors = [akTop, akLeft, akRight, akBottom]
259 <        ItemHeight = 0
260 <        OnClick = SelectFieldsListDblClick
261 <        ScrollWidth = 167
262 <        TabOrder = 2
263 <        TopIndex = -1
264 <      end
265 <      object IncludePrimaryKeys: TCheckBox
266 <        Left = 5
267 <        Height = 22
268 <        Top = 181
269 <        Width = 150
270 <        Caption = 'Include Primary keys'
271 <        OnClick = IncludePrimaryKeysClick
272 <        TabOrder = 3
273 <      end
274 <      object Label5: TLabel
275 <        Left = 27
276 <        Height = 15
277 <        Top = 202
278 <        Width = 67
279 <        Caption = 'in Field List'
280 <        ParentColor = False
281 <      end
52 >  end
53 >  inherited GenerateParams: TCheckBox
54 >    Left = 11
55 >    Top = 472
56 >  end
57 >  inherited IBSQLEditFrame1: TIBSQLEditFrame
58 >    Left = 312
59 >    Height = 440
60 >    Top = 24
61 >    Width = 447
62 >    Anchors = [akTop, akLeft, akRight, akBottom]
63 >    ClientHeight = 440
64 >    ClientWidth = 447
65 >    TabOrder = 7
66 >    DesignLeft = 1974
67 >    DesignTop = 200
68 >    inherited SQLText: TSynEdit
69 >      Height = 414
70 >      Width = 447
71      end
72 <    object DeletePage: TTabSheet
73 <      Caption = 'Delete'
285 <      ClientHeight = 331
286 <      ClientWidth = 189
287 <      OnShow = DeletePageShow
288 <      object Label14: TLabel
289 <        Left = 7
290 <        Height = 15
291 <        Top = 3
292 <        Width = 69
293 <        Caption = 'Table Name'
294 <        ParentColor = False
295 <      end
296 <      object Label15: TLabel
297 <        Left = 7
298 <        Height = 15
299 <        Top = 66
300 <        Width = 77
301 <        Caption = 'Primary Keys'
302 <        ParentColor = False
303 <      end
304 <      object DeleteTableNames: TComboBox
305 <        Left = 7
306 <        Height = 27
307 <        Top = 19
308 <        Width = 169
309 <        Anchors = [akTop, akLeft, akRight]
310 <        AutoComplete = True
311 <        AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending]
312 <        ItemHeight = 0
313 <        OnCloseUp = DeleteTableNamesCloseUp
314 <        TabOrder = 0
315 <      end
316 <      object DeletePrimaryKeys: TListBox
317 <        Left = 7
318 <        Height = 55
319 <        Top = 82
320 <        Width = 167
321 <        Anchors = [akTop, akLeft, akRight]
322 <        ItemHeight = 0
323 <        OnDblClick = SelectFieldsListDblClick
324 <        ScrollWidth = 165
325 <        TabOrder = 1
326 <        TopIndex = -1
327 <      end
72 >    inherited ToolBar1: TToolBar
73 >      Width = 447
74      end
75 <    object ExecutePage: TTabSheet
76 <      Caption = 'Execute'
77 <      ClientHeight = 331
78 <      ClientWidth = 189
79 <      OnShow = ExecutePageShow
80 <      object Label16: TLabel
81 <        Left = 7
82 <        Height = 15
83 <        Top = 3
84 <        Width = 100
85 <        Caption = 'Procedure Name'
86 <        ParentColor = False
87 <      end
88 <      object Label17: TLabel
89 <        Left = 10
90 <        Height = 15
91 <        Top = 61
92 <        Width = 104
93 <        Caption = 'Input Parameters'
94 <        ParentColor = False
95 <      end
96 <      object Label18: TLabel
97 <        Left = 11
98 <        Height = 15
99 <        Top = 181
100 <        Width = 114
101 <        Caption = 'Output Parameters'
102 <        ParentColor = False
103 <      end
104 <      object ProcedureNames: TComboBox
105 <        Left = 7
106 <        Height = 27
107 <        Top = 19
108 <        Width = 169
109 <        Anchors = [akTop, akLeft, akRight]
110 <        ItemHeight = 0
111 <        OnCloseUp = ProcedureNamesCloseUp
112 <        TabOrder = 0
113 <      end
114 <      object ProcInputList: TListBox
115 <        Left = 6
116 <        Height = 80
117 <        Top = 82
118 <        Width = 164
119 <        Anchors = [akTop, akLeft, akRight]
120 <        IntegralHeight = True
121 <        ItemHeight = 0
122 <        ScrollWidth = 162
123 <        TabOrder = 1
124 <        TopIndex = -1
125 <      end
126 <      object ProcOutputList: TListBox
127 <        Left = 10
128 <        Height = 97
129 <        Top = 201
130 <        Width = 160
131 <        Anchors = [akTop, akLeft, akRight]
386 <        IntegralHeight = True
387 <        ItemHeight = 0
388 <        ScrollWidth = 158
389 <        TabOrder = 2
390 <        TopIndex = -1
391 <      end
392 <      object SelectProcedure: TLabel
393 <        Left = 7
394 <        Height = 14
395 <        Top = 310
396 <        Width = 126
397 <        Anchors = [akLeft, akBottom]
398 <        Caption = 'Is ''Select Procedure'''
399 <        Font.Height = -11
400 <        Font.Style = [fsBold]
401 <        ParentColor = False
402 <        ParentFont = False
403 <        Visible = False
404 <      end
75 >    inherited FieldNameList: TIBQuery
76 >      ParamData = <      
77 >        item
78 >          DataType = ftUnknown
79 >          Name = 'RDB$RELATION_NAME'
80 >          ParamType = ptInput
81 >        end>
82 >    end
83 >    inherited PrimaryKeys: TIBQuery
84 >      ParamData = <      
85 >        item
86 >          DataType = ftUnknown
87 >          Name = 'RDB$RELATION_NAME'
88 >          ParamType = ptInput
89 >        end>
90 >    end
91 >    inherited UserProcedures: TIBQuery
92 >      AfterScroll = UserProceduresAfterScroll
93 >    end
94 >    inherited ProcInputParams: TIBQuery
95 >      ParamData = <      
96 >        item
97 >          DataType = ftUnknown
98 >          Name = 'RDB$PROCEDURE_NAME'
99 >          ParamType = ptInput
100 >        end>
101 >    end
102 >    inherited ProcOutputParams: TIBQuery
103 >      ParamData = <      
104 >        item
105 >          DataType = ftUnknown
106 >          Name = 'RDB$PROCEDURE_NAME'
107 >          ParamType = ptInput
108 >        end>
109 >    end
110 >    inherited SQLTransaction: TIBTransaction
111 >      Params.Strings = (      )
112 >    end
113 >    inherited IdentityCols: TIBQuery
114 >      ParamData = <      
115 >        item
116 >          DataType = ftUnknown
117 >          Name = 'RDB$RELATION_NAME'
118 >          ParamType = ptInput
119 >        end>
120 >    end
121 >    inherited ReadOnlyFields: TIBQuery
122 >      ParamData = <      
123 >        item
124 >          DataType = ftUnknown
125 >          Name = 'RDB$RELATION_NAME'
126 >          ParamType = ptInput
127 >        end>
128 >    end
129 >    inherited ReadOnlyFieldsSource: TDataSource
130 >      left = 436
131 >      top = 203
132      end
133    end
134 <  object TestBtn: TButton
135 <    Left = 403
136 <    Height = 30
137 <    Top = 374
138 <    Width = 66
139 <    Anchors = [akRight, akBottom]
140 <    Caption = 'Test'
141 <    OnClick = TestBtnClick
142 <    TabOrder = 6
134 >  object TabControl1: TTabControl[9]
135 >    Left = 11
136 >    Height = 312
137 >    Top = 8
138 >    Width = 59
139 >    OnChange = TabControl1Change
140 >    TabPosition = tpLeft
141 >    TabIndex = 0
142 >    Tabs.Strings = (
143 >      'Select'
144 >      'Insert'
145 >      'Modify'
146 >      'Delete'
147 >      'Execute'
148 >    )
149 >    TabOrder = 8
150    end
151 <  object GenerateParams: TCheckBox
152 <    Left = 16
151 >  object IncludePrimaryKeys: TCheckBox[10]
152 >    Left = 11
153      Height = 22
154 <    Top = 368
155 <    Width = 171
156 <    Caption = 'Allow DSQL Placeholders'
157 <    TabOrder = 7
424 <  end
425 <  object IBTransaction1: TIBTransaction
426 <    Active = False
427 <    left = 200
428 <    top = 391
154 >    Top = 520
155 >    Width = 241
156 >    Caption = 'Include Primary keys in Update SQL'
157 >    TabOrder = 9
158    end
159   end

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines