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 |