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