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 21 by tony, Thu Feb 26 10:33:34 2015 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 <  LCLVersion = '1.2.6.0'
11 <  object Label3: TLabel
12 <    Left = 279
13 <    Height = 15
14 <    Top = 16
15 <    Width = 24
16 <    Caption = 'SQL'
17 <    ParentColor = False
18 <  end
19 <  object SQLText: TMemo
20 <    Left = 279
21 <    Height = 328
22 <    Top = 36
23 <    Width = 439
24 <    Anchors = [akTop, akLeft, akRight, akBottom]
25 <    ScrollBars = ssAutoBoth
26 <    TabOrder = 0
27 <  end
28 <  object Button1: TButton
29 <    Left = 552
30 <    Height = 30
31 <    Top = 379
32 <    Width = 72
33 <    Anchors = [akRight, akBottom]
34 <    Caption = 'OK'
35 <    Default = True
36 <    ModalResult = 1
37 <    TabOrder = 1
38 <  end
39 <  object Button2: TButton
40 <    Left = 640
41 <    Height = 30
42 <    Top = 380
43 <    Width = 72
44 <    Anchors = [akRight, akBottom]
45 <    Cancel = True
46 <    Caption = 'Cancel'
47 <    ModalResult = 2
48 <    TabOrder = 2
49 <  end
50 <  object GenerateBtn: TButton
51 <    Left = 280
52 <    Height = 30
53 <    Top = 380
54 <    Width = 101
55 <    Anchors = [akRight, akBottom]
56 <    Caption = 'Generate SQL'
5 >  inherited GenerateBtn: TButton
6      OnClick = GenerateBtnClick
58    TabOrder = 3
59  end
60  object TestBtn: TButton
61    Left = 416
62    Height = 30
63    Top = 380
64    Width = 66
65    Anchors = [akRight, akBottom]
66    Caption = 'Test'
67    OnClick = TestBtnClick
68    TabOrder = 4
69  end
70  object QuoteFields: TCheckBox
71    Left = 16
72    Height = 22
73    Top = 400
74    Width = 125
75    Caption = '&Quote Identifiers'
76    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
86 <  object PageControl: TPageControl
87 <    Left = 18
88 <    Height = 346
89 <    Top = 18
90 <    Width = 238
91 <    ActivePage = ExecutePage
92 <    TabIndex = 1
93 <    TabOrder = 7
94 <    object ModifyPage: TTabSheet
95 <      Caption = 'Update'
96 <      ClientHeight = 313
97 <      ClientWidth = 232
98 <      OnShow = ModifyPageShow
99 <      object Label1: TLabel
100 <        Left = 8
101 <        Height = 15
102 <        Top = 8
103 <        Width = 69
104 <        Caption = 'Table Name'
105 <        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
109 <        Height = 27
110 <        Top = 22
111 <        Width = 201
112 <        AutoComplete = True
113 <        AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending]
114 <        ItemHeight = 0
115 <        OnCloseUp = TableNamesComboCloseUp
116 <        TabOrder = 0
17 >      inherited FieldNamesGrid: TIBDynamicGrid
18 >        Height = 112
19        end
20 <      object Label2: TLabel
21 <        Left = 8
120 <        Height = 15
121 <        Top = 56
122 <        Width = 33
123 <        Caption = 'Fields'
124 <        ParentColor = False
20 >      inherited PrimaryKeysGrid: TIBDynamicGrid
21 >        Height = 48
22        end
23 <      object FieldList: TListBox
24 <        Left = 8
128 <        Height = 120
129 <        Hint = 'Select Fields to include in Update Statement, or leave unselected to select all'
130 <        Top = 72
131 <        Width = 200
132 <        ItemHeight = 0
133 <        MultiSelect = True
134 <        OnDblClick = FieldListDblClick
135 <        ParentShowHint = False
136 <        ScrollWidth = 198
137 <        ShowHint = True
138 <        TabOrder = 1
139 <        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
151 <      end
152 <      object Label4: TLabel
153 <        Left = 8
154 <        Height = 15
155 <        Top = 229
156 <        Width = 77
157 <        Caption = 'Primary Keys'
158 <        ParentColor = False
159 <      end
160 <      object PrimaryKeyList: TListBox
161 <        Left = 8
162 <        Height = 59
163 <        Top = 248
164 <        Width = 200
165 <        ItemHeight = 0
166 <        OnDblClick = PrimaryKeyListDblClick
167 <        ScrollWidth = 198
168 <        TabOrder = 3
169 <        TopIndex = -1
170 <      end
171 <    end
172 <    object ExecutePage: TTabSheet
173 <      Caption = 'Execute'
174 <      ClientHeight = 313
175 <      ClientWidth = 232
176 <      OnShow = ExecutePageShow
177 <      object Label16: TLabel
178 <        Left = 7
179 <        Height = 15
180 <        Top = 8
181 <        Width = 100
182 <        Caption = 'Procedure Name'
183 <        ParentColor = False
35 >        TabOrder = 5
36        end
37 <      object ProcedureNames: TComboBox
37 >      object Label5: TLabel[9]
38          Left = 7
39 <        Height = 27
40 <        Top = 24
41 <        Width = 201
42 <        ItemHeight = 0
43 <        OnCloseUp = ProcedureNamesCloseUp
44 <        ParentColor = True
45 <        TabOrder = 0
39 >        Height = 14
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 Label17: TLabel
83 <        Left = 7
84 <        Height = 15
85 <        Top = 56
199 <        Width = 104
200 <        Caption = 'Input Parameters'
201 <        ParentColor = False
202 <      end
203 <      object ProcInputList: TListBox
204 <        Left = 8
205 <        Height = 103
206 <        Top = 72
207 <        Width = 198
208 <        IntegralHeight = True
209 <        ItemHeight = 0
210 <        ScrollWidth = 196
211 <        TabOrder = 1
212 <        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
217 <        Top = 200
218 <        Width = 198
219 <        IntegralHeight = True
220 <        ItemHeight = 0
221 <        ScrollWidth = 196
222 <        TabOrder = 2
223 <        TopIndex = -1
87 >      inherited SelectProcedure: TLabel
88 >        Width = 81
89 >        Caption = 'Execute Only'
90        end
91 <      object Label18: TLabel
92 <        Left = 7
227 <        Height = 15
228 <        Top = 184
229 <        Width = 114
230 <        Caption = 'Output Parameters'
231 <        ParentColor = False
91 >      inherited InputProcGrid: TIBDynamicGrid
92 >        Height = 224
93        end
94 <      object ExecuteOnlyIndicator: TLabel
234 <        Left = 10
235 <        Height = 15
236 <        Top = 293
237 <        Width = 89
238 <        Caption = 'Execute Only'
239 <        Font.Style = [fsBold]
240 <        ParentColor = False
241 <        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