1 |
< |
object IBModifySQLEditorForm: TIBModifySQLEditorForm |
2 |
< |
Left = 330 |
3 |
< |
Height = 438 |
4 |
< |
Top = 215 |
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.28.2' |
10 |
< |
object Label1: TLabel |
11 |
< |
Left = 16 |
12 |
< |
Height = 19 |
13 |
< |
Top = 16 |
14 |
< |
Width = 87 |
15 |
< |
Caption = 'Table Name' |
16 |
< |
ParentColor = False |
17 |
< |
end |
18 |
< |
object Label2: TLabel |
19 |
< |
Left = 19 |
20 |
< |
Height = 19 |
21 |
< |
Top = 84 |
22 |
< |
Width = 41 |
23 |
< |
Caption = 'Fields' |
24 |
< |
ParentColor = False |
25 |
< |
end |
26 |
< |
object Label3: TLabel |
27 |
< |
Left = 279 |
28 |
< |
Height = 19 |
29 |
< |
Top = 16 |
30 |
< |
Width = 29 |
31 |
< |
Caption = 'SQL' |
32 |
< |
ParentColor = False |
33 |
< |
end |
34 |
< |
object Label4: TLabel |
35 |
< |
Left = 23 |
36 |
< |
Height = 19 |
37 |
< |
Top = 285 |
38 |
< |
Width = 93 |
39 |
< |
Caption = 'Primary Keys' |
40 |
< |
ParentColor = False |
41 |
< |
end |
42 |
< |
object SQLText: TMemo |
43 |
< |
Left = 279 |
44 |
< |
Height = 328 |
45 |
< |
Top = 36 |
46 |
< |
Width = 439 |
47 |
< |
ScrollBars = ssVertical |
48 |
< |
TabOrder = 0 |
49 |
< |
end |
50 |
< |
object Button1: TButton |
51 |
< |
Left = 552 |
52 |
< |
Height = 30 |
53 |
< |
Top = 380 |
54 |
< |
Width = 72 |
55 |
< |
Caption = 'OK' |
56 |
< |
Default = True |
57 |
< |
ModalResult = 1 |
58 |
< |
TabOrder = 1 |
59 |
< |
end |
60 |
< |
object Button2: TButton |
61 |
< |
Left = 640 |
62 |
< |
Height = 30 |
63 |
< |
Top = 380 |
64 |
< |
Width = 72 |
65 |
< |
Cancel = True |
66 |
< |
Caption = 'Cancel' |
67 |
< |
ModalResult = 2 |
68 |
< |
TabOrder = 2 |
69 |
< |
end |
70 |
< |
object TableNamesCombo: TComboBox |
71 |
< |
Left = 23 |
72 |
< |
Height = 30 |
73 |
< |
Top = 38 |
74 |
< |
Width = 201 |
75 |
< |
ItemHeight = 0 |
76 |
< |
OnCloseUp = TableNamesComboCloseUp |
77 |
< |
ParentColor = True |
78 |
< |
TabOrder = 3 |
79 |
< |
end |
80 |
< |
object FieldList: TListBox |
81 |
< |
Left = 21 |
82 |
< |
Height = 170 |
83 |
< |
Hint = 'Select Fields to include in Update Statement, or leave unselected to select all' |
84 |
< |
Top = 102 |
85 |
< |
Width = 204 |
86 |
< |
ItemHeight = 0 |
87 |
< |
MultiSelect = True |
88 |
< |
OnDblClick = FieldListDblClick |
89 |
< |
ParentShowHint = False |
90 |
< |
ShowHint = True |
91 |
< |
TabOrder = 4 |
92 |
< |
TopIndex = -1 |
93 |
< |
end |
94 |
< |
object Button3: TButton |
95 |
< |
Left = 280 |
96 |
< |
Height = 30 |
97 |
< |
Top = 380 |
98 |
< |
Width = 112 |
99 |
< |
AutoSize = True |
100 |
< |
Caption = 'Generate SQL' |
101 |
< |
OnClick = Button3Click |
102 |
< |
TabOrder = 5 |
103 |
< |
end |
104 |
< |
object Button4: TButton |
105 |
< |
Left = 416 |
106 |
< |
Height = 30 |
107 |
< |
Top = 380 |
108 |
< |
Width = 66 |
109 |
< |
Caption = 'Test' |
110 |
< |
OnClick = Button4Click |
111 |
< |
TabOrder = 6 |
112 |
< |
end |
113 |
< |
object QuoteFields: TCheckBox |
114 |
< |
Left = 16 |
115 |
< |
Height = 22 |
116 |
< |
Top = 380 |
117 |
< |
Width = 144 |
118 |
< |
Caption = '&Quote Identifiers' |
6 |
> |
ClientHeight = 512 |
7 |
> |
inherited Button1: TButton |
8 |
> |
Top = 457 |
9 |
> |
end |
10 |
> |
inherited Button2: TButton |
11 |
> |
Top = 457 |
12 |
> |
end |
13 |
> |
inherited GenerateBtn: TButton |
14 |
> |
Top = 457 |
15 |
> |
OnClick = GenerateBtnClick |
16 |
> |
end |
17 |
> |
inherited TestBtn: TButton |
18 |
> |
Top = 457 |
19 |
> |
end |
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 |
205 |
< |
Height = 59 |
206 |
< |
Top = 304 |
207 |
< |
Width = 200 |
208 |
< |
ItemHeight = 0 |
129 |
< |
OnDblClick = PrimaryKeyListDblClick |
203 |
> |
object IncludePrimaryKeys: TCheckBox[9] |
204 |
> |
Left = 24 |
205 |
> |
Height = 22 |
206 |
> |
Top = 465 |
207 |
> |
Width = 241 |
208 |
> |
Caption = 'Include Primary keys in Update SQL' |
209 |
|
TabOrder = 8 |
131 |
– |
TopIndex = -1 |
210 |
|
end |
211 |
|
end |