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 |