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

Comparing ibx/trunk/design/ibmodifysqleditor.lfm (file contents):
Revision 67 by tony, Tue Oct 3 14:08:11 2017 UTC vs.
Revision 105 by tony, Thu Jan 18 14:37:32 2018 UTC

# Line 1 | Line 1
1 < object IBModifySQLEditorForm: TIBModifySQLEditorForm
2 <  Left = 508
3 <  Height = 438
4 <  Top = 250
5 <  Width = 749
1 > inherited IBModifySQLEditorForm: TIBModifySQLEditorForm
2 >  Left = 949
3 >  Top = 264
4    Caption = 'Modify SQL Editor'
5 <  ClientHeight = 438
8 <  ClientWidth = 749
9 <  OnShow = FormShow
10 <  Position = poScreenCenter
11 <  LCLVersion = '1.8.0.4'
12 <  object Label3: TLabel
13 <    Left = 279
14 <    Height = 14
15 <    Top = 16
16 <    Width = 24
17 <    Caption = 'SQL'
18 <    ParentColor = False
19 <  end
20 <  object SQLText: TMemo
21 <    Left = 279
22 <    Height = 328
23 <    Top = 36
24 <    Width = 439
25 <    Anchors = [akTop, akLeft, akRight, akBottom]
26 <    ScrollBars = ssAutoBoth
27 <    TabOrder = 0
28 <  end
29 <  object Button1: TButton
30 <    Left = 552
31 <    Height = 30
32 <    Top = 379
33 <    Width = 72
34 <    Anchors = [akRight, akBottom]
35 <    Caption = 'OK'
36 <    Default = True
37 <    ModalResult = 1
38 <    TabOrder = 1
39 <  end
40 <  object Button2: TButton
41 <    Left = 640
42 <    Height = 30
43 <    Top = 380
44 <    Width = 72
45 <    Anchors = [akRight, akBottom]
46 <    Cancel = True
47 <    Caption = 'Cancel'
48 <    ModalResult = 2
49 <    TabOrder = 2
50 <  end
51 <  object GenerateBtn: TButton
52 <    Left = 280
53 <    Height = 30
54 <    Top = 380
55 <    Width = 101
56 <    Anchors = [akRight, akBottom]
57 <    Caption = 'Generate SQL'
5 >  inherited GenerateBtn: TButton
6      OnClick = GenerateBtnClick
59    TabOrder = 3
60  end
61  object TestBtn: TButton
62    Left = 416
63    Height = 30
64    Top = 380
65    Width = 66
66    Anchors = [akRight, akBottom]
67    Caption = 'Test'
68    OnClick = TestBtnClick
69    TabOrder = 4
70  end
71  object QuoteFields: TCheckBox
72    Left = 16
73    Height = 22
74    Top = 400
75    Width = 125
76    Caption = '&Quote Identifiers'
77    TabOrder = 5
7    end
8 <  object GenerateParams: TCheckBox
9 <    Left = 16
10 <    Height = 22
11 <    Top = 376
12 <    Width = 171
13 <    Caption = 'Allow DSQL Placeholders'
14 <    TabOrder = 6
15 <  end
87 <  object PageControl: TPageControl
88 <    Left = 18
89 <    Height = 346
90 <    Top = 18
91 <    Width = 238
92 <    ActivePage = ExecutePage
93 <    TabIndex = 1
94 <    TabOrder = 7
95 <    object ModifyPage: TTabSheet
96 <      Caption = 'Update'
97 <      ClientHeight = 314
98 <      ClientWidth = 232
99 <      OnShow = ModifyPageShow
100 <      object Label1: TLabel
101 <        Left = 8
102 <        Height = 15
103 <        Top = 8
104 <        Width = 69
105 <        Caption = 'Table Name'
106 <        ParentColor = False
8 >  inherited PageControl: TPageControl
9 >    inherited SelectPage: TTabSheet
10 >      inherited Label2: TLabel
11 >        Width = 106
12 >        Caption = 'Updateable Fields'
13 >      end
14 >      inherited Label4: TLabel
15 >        Top = 290
16        end
17 <      object TableNamesCombo: TComboBox
18 <        Left = 8
110 <        Height = 27
111 <        Top = 22
112 <        Width = 201
113 <        AutoComplete = True
114 <        AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending]
115 <        ItemHeight = 0
116 <        OnCloseUp = TableNamesComboCloseUp
117 <        TabOrder = 0
17 >      inherited FieldNamesGrid: TIBDynamicGrid
18 >        Height = 112
19        end
20 <      object Label2: TLabel
21 <        Left = 8
121 <        Height = 15
122 <        Top = 56
123 <        Width = 33
124 <        Caption = 'Fields'
125 <        ParentColor = False
20 >      inherited PrimaryKeysGrid: TIBDynamicGrid
21 >        Height = 48
22        end
23 <      object FieldList: TListBox
24 <        Left = 8
129 <        Height = 120
130 <        Hint = 'Select Fields to include in Update Statement, or leave unselected to select all'
131 <        Top = 72
132 <        Width = 200
133 <        ItemHeight = 0
134 <        MultiSelect = True
135 <        OnDblClick = FieldListDblClick
136 <        ParentShowHint = False
137 <        ScrollWidth = 198
138 <        ShowHint = True
139 <        TabOrder = 1
140 <        TopIndex = -1
23 >      inherited SelectSelectAll: TCheckBox
24 >        Top = 200
25        end
26 <      object IncludePrimaryKeys: TCheckBox
27 <        Left = 8
26 >      object IncludePrimaryKeys: TCheckBox[8]
27 >        Left = 7
28          Height = 22
29 <        Top = 200
29 >        Top = 352
30          Width = 221
31          Caption = 'Include Primary keys in Field List'
32          Checked = True
33 <        OnClick = TableNamesComboCloseUp
33 >        OnChange = IncludePrimaryKeysChange
34          State = cbChecked
35 <        TabOrder = 2
152 <      end
153 <      object Label4: TLabel
154 <        Left = 8
155 <        Height = 15
156 <        Top = 229
157 <        Width = 77
158 <        Caption = 'Primary Keys'
159 <        ParentColor = False
35 >        TabOrder = 5
36        end
37 <      object PrimaryKeyList: TListBox
162 <        Left = 8
163 <        Height = 59
164 <        Top = 248
165 <        Width = 200
166 <        ItemHeight = 0
167 <        OnDblClick = PrimaryKeyListDblClick
168 <        ScrollWidth = 198
169 <        TabOrder = 3
170 <        TopIndex = -1
171 <      end
172 <    end
173 <    object ExecutePage: TTabSheet
174 <      Caption = 'Execute'
175 <      ClientHeight = 314
176 <      ClientWidth = 232
177 <      OnShow = ExecutePageShow
178 <      object Label16: TLabel
37 >      object Label5: TLabel[9]
38          Left = 7
39          Height = 14
40 <        Top = 8
41 <        Width = 100
42 <        Caption = 'Procedure Name'
43 <        ParentColor = False
40 >        Top = 226
41 >        Width = 138
42 >        Caption = 'Computed By Columns'
43 >        ParentColor = False
44 >      end
45 >      object ReadOnlyGrid: TIBDynamicGrid[10]
46 >        Left = 8
47 >        Height = 48
48 >        Top = 241
49 >        Width = 209
50 >        Color = clWindow
51 >        Columns = <        
52 >          item
53 >            ButtonStyle = cbsCheckboxColumn
54 >            Title.Caption = 'SELECTED'
55 >            Width = 30
56 >            FieldName = 'SELECTED'
57 >            AutoSizeColumn = False
58 >            InitialSortColumn = False
59 >            DBLookupProperties.ItemHeight = 0
60 >            DBLookupProperties.ItemWidth = 0
61 >            DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending]
62 >          end        
63 >          item
64 >            Title.Caption = 'COLUMNNAME'
65 >            Width = 64
66 >            FieldName = 'COLUMNNAME'
67 >            AutoSizeColumn = True
68 >            InitialSortColumn = False
69 >            DBLookupProperties.ItemHeight = 0
70 >            DBLookupProperties.ItemWidth = 0
71 >            DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending]
72 >          end>
73 >        FixedCols = 0
74 >        Options = [dgEditing, dgColumnResize, dgColumnMove, dgRowLines, dgConfirmDelete, dgCancelOnExit, dgDisableDelete, dgDisableInsert]
75 >        Scrollbars = ssAutoVertical
76 >        TabOrder = 6
77 >        ExpandEditorPanelBelowRow = False
78 >        Descending = False
79 >        EditorBorderStyle = bsSingle
80 >        DefaultPositionAtEnd = False
81        end
82 <      object ProcedureNames: TComboBox
83 <        Left = 7
84 <        Height = 27
85 <        Top = 24
190 <        Width = 201
191 <        ItemHeight = 0
192 <        OnCloseUp = ProcedureNamesCloseUp
193 <        ParentColor = True
194 <        TabOrder = 0
195 <      end
196 <      object Label17: TLabel
197 <        Left = 7
198 <        Height = 14
199 <        Top = 56
200 <        Width = 104
201 <        Caption = 'Input Parameters'
202 <        ParentColor = False
203 <      end
204 <      object ProcInputList: TListBox
205 <        Left = 8
206 <        Height = 103
207 <        Top = 72
208 <        Width = 198
209 <        IntegralHeight = True
210 <        ItemHeight = 0
211 <        ScrollWidth = 196
212 <        TabOrder = 1
213 <        TopIndex = -1
82 >    end
83 >    inherited ExecutePage: TTabSheet
84 >      inherited Label18: TLabel
85 >        Visible = False
86        end
87 <      object ProcOutputList: TListBox
88 <        Left = 7
89 <        Height = 80
218 <        Top = 200
219 <        Width = 198
220 <        IntegralHeight = True
221 <        ItemHeight = 0
222 <        ScrollWidth = 196
223 <        TabOrder = 2
224 <        TopIndex = -1
87 >      inherited SelectProcedure: TLabel
88 >        Width = 81
89 >        Caption = 'Execute Only'
90        end
91 <      object Label18: TLabel
92 <        Left = 7
228 <        Height = 14
229 <        Top = 184
230 <        Width = 114
231 <        Caption = 'Output Parameters'
232 <        ParentColor = False
91 >      inherited InputProcGrid: TIBDynamicGrid
92 >        Height = 224
93        end
94 <      object ExecuteOnlyIndicator: TLabel
235 <        Left = 10
236 <        Height = 14
237 <        Top = 293
238 <        Width = 89
239 <        Caption = 'Execute Only'
240 <        Font.Style = [fsBold]
241 <        ParentColor = False
242 <        ParentFont = False
94 >      inherited OutputProcGrid: TIBDynamicGrid
95          Visible = False
96        end
97      end
98    end
99 <  object IBTransaction1: TIBTransaction
100 <    Active = False
101 <    left = 209
102 <    top = 388
99 >  inherited IBSQLEditFrame1: TIBSQLEditFrame
100 >    Left = 282
101 >    Height = 339
102 >    Top = 24
103 >    Width = 448
104 >    Anchors = [akTop, akLeft, akRight, akBottom]
105 >    ClientHeight = 339
106 >    ClientWidth = 448
107 >    TabOrder = 7
108 >    DesignLeft = 1974
109 >    DesignTop = 200
110 >    inherited SQLText: TSynEdit
111 >      Height = 313
112 >      Width = 448
113 >    end
114 >    inherited ToolBar1: TToolBar
115 >      Width = 448
116 >    end
117 >    inherited FieldNameList: TIBQuery
118 >      ParamData = <      
119 >        item
120 >          DataType = ftUnknown
121 >          Name = 'RDB$RELATION_NAME'
122 >          ParamType = ptInput
123 >        end>
124 >    end
125 >    inherited PrimaryKeys: TIBQuery
126 >      ParamData = <      
127 >        item
128 >          DataType = ftUnknown
129 >          Name = 'RDB$RELATION_NAME'
130 >          ParamType = ptInput
131 >        end>
132 >    end
133 >    inherited UserProcedures: TIBQuery
134 >      AfterScroll = UserProceduresAfterScroll
135 >    end
136 >    inherited ProcInputParams: TIBQuery
137 >      ParamData = <      
138 >        item
139 >          DataType = ftUnknown
140 >          Name = 'RDB$PROCEDURE_NAME'
141 >          ParamType = ptInput
142 >        end>
143 >    end
144 >    inherited ProcOutputParams: TIBQuery
145 >      ParamData = <      
146 >        item
147 >          DataType = ftUnknown
148 >          Name = 'RDB$PROCEDURE_NAME'
149 >          ParamType = ptInput
150 >        end>
151 >    end
152 >    inherited SQLTransaction: TIBTransaction
153 >      Params.Strings = (      )
154 >    end
155 >    inherited IdentityCols: TIBQuery
156 >      ParamData = <      
157 >        item
158 >          DataType = ftUnknown
159 >          Name = 'RDB$RELATION_NAME'
160 >          ParamType = ptInput
161 >        end>
162 >    end
163 >    inherited ReadOnlyFields: TIBQuery
164 >      ParamData = <      
165 >        item
166 >          DataType = ftUnknown
167 >          Name = 'RDB$RELATION_NAME'
168 >          ParamType = ptInput
169 >        end>
170 >    end
171 >    inherited ReadOnlyFieldsSource: TDataSource
172 >      left = 436
173 >      top = 203
174 >    end
175    end
176   end

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines